How to restrict the selected column in ssrs report while exporting report data

Question

0.00/5 (No votes)

See more:

SSRS-2008

When exporting the ssrs report is it possible to export only selected columns data should be exported into the excel or any format instead of all columns? Please advise.

What I have tried:

I searched for the options to hide the columns at the time of export.Not found any clue.

Posted 2-Apr-16 6:02am

Member 10227147

Updated 5-Apr-16 18:28pm

Add a Solution

Comments

CHill60 2-Apr-16 12:51pm

Why not just export the data directly from the table instead of putting it into a report first?

Member 10227147 4-Apr-16 3:35am

yes we can export directly from table but we need it as dynamically in report as a feature. Please suggest if any clues.

CHill60 4-Apr-16 9:50am

But you don't want all the data in the report going to excel? Have the report showing all of it but also have an export to excel

Member 10227147 5-Apr-16 8:01am

I need to show all the column data but after exported the data to excel only few columns should show. Please let us know if my exlanation is not clear.

CHill60 5-Apr-16 8:23am

Your explanation is not clear.
As far as I can tell you want the report to show everything but the excel data to only contain some of the columns.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

johnwalker10 · Answer 1 · 2016-04-05T18:28:00

Format options such as expressions on visibility are ignored for CSV rendering methods. CSV rendering methods are essentially data flows, so you can suppress elements that you don't want to include in CSV files by changing the DataElementOutput from Auto, the default value, to NoOutput.

https://blogs.msdn.microsoft.com/bimusings/2007/02/07/reporting-services-why-arent-all-my-report-columns-exporting-to-csv-andor-xml/

Arvind Zamakia · Answer 2 · 2016-04-02T08:37:00

Solution 1

hello try this condition

=IIF(Globals!RenderFormat.Name = "EXCEL" or Globals!RenderFormat.Name = "CSV",false,true)

Posted 2-Apr-16 8:37am

Arvind Zamakia

Comments

Member 10227147 4-Apr-16 3:05am

Thanks for the reply. I have tried the =IIF(Globals!RenderFormat.Name = "EXCEL" or Globals!RenderFormat.Name = "CSV",false,true) condition it is hiding the data when report runs and showing the data at the time of export. But i need to hide the column data at the time of export. please advise.