Hi,
I have a question in SSRS,
in my project I am going to give a option to the end user to create a report and directly exporting it to excel format to a particular library, but in my company there are certain list of empolyees who are catagerised a Super Users and Normal Users.

In my report there are almost 8 lakh records in every report and 110 columns for every record. In this columns, if the report is created by a Super User, it has to show all the 110 columns in the report, if it is created by a Normal User it has to show 100 columns only and the remaining 10 columns to be hide.

My question is, Is it possible to Hide columns in a report based on the end user who is creating a report?

Expecting reply ASAP?