How to change text in columns in SSRS?

I need to create a complex report and export it to Excel.

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.
LVL 9
abhinayp86Asked:
Who is Participating?
 
mnachuConnect With a Mentor Commented:
That kind of event driven is not in SSRS,.

One thing you can do is add a Report Type to your SSRS and based on the Report type user chooses show or hide columns.

Other solution is to export to EXCEl and do it using Macros but that is tuff and you probably need Office Writer for it.

Regards,
Nachi
0
 
abhinayp86Author Commented:
Thanks for the solution! I was trying to achieve it in SSRS since long!
0
 
abhinayp86Author Commented:
Is it possible that we can achieve it by using linked reports or sub-reports? or by using expressions?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
itcoupleCommented:
Hi

If I understand correctly I think this is possible. You can:

1)  use 'toggle item' to show/hide columns (I've done that in the past). Change header from show/hide to simething more generic like Daily Column (next to it you will get plus button to expand/collapse extra column)
2) Use action to jump to itself. This will actually refresh entire report but you can pass extra parameters (override default) ones to gain more control over the report.
3) I have done top 5 / bottom 5 on the same report with interactive sorting also dynamic header name changes :)

Regards
Emil
0
 
abhinayp86Author Commented:
Yes, I tried doing that way( adding a column and got a plus button to expand/collapse).

Can you elaborate of the second point? I am not sure how to do it? If I use  action to jump to itself how do the columns appear and disappear accordingly?
0
 
itcoupleCommented:
Hi

Did you expand/collapse not work?

Regarding jump to itself. My current understand is that you just want to hide/show the columns? so you can add parameter (hidden) and change visibility based on the parameter value.

It might be worth doing a screenshot that usually help me better understand the requirements.

Regards
Emil
0
 
abhinayp86Author Commented:
Yes, I want to show/hide columns and at the same time the text in the corresponding shud also change.

I am posting a few screenshots to help u understand better!
1.jpg
2.jpg
3.jpg
0
 
itcoupleCommented:
Hi

Would the example below work for you?

Regards
Emil
HideEnglish.bmp
ShowEnglish.bmp
0
 
itcoupleCommented:
I actually didn't know I can do that in SSRS :)
0
 
abhinayp86Author Commented:
Yaaaaaaaaaa... That willl work... :):)

Can u please tell me how you did that?

I open a new question so that i could award u points. U can reply there.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26412634.html

Thanks,
Abhinay

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.