Thomas, Thank You for your reply. That I know I can do those things and I am doing for some reports. However, The question was how I am able to Pull the fields that I need from 56 original template fields and rename those fields as need and schedule it. e.g
If I run Template report with below Variables
Client Name = ABC
Start Date = getdate()
End Date = RD +14
and hit "View Report", now I am seeing data with 56 columns. What I am looking, Client "ABC" just want to see only 9 fields out of those 56 fields and it could possible Client "ABC" want to see 9 fields in a different header name.
My real question is, how can I accomplish this task in SSRS. Is it possible in SSRS or not?
Thank You.
You can't customise a deployed report, no. If the client wants to always pick and choose what columns and name they want, you'd be best supplying them all. Then the client can download the full file as an xlsx file, delete the columns they don't want, and rename the ones they want to rename.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk