Post reply

Report heading not displaying

  • March 15, 2010 at 2:12 am

    #386499

    Hi

    I have a report that uses cascading parameters and I am trying to have a report heading that will display accoridng to the selection a user has made.

    I tried the following :

    =IIF(Parameters!Consolidate.Value = "CONSOLIDATE", "Retail HeadCount : "& Parameters!EndPeriod.Value.ToString ,

    strConv(Parameters!Consolidate.Value,3) & " HeadCount : "& Parameters!EndPeriod.Value.ToString)

  • March 17, 2010 at 8:43 am

    #1135293

    Instead of .ToString try CStr(<parameter>)

  • March 18, 2010 at 1:39 am

    #1135769

    Hi Vishal

    Thsnks for the feedback, I tried it like you suggested but I'm still getting an error.

    =IIF(Parameters!Consolidate.Value = "CONSOLIDATE", "Retail HeadCount : "& Cstr(Parameters!EndPeriod.Value) ,

    strConv(Parameters!Consolidate.Value,3) & " HeadCount : "& Cstr(Parameters!EndPeriod.Value))

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

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