Post reply

Regarding IIF fuction in reporting services.

  • October 13, 2008 at 3:47 am

    #383044

    Hi all,

    I am facing a problem in Calculated member function in Reporting Services it’s not returning required value , please help me : this is the function

    (IIF([Dimension Sector].[Dimension Sector]<> 0,

    [Measures].[Total Revenue]/[Dimension Sector].[Dimension Sector],0),

    "##.00;(##.00);0.00;#.00")

    It’s returning me null value in all the column

  • October 13, 2008 at 6:48 am

    #884117

    IIF is a function available in Microsoft Access database and not in a SQL database. You have to use CASE instead.

    Sample from BOL:

    SELECT ShipVia, CASE ShipVia

    WHEN 1 THEN 'A.Datum'

    WHEN 2 THEN 'Contoso'

    WHEN 3 THEN 'Consolidated Messenger'

    ELSE 'Unknown'

    END

    FROM Orders

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • October 13, 2008 at 6:55 am

    #884120

    Thanks to Reply .

    Actually i am working on Reporting services there i need to implement some business logic to get required data from OLAP Cubes , basically from measures data for specific dimension . for that i was using that function , but i am facing some problem in above mention format , not getting required data .

    Regards

    Alok

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply