Based on parameter input - report column hiding

Question

Based on parameter input - report column hiding

yudy.varma

Right there with Babe

Points: 755
More actions
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..

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

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

bhupendra.patel Mr or Mrs. 500 Points: 508 More actions · Answer 1

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

yudy.varma Right there with Babe Points: 755 More actions · Answer 2

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

bhupendra.patel Mr or Mrs. 500 Points: 508 More actions · Answer 3

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