SSRS Table row should be visible and Invisible based on Input parameter

siddisagar

I have one table with two rows in tables 1. Employee Details 2. Employee History Details Depending on my input parameter I have to show only one row and other I have to show to make hide if @hisId=0 then I have to show Tablerow1 if @hisId=1 then I have to show Tablerow2 Kindly Tell me solution.

Not Active

You can't hide individual rows but you can filter the dataset so only the required rows are rendered

I know the language. I've read a book. - _Madmatt

nainakarri

You can go to properties of each row and give validation there. Rightclick row->properties->visibility->Expression. There give the validation for each row seperately. (I mean this u need to do seperately for each row)

=IIF((Parameters!hisid=0,false,true) //this is for tablerow1
=IIF(Parameters!hisid=1,false,true) //this is for tablerow2

Naina

Not Active

The rows in a ssrs table are rendered dynamically based on the dataset assigned, you can't control the individual table rows in this way.

I know the language. I've read a book. - _Madmatt

nainakarri

But i have implemented the same.

Naina

sashidhar

You may have done for values in the row not for the complete one..! Tht guy is asking for complete Row..! Just think it you will find the solution.

LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

nainakarri

Does 2 rows in table mean "In SSRS 2 rows in a single table" If so as per my knowledge i have worked on this kind of scenario of hiding rows based on parameter value as i have mentioned in my first post.

Naina

Not Active

I doubt that very much. Prove it. Show an application of it or write an article.

I know the language. I've read a book. - _Madmatt