Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-25 : 16:11:37
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-26 : 06:16:17
|
| 1. you can either add them as static columns and then add expression for visbility property to determine which of them needs to be hidden and which of them to show.2.you can add place holders for that in the report for 4 columns. what will they be displaying? static text or parameter based info?3. you need to add a separate version of report with only the required columns for that. then call report through URL with format being passed as PDF.The above points all are based on static column selection. If you attempt is to have maximum flexibility and choose columns at run time etc then you need to use report builder application to create the report. For that you need to have a report model being deployed to the server.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-26 : 09:47:17
|
| Can you explain more about what you mean for the statement 'you can add place holders for that in the report for 4 columns. what will they be displaying? static text or parameter based info?' I will have 4 static fields. Three fields before the 4 static fields will display for the excel export. For the pdf format, there will be 2 fields following the 4 static fields. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-26 : 09:55:47
|
quote:
Originally posted by jassie
Can you explain more about what you mean for the statement 'you can add place holders for that in the report for 4 columns. what will they be displaying? static text or parameter based info?' I will have 4 static fields. Three fields before the 4 static fields will display for the excel export. For the pdf format, there will be 2 fields following the 4 static fields.
i meant you need add blank columns in report designer and add any static data you want to display in it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssrs 2008 r2 number of columns displayed