Very Urgent Please help me
I have 6 tables (table 1, table 2, table 3,table4, table 5,table 6 ) in my report each table has its own data source. 3(table 1,table 2,table 3) of the 6 table are having parameter value 1 and remaining 3 tables (table 4, table 5, table 6) has another parameter value 2. so when I when i choose parameter value first three tables( table 1, table 2, table 3)should be shown and the remaining 3 tables(table 4, table 5, table 6) needs to be hide, when i choose parameter value 2 remaining 3 tables (table 4, table 5, table 6) needs to be shown and first three tables(table 1, table 2, table 3) needs to be hided. can any one tell me the approach how gain this very important please help me with as much as u can ....
October 18th, 2011 8:44am

Hi, What about the visibility property of the tablix? you can use expression to hide/show your tablix(es)/tables based on the parameter values. I hope it helps. J.There are 10 type of people. Those who understand binary and those who do not. Blog
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 8:53am

Hi Janos, I am sorry I forgot to say that I am working in SSRS 2005
October 18th, 2011 9:01am

Hi, In this case you can use the table Visibility.Hidden property if I remember well. I hope it helps. J.There are 10 type of people. Those who understand binary and those who do not. Blog
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 9:23am

Hi Nag1234 You Can use write click on table and use table visibility property & put the Below Expression for Table 1,Table 2 & Table 3. Just change the True & False part for rest of the table. SUHAS http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
October 18th, 2011 9:40am

Hi Suhas Can you explain in SSRS 2005. I have 6 tables in one .rdl and need to hide table 4,5,6 when i i choose parameter value 1 display tables 1,2,3 when i choose parameter value 2 i need to display tables 4,5,6 and hide tables 1,2,3 Note: Parameter has drop down with only two values. value 1 and value 2
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 12:22pm

Hi Janos Can you explain in SSRS 2005. I have 6 tables in one .rdl and need to hide table 4,5,6 when i i choose parameter value 1 display tables 1,2,3 when i choose parameter value 2 i need to display tables 4,5,6 and hide tables 1,2,3 Note: Parameter has drop down with only two values. value 1 and value 2
October 18th, 2011 12:22pm

Hi, I belive it answered by Suhas with screenshots of my proposal. J.There are 10 type of people. Those who understand binary and those who do not. Blog
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 2:17pm

Thats Right looks so cool
October 18th, 2011 2:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics