Post reply

Based on parameter input - report column hiding

  • April 22, 2011 at 11:31 pm

    #249326

    i have 2 column names to display Asset Name and Item name and 2 parameters Asset Name and Item name

    based on the selection of particular parameter i want to hide the respective column ,if it is possible can any one tell me how to do this..

  • April 22, 2011 at 11:51 pm

    #1315089

    Hi Yudy,

    I assume you are talking about SSRS report here. To show or hide the columns you can use the Column Visibilty property. If you select the column you want to show or hide then select column visiblity then show or hide column based on expression. Now use the expression to evaluate the paramters.

    Hope this helps

    Cheers,

    Bhupendra

  • April 23, 2011 at 1:40 am

    #1315104

    thank you,

    in SSRS 2005 there is option to separate thousands(1,234,567,890).but i need in lakhs separator (1,23,45,67,890)...

    do you have any idea how to do this.. if u do ..please explain it clearly

  • April 23, 2011 at 8:40 am

    #1315134

    Hi Yudy,

    I dont have access to SSRS 2005 but i guess its not that different from SSRS 2008. On the report properties go to Property Language - set it to English(India). Now on the field you want to set the formatting set the value as

    FormatNumber(Fields!Total.Value,2) or FormatCurrency(Fields!Total.Value,2) whichever you require.

    Hope this helps.

    Cheers,

    Bhupendra

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

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