ssrs 2008 r2 number of columns displayed

Question

ssrs 2008 r2 number of columns displayed

wendy elizabeth

SSCoach

Points: 16915
More actions
November 25, 2013 at 2:13 pm

#300870

In an existing SSRS 2008 r2 report, I have a question about how to display certain columns:
1. I want selected columns to display when running the SSRS reports,
2. I want the columns in the ssrs report plus 4 other columns displayed when the report is exported to excel.
3. I want a subset of columns selected when the ssrs report is exported as a PDF document.
Thus can you tell me if what I am requesting is possible? If this is possbile, can you tell me, show me, and/or point to a url that explains
how to accomplsh this task?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323546 More actions · Answer 1

i see how to show/hide columns based on wether they are exported or not here:

https://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/#hr8

but i don't see how to filter based on the export type yet.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 2

It's possible to change the layout based on the export format:

Hide/Show Items Dependant On Export Format (SSRS)[/url]

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

wendy elizabeth SSCoach Points: 16915 More actions · Answer 3

The following link does not work: https://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/#hr8

Can you tell me what is the url (link) that actually works?