SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 r2 number of columns displayed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jassie
Constraint Violating Yak Guru

291 Posts

Posted - 11/25/2013 :  16:11:37  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 11/26/2013 :  06:16:17  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

291 Posts

Posted - 11/26/2013 :  09:47:17  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 11/26/2013 :  09:55:47  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000