SQL Reporting Services Tip - Launching Reports

Friday, January 27, 2006 8:44 AM Filed under:

General

SQL/Data

SQL Reporting Services Tip - Launching Reports

I was playing around with various ways to launch SQL Reporting Services reports and came across a good tip. If you work with SRS then you'll likely know you can launch a report by simply accessing the Uri to the report. For example, to launch/display a report called MyReport (at the root of the report server) you would launch the following in a browser:

http://MYSERVER/ReportServer?MyReport&rs:Command=Render

BTW, you can also omit the “rs:Command=Render” at the end since that will be the default behavior anyway. But something cool you can also do (and this is the tip part I wanted to share) is that there are also other RS format types available that you can specify to export the report directly. If you wanted to export the same report automatically to Excel you would use the following Uri to the report:

http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=Excel

That is pretty cool. If you wanted to export the report to a CSV file (or other formats too) you can specify that as well, and even indicate the delimiter too. For example, to export to CSV and use a Tab (ascii 9) as the delimiter you would use the following:

http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09

You can use any of the following: HTMLOWC, MHTML, PDF, IMAGE (for a Tiff file), CSV, and XML.

Comments

Matthew 1/30/2006 12:33 PM

Hi,

Any idea how to make sql export CSV reports as ANSI not Unicode? We have a client who wants CSV data - but this then does not open well in Excel due to the encoding.

Don't ask why they don't just export as Excel...

Cheers,
Clemens 2/7/2006 12:39 AM

Search for device settings in reporting services.
You can set the encoding with a url parameter.

I think this should point to it:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_5l7q.asp

Clemens
Ryan Farley 2/7/2006 6:11 AM

Wow. Great link Clemens. Thanks!

-Ryan
Sam 3/23/2006 10:44 AM

If render a report is possible as ANSI. Then how can I have a subscription email a report as an ANSI?

Thanks,
Sam
chad 6/5/2006 2:44 AM

Any idea how to block out the "export" option all together? I'm creating dynamic RDL files on the fly, uploading them to the RS and then browsing to the URI - I'm pretty sure there should be an RS / RC command that disables the "export" option but I cant seem to find it.

Thanks
Vinod Ramkumar 7/27/2006 12:52 AM

Do i have to have MS Office installed on the server which renders the reports to be able to export the reports in excel.
Ryan Farley 7/27/2006 8:36 AM

Vinod,

Nope, no need for Office installed (it doesn't use office automation to generate the file)

-Ryan
Ron 8/30/2006 8:06 AM

When making the format Excel, is there anyway to get by the "File Download" box, so that the excel doc opens right up? It's the box that asks if you want to "Open", "Save", or "Cancel" the download. Thanks.
Ryan Farley 8/30/2006 8:12 AM

Ron,

You would have to modify the settings for the XLS file type on each machine to open automatically without the prompt.
Sunil 10/12/2006 9:06 AM

My question is similar to last Question from Ron.
Is there anyway to get by the "File Download" box, so the Excel, PDF files open right up.
What setting and where exctly we need to change.

Thnaks.
Ryan Farley 10/12/2006 9:18 AM

Sunil & Ron,

What you're wanting is a per-pc setting - not something you can control from the server.

To change this on a pc (not on the server), you go into Folder Options (ie: open an explorer window and go to "Tools" and "Folder Options". Then on the File Types tab, select the file type's extension (such as XLS), then click the Advanced button and uncheck the "confirm open after download" option.

-Ryan
Sunil 10/12/2006 10:24 AM

I see that check box already "unchecked", and still I see the Download File box. I am having Internet Explorer 6.0.2900, Update Version: SP2.
OS is Windows XP Professional.

My reports are in PDF format. also I want that report opens in the browser, not in saperate Adobe Acrobat window.

Thanks.
Ryan Farley 10/12/2006 10:41 AM

If you want it to open in the browser, why not just let the report open normally (instead of exporting it to PDF)?

Clearing that checkbox worked for me. You do have a PDF reader installed (such as Acrobat) on the pc and set to be the default to handle shell open requests for PDFs, right?
Sunil 10/12/2006 10:55 AM

My client wants the reports in PDF.
I have Adobe Reader 6.0 installed, I dont think I set it to default to open PDF files. In case, Do you know how to disable this option.

I want my PDF reports open in same browser window, without asking "File Download" box.

Thanks.
brian 11/3/2006 10:11 AM

When exporting a report to excel, is it possible to keep the properties around numeric values? More specifically - when exporting a report into excel, all of the numbers in a currency column are stored as text once placed into excel. Is there a way to keep them as a currency value?

thanks
Chris 12/13/2006 2:44 AM

Hi,
I wish to generate a report using Reporting Services 2000 that exports the data into an Excel file in which the different tables in the report should be exported into different sheets in the same excel file. Is there any option to export like this. Kindly help me!!!
Thanks in advance!!!
Regards,
Chris
Ryan Farley 12/13/2006 4:55 AM

Chris,

Won't be able to do it with SSRS, you'll have to write something custom to do that.

-Ryan
Cathy 12/13/2006 10:28 AM

when the user exports a report with page header text to Excel. The excel file is perfectly readable and the cells can be edited. The problem is that it merges several columns. This makes it impossible to change the sorting columns. What is the fix to that and does Microsoft knows that bug?
Chris 12/13/2006 7:16 PM

Thanks a lot Ryan!!!

Regards,
Chris
Manny 12/20/2006 3:09 PM

Hello
I would like to save reports (to PDF Format) on the fly passing the parameters and values directly from a stored procedures. Is this possible?
I had to write a CLR dll to accomplish this but it seems to fail on any output greater than 5MB

Thanks in advance
Ryan Farley 12/21/2006 8:45 AM

Manny,

Maybe you could just launch the URL for it instead of generating it from within your DLL?

ie:

http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=PDF&myparam1=Value1&myparam2=Value2

You can pass parameter values on in the query string. They just need to match the parameter names (and they are case-sensitive)
badri 1/4/2007 8:28 PM

hi, u can get the different tables to different pages by checking the box "page break after this table" this will get your report into differnt pages and when u export it into excel u will get them in different sheets. no probs.
bruce 1/4/2007 11:47 PM

i am trying to launch a report in pdf format, on one account it works fine, but on another which has all the same permissions(as far as i can tell) it says its opening the file but it never does anything. any suggestions?
Navish Singh 2/19/2007 4:56 AM

Hi There!

Please help! I can create reports using Visual Studio .NET 2003 and I can connect to a database to create that report, the problem is, I can't get the report to update itself, as the information in the database changes.

If you can please help me to identify why my report is not updating on its own and how to properly deploy this report? If you deploy a report, do you only need to copy the .rdl file to the location that you want to deploy the report to? Do you also need to copy the pdf file to the same location?

As you may have already identified, I am new to this sort of thing and I need to find the solution to this asap. I got a job at a new company and this is one of my requirements. I really need your help, so that I don't end up losing this job.I'm tyring my best but clearly my best is not good enough.

Please help me to resolve this problem. Am I just missing something when I create the reports? Please help asap! I appreciate any help you can provide.
Trupthi 2/24/2007 11:42 PM

Hi Ryan,

I have a similar problem to the one posed by Sunil and Chris. I would like to open the PDF and excel in the same browser window. Kindly tell me how this can be done.
Gabby 2/28/2007 7:50 AM

Does anyone know how to have a report not run by default? I only want the report to run when you click "view report"

Thanks,
Gabby
Victoria 2/28/2007 10:16 AM

I am having the same issue as Cathy 12/13/2006 10:28 AM
When the user exports a report with page header text to Excel. The excel file is perfectly readable and the cells can be edited. The problem is that it merges several columns. This makes it impossible to SORT the DETAIL columns in EXCEL.
Anybody know a workaround?
Shankar 3/5/2007 1:04 AM

My requirement is : I am using ReportViewer control in an ASP.NET page to get the parameters and have set the server URL & report path. I need to save the resport as PDF file in a file share, when I bind the report with report viewer control. Any ways to do that?? .This is somewhat similar to manny's reqmt, but have to be done with report viewer control.

Thanks in Advance,
Shankar
Stu 3/21/2007 3:27 AM

Similar problem to Brian above. Exporting a date to Excel loses it format. Any ways around this?
prathesh 3/22/2007 3:15 AM

Hi,

I am using Reporting server 2000 and when i export the data in to Excel format that file will be readable in excel but it's not pure excel file means i can't use that file to import in some system as a ms-excel file because it's a HTML render file.

is there a way reporting server will export in to pure MS-Excel file format in 2000 not 2005.......
Mookie 3/22/2007 3:34 AM

I've got another problem: when client clicks "export to xls" and then clicks "open" in popup window, Microsoft Excel shows the error message "A DDE error has occured, and a description of the error cannot be displayed because it is too long? try renaming the file or copying it to a different folder."
I think it happens becouse the name of opening file is too long. But the "Save as" button work correctly.
This error ocuure only on clients computers, and on server don't. Can you explain me in what is the trouble?

P.S. sorry for my bad english, I'm from Ukraine )
Asish 3/25/2007 11:07 PM

Hi All,

When I try to Export my reprot to Excel, I am getting the first sheet Blank, means Page header will be there in the first sheet, data's will be on the second sheet only.

Please send a solution for this, it will be thankful

Thanks
Asish
Lloyd 3/30/2007 12:21 PM

Does anyone know of a way to define the file name of the Export file using a query parameter?
By default, it takes on the name of the report, but that means each record is saved to the same file name.

Thanks.

Lloyd.
Greek 4/8/2007 11:44 PM

hi,
If i try to export data in to CSV using SRS2000,The hidden columns are visible in CSV.how to solve this issue,any one knows help me.
Thanks
Kamran 4/23/2007 8:48 AM

I am using Reporting services 2000 and exporting them to PDF format, but all the PDF is in Unicode. Is it possible I can get them in Ascii code. My print doesn't support unicode for direct PDF printing.
Joseph Don 5/13/2007 8:16 PM

Hi,
Iam using the Sql reporting services as my data reporting tool. What I want to do is I want to set the print area and pagelayout automatically when the data is exported to Excel. In my case, tehe Page Layout should be "Landscape" and the page with is much bigger.So anyone having a solution for this king of problem, please Share.
Test 5/14/2007 4:51 AM

hi,
I am having a linked report. where when a user clicks the link i am pointing to a new report...

How to make the report to be launched in a new window instead of replacing the parent report
BryanJ 5/15/2007 7:25 AM

Hi,

Is there anyway that I can export to Word. My client want to automatically create the report export to Word and then do some additional editing.

I thought of using a PDF to Word converter, but I would like to find one that uses command line parameters so I could shell it from my application.

Any suggestions...

Anyway why on earth does it not export to Word!!!
Sankar 6/1/2007 1:26 PM

Is there a way in Reporting Services 2005 to have the default rending option for a report to be something? Like is it possible for a report to always render as a csv file when I choose the report from the report manager?
Santos 6/6/2007 6:35 AM

Hi,
I'm trying to print a report, but don't have acess to the Action menu. Is there a RS command to print a report?
Sree 6/7/2007 10:28 AM

Hi,

Is there any way i can name the different sheets when i export the report into excel? I did setup page break to export into different pages but having trouble to give the sheet names the way i want.
siva 6/19/2007 3:09 AM

I am using SQL Reporting services 2005. i want to generate multiple reports ( eg i am using for loop and passing the parameters to the url). i am getting the open,save dialog box . but what i want is the report should save to the local hard disk automatically is there is any way for that if so please help me.

Thanks

Siva
yuva 6/21/2007 11:32 PM

I have 1 lakh records in my report, when i export to excel, i gives an error, as the excel have only 64000 rows. how can i fix the issue by having
first 64,000 in one sheet and next 64000 in other sheet.
mariano 7/5/2007 8:19 AM

Export to excel in reporting service in windows2003 and apeears this text
and more symbols

MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related;boundary="----=_NextPart_01C35DB7.4B204430"

This is a multi-part message in MIME format.

------=_NextPart_01C35DB7.4B204430
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: base64
Content-Location: file:///c:/Report.htm
Krishna Joyodiharjo 7/31/2007 12:51 AM

One work around to open PDF or other report formats in the same browser window is by overriding the "Content-Disposition" http header from "attachment" to "inline". Only effective if you have access to the IIS host.

Set this header using IIS console for reportserver virtual directory should do it. However it is much better to create a new vitual directory that map to the reporting services application and set everything (security, isapi mapping in application configuration) exactly the same as the reportserver virtual directory. Then use the reportserver virtual directory for interactive reports, and use the new directory for the static PDF format.

Note: the browser may receive both content disposition header, with IE usually the first one is the IIS default that is taken and the following one from reporting services application is ignored.

Not guaranteed to work for specific setup, but takes only a few minutes, definitely worth a try.
Oakland Raiders 8/17/2007 12:50 PM

FYI, if trying to launch images, particularly jpg, there are several issues. One, the print button and preview buttons will take forever to launch report. Second, if you try this method of auto launching image reports to PDF, there will be some photos that break reports. Both issues are do to the jpg decoder used for SSRS.

http://myserver/ReportServer?MyReport&rs:Command=Render&rs:Format=PDF&myparam1=Value1&myparam2=Value2

As a work around, launch report directly to TIF instead of PDF as follows:
http://myserver/ReportServer?MyReport&rs:Command=Render&rs:Format=IMAGE&myparam1=Value1&myparam2=Value2

Unsure as to when Microsoft will have a hotfix.
Navster 8/19/2007 3:54 PM

Hi I am trying to run the report as suggested at the start of this post, ie

http://MYSERVER/ReportServer?MyReport&rs:Command=Render

However I am unable to do this could any one point me in the right direction.
Monir 8/22/2007 8:10 AM

When exporting a report XL I would like to the Sheet name in XL to be the title of my Document Map Title in Reports. Is there any way I can do it?
Monir 8/22/2007 8:11 AM

When exporting a report to XL I would like to see the XL WorkSheet title (i.e. Sheet1..Sheet20) to be the title of my Document Map Title in Reports. Is there any way I can do it?
Liliane 8/30/2007 10:55 PM

To Greek, there is a property for the field called "DataElementOutput", you can choose "NoOutput"
scott lancaster 9/12/2007 6:18 PM

Anyone know why when running in Sharepoint Mode, that when you setup a schedule to email a attached report in excel format, it names the attachement with 2 file extensions. ir report.rdl.xls

This is causing me problems trying to email through firewalls and virus scanners..

Please reply to slancaster@gates.com if you have any ideas!!

thanks
scotty
Dimeji 10/29/2007 6:36 AM

Hey Ryan,

got a kinda trivial problem here with exporting to excel. On my local machine i run a report it exports fine. But on another server (production) the same report is ran and on exporting multiple report item tables show up which are suppose to be hidden. I guess the first thing anyone would've looked at was the report server settings on the remote machine (unfortunately i dont have access to that). Other than that the only thing i can do is make continuous changes on the rdl file.
Dunno what to do...
ben 10/31/2007 6:23 AM

Hi,
I was wondering if anyone had an answer for this earlier post. I am having the same issue:

Is there any way i can name the different sheets when i export the report into excel? I did setup page break to export into different pages but having trouble to give the sheet names the way i want.
Prathap 11/18/2007 9:05 PM

I am using SQL 2000. When i try to export a report to excel i get some of the rows repeating. What could be the problem?
Arun 11/19/2007 11:32 AM

This question is similar to the one asked by Joseph. We are in need of adjusting the print option automatically after opening the report in excel. We need to set the print option to landscape through program. We are using the render method in the reporting services and we are using the "Export to Excel" format.

Thanks
Arun

-----
Joseph's Question
=============

Hi,
Iam using the Sql reporting services as my data reporting tool. What I want to do is I want to set the print area and pagelayout automatically when the data is exported to Excel. In my case, tehe Page Layout should be "Landscape" and the page with is much bigger.So anyone having a solution for this king of problem, please Share.
Satish 12/4/2007 10:50 AM

Any Idea how to do this in report server config files? I tried the following everything except eh fielddelimiter seems to be working.
<Extension Name="TEXT" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-us">Text</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter><![CDATA[%09]]></FieldDelimiter>
<Extension>txt</Extension>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
RG 12/19/2007 5:53 AM

My requirement is : I am using ReportViewer control in an ASP.NET page to get the parameters and have set the server URL & report path. I need to save the resport as PDF file in a file share, Any ways to do that??. but have to be done with report viewer control.

Thanks in Advance,
RG
CJ 1/7/2008 11:46 AM

When I open the report using &rs:Format=PDF, I see 'To help protect security, IE blocked the site from downloading files...Click here for options' meesage. How do I avoid seeing this and go directly to the open dialog box?

Thanks
sheetal 1/28/2008 11:43 PM

Please let me know How to rename worksheets after rendering the report in excel format?
Ramya 2/14/2008 8:05 PM

Hi, I have a issue with export to excel. I am able to generate the report and view in the IE; but am not able to export it to excel. It asks for my SQL server login authentication everytime I export to excel. I use RS 2000 and have Browser permission set in the Report Manager. Please help!
BS 2/26/2008 6:42 AM

Does anyone know how to use the multi-column function in SSRS 2005, cause you can set the report properties to have two columns, but I have one simple table that I want to automatically go to that second column instead of on to the next page?
kiran nelluri 3/20/2008 1:29 PM

Hi,

I do have page breaks set on my groups of some reports and they are working perfect but when i export to excel, i see that each page is placed in a new worksheet. is there a work aound for this issue. I want the reports to be on same worksheet when i export but they should have page breaks since users want to print them into pages and redistribute them to groups.

Do you think i can set peoprties of my reports folder so that i switch off when i export to excel [probably a script that will switch off page breaks ....]. Please advise.

Kiran Nelluri
Ankur Mittal 3/24/2008 9:08 AM

Hi,

We are using the following command to render a report as PDF.

http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=pdf

We are running into an issue when one of our customers (Fortune 100 client) accesses the report from within their Network from a server outside their network, the Microsoft File Download box does not show up. We have confirmed that if the Proxy Server is removed, the File Download box shows up just fine.

Do you know what could be the casue of this problem?? Please help...

Ankur
Test 4/22/2008 7:20 AM

Hi, is there any way to bind a map image to a sql reporting service
Charu 4/22/2008 10:05 PM

I have about 15,000 rows in the report. Export to excel is taking a lot of time. Is there any way i can speed up the export to excel.
Charu 4/23/2008 3:48 AM

Introducing page breaks in the report made records appear in 3 sheets rather than one. This reduced the time to export to excel considerably.
please let me know if there ia another way of speedig it up.
Damodar Baliga.B 4/24/2008 2:50 AM

I have a Issue,
The moment we generate a large report and click on the Export button to PDF, I get Network Credential box asking me the User Name, Password and Domain Name.

Really confused what to do, Can anybody help.
Nancy 6/18/2008 7:02 AM

I saw an earlier post on this but no answer. Is there a way to pass the filename in the URL. I want to automatically save the file in a specific share and following a naming convention. I'm trying to output to PDF but I'm guessing if there is a method it would work for any format.
Soniya 6/18/2008 6:55 PM

hi,
There is layout tab in the reports property where we can specify the page width/height according to the requirement. for e.g.for A4 paper Size it should be (21*29.7 cm) or( 8.26 inch*11.4inch).
But I think this works out only for PDF reports and not for Excel reports, So setting the print option to landscape with particular paper size would only be possible through code.. i.e render the report and save it at some location and then handle the settings of the Excel through code and then open it after saving it.

Similarly naming of different excel sheets is possible through code.

.Net code for setting the print option to landscape :
-----------------------------------------------------------------
public void ExcelPageSetUp(string strPageSetUpSize, string strPageSetUpOrientation , Excel.Worksheet objWorkSheet)
{
string strMethodName = "ExcelPageSetUp";
ExcelApp objExcel = new ExcelApp();
try
{
if (strPageSetUpSize == Constants.PAGESETUP_PAGE_SIZE_A3)
{
objWorkSheet.PageSetup.PaperSize =Excel.XlPaperSize.xlPaperA3;
objWorkSheet.PageSetup.FitToPagesWide = Constants.CONST_ONE;
objWorkSheet.PageSetup.FitToPagesTall = Constants.CONST_ONE_THOUSAND;
if (strPageSetUpOrientation == Constants.PAGESETUP_PAGE_ORIENTATION_LANDSCAPE)
{
objWorkSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;
}
else
{
objWorkSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlPortrait;
}

}

.Net code for Naming the Worksheets of a workbook :
-----------------------------------------------------------------
public void NameSheets(string strExcelFilePath)
{

string strMethodName = "NameSheets";

string strReportType = null;
ExcelApp objExcel = new ExcelApp();

try
{

objExcel.objXLApp.Visible = false;
Excel.Workbook objWorkbook = objExcel.objXLApp.Workbooks.Open(strExcelFilePath, true, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value);

strReportType = hdn_ReportType.Value.ToString();
switch (strReportType)
{
case Constants.SERVICER_REPORT:
{
Excel.Worksheet objWorkSheet1 = (Excel.Worksheet)(objWorkbook.Worksheets[1]);
objWorkSheet1.Name = Constants.SERVICER_LENDER_COVER_SHEET_NAME;

ExcelPageSetUp(Constants.PAGESETUP_PAGE_SIZE_A3, Constants.PAGESETUP_PAGE_ORIENTATION_LANDSCAPE, objWorkSheet1);

Excel.Worksheet objWorkSheet2 = (Excel.Worksheet)(objWorkbook.Worksheets[2]);
objWorkSheet2.Name = Constants.SERVICER_DISCLAIMER_SHEET_NAME;

ExcelPageSetUp(Constants.PAGESETUP_PAGE_SIZE_A3, Constants.PAGESETUP_PAGE_ORIENTATION_LANDSCAPE, objWorkSheet2);

Excel.Worksheet objWorkSheet3 = (Excel.Worksheet)(objWorkbook.Worksheets[3]);
objWorkSheet3.Name = Constants.SERVICER_PAYMENT_SHEET_NAME;

ExcelPageSetUp(Constants.PAGESETUP_PAGE_SIZE_A3, Constants.PAGESETUP_PAGE_ORIENTATION_LANDSCAPE, objWorkSheet3);

Excel.Worksheet objWorkSheet4 = (Excel.Worksheet)(objWorkbook.Worksheets[4]);
objWorkSheet4.Name = Constants.SERVICER_INTEREST_SHEET_NAME;

ExcelPageSetUp(Constants.PAGESETUP_PAGE_SIZE_A3, Constants.PAGESETUP_PAGE_ORIENTATION_LANDSCAPE, objWorkSheet4);

objWorkbook.Save();
objWorkbook.Close(false, strExcelFilePath, Missing.Value);

objExcel.objXLApp.Workbooks.Close();
System.Runtime.InteropServices.Marshal.ReleaseComObject(objWorkSheet1);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objWorkSheet2);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objWorkSheet3);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objWorkSheet4);

}
break;

Thanks Soniya.
Corine 7/8/2008 12:03 PM

I've build a report in SSRS 2005. The report display 1 to 2 items per page. I currently have a report that reads 1 of 15. When I export to excel it applies each page from SSRS to individual sheets in excel. So I have an excel report with 15 sheets. I would like for the report to export in excel and all data be listed on one sheet not 15. Thanks
Corine 7/8/2008 12:05 PM

I've build a report in SSRS 2005. The report display 1 to 2 items per page. I currently have a report that reads 1 of 15. When I export to excel it applies each page from SSRS to individual sheets in excel. So I have an excel report with 15 sheets. I would like for the report to export in excel and all data be listed on one sheet not 15. Thanks
Joe 7/15/2008 5:29 AM

Hello,

Several people asked the question about having reports exported to Excel keep only one sheet rather than several sheets.

Hard or physical page breaks (set on data regions or rectangles) will create a new sheet in Excel. Soft or logical page breaks (created by the InteractiveHeight report property) do not affect the Excel output. There is no way that I know of to have Excel "ignore" the physical page breaks in a report.
Rob 8/27/2008 1:12 PM

Hey there. Great post!

Any idea how I would open a report via a uri but manage the security of the windows authentication based on a passed parameter? For example, I want to open a time sheet report for a user, but if they just go manipulate the uri themselves, they could change the parameter to point to anyone else's timesheet. I capture their itentity from the ASP.NET page, but how can I use that information in the generated report?
Jeff 8/28/2008 9:49 AM

Does anyone know where to put the .net code that Soniya provided for the naming of the sheets in excel. I just dont know where to put the code in the .rdl. Thanks
C.Penhall 10/6/2008 7:52 AM

You can get rid of the single-column export by changing your encoding to ASCII.

1. Modify rsreportserver.config. Replace the existing <Extension Name="CSV"../> line with the following:


<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>

2. Restart IIS
Lewis 10/21/2008 3:53 AM

Hello all,

I'm new to SRS and I don' know how to solve this:
When I launch a report from a third application, report server ask for authentication. It is possible to launch this reports without entering any credentials? Thank you very much.
raffy 11/13/2008 6:22 AM

hi, please help me solve the ff issues.

1. When i export a report from SQL reports 2005 the image logos is

distored a bit, and the sheets are locked so further edit and sorting is not

possible.

2. when i unlock the the freezed cells, to allow sorting and edit, the

whole sheets are scrambled due to merged cells used by headings and logos

etc. how to fix this. i mean, how can i edit a sheet without messing the

whole look of the report sheet.

if the above problems cannot be solved or let say its a sort of

limitation, please do advise or atleast explain to me why.

thanks and hope to hear a positive solution soon.
Sami 11/14/2008 11:36 AM

Hi Everyone,

Instead of a save button that exports the report in various formats, I am trying to place Icons for excel, html and pdf that when clicked export the report to their respective format. what web method or service call should I use and how ?

Thanks in advance.
schmack 11/27/2008 9:02 AM

how can I send the "file name" in the url??

like:

http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=Excel&rs:FileName=test.xls

?????????????????

thanks
Bhushan Laddad 11/29/2008 1:21 AM

Hi Ryan,
I am exporting a SSRS report to Excel via Report Viewer Control Toolbar. But The report get exported to Excel along with a Document map page. Is there any way to avoid Document map sheet in excel report?
Bhushan Laddad 12/1/2008 1:46 AM

Hi Ryan, pls provide me the solution, it's urgent..I need ur help
Andy 12/17/2008 9:45 AM

Hi,
I have developed a report using SSRS. The report is delivered through email as an excel attachment. Please suggest me a way to include year and month in the excel file name.

Thanks
Andy
hbjh 12/18/2008 9:30 AM

knm
Ramu 1/2/2009 2:58 AM

When export a report from reportserver, the images are exporting.

Is there any properties to change, or any other way?

Regards,
Ramu
1/21/2009 10:19 PM

Using reporting services | keyongtech
AHall 1/27/2009 7:44 AM

Ryan, our firm is trying to produce reports (in pdf format) via data-driven subscription and publish those reports inside of the report viewer folder (http://dcsql08/Reports/Pages/Folder.aspx). We are attempting this in order to keep the SRS security in tact for our users. We have figured out that we must publish to an external network share and then upload each of the 54 reports one-by-one, so that they may be viewed in the report viewer folder. Is there any to publish directly to our desired space? thank you!
AHall 1/27/2009 7:45 AM

my apologies, we are running SQL Reporting Services 2000 now, but we have 2005 if necessary. Thank you.
bill 2/6/2009 8:55 AM

Is there a way to schedule a report so that the report automatically exports the file to excel and places the file in a specified directory?
Ryan Farley 2/6/2009 9:40 AM

@bill and @AHall,

You can do what you are after, but not without writing some code. You would need to either programatically read from the export URL, read the bytes returned in the stream and write them to a file, or use the API to generate the reports.

-Ryan
Nick 2/10/2009 12:37 AM

I have a windows form that hosts a reportviewer control which displays a server report. when the user is exporting the report to pdf, i want to specify a default save as name for the pdf file(something like the date and time of the day the report was exported). Is that possible or is there a better way of controlling the destination pdf file names.
Elizma 2/10/2009 2:16 AM

Hi All,

I have a SQL 2005 Report. I want to export the report as a PDF, but in Landscape. I already set my Page width and height properties, but when I export the report it export it in Portrait. Can anyone please tell me how do I fix this?

Elizma
Cathy 2/10/2009 10:01 AM

Hi,
I have a report that expects month and year as parameter. But when I enter http://usdatdvbi1/reportserver?%2fGlobal+Sales+Dashboard%2fS1+Grid&rs:format=pdf&Month=December+2008
into a brower, the report is still rendered with the default month year parameter and ignores the one in the url. Would you know why?

Also, can you please let me know how to specify portraint or lansdscape for PDF rendering?

Thanks so much!

Cathy
Kochie 3/23/2009 9:38 AM

Hi Ryan,
I have a solution for Victoria and Cathy. I was having the same problem on my report where the page header caused columns to merge once exported to Excel. I solved this by forcing the page header to the full width of the report and then giving it a background color. Without a background color (or color of Transparent), it shortened the width of the header to only as wide as the text, which was causing the merging issue. But with a background color, it knows that you want the color to span the entire width of the report. I started off with a color of Red to see what it would do, and once that worked, I changed it to White, and it worked.
kamal 3/26/2009 8:53 AM

Hi
Does anyone know of a way to define the file name of the Export file using a query parameter?
By default, it takes on the name of the report, but that means each record is saved to the same file name.
ali 4/15/2009 5:16 AM

any answer to this;

Is there any way i can name the different sheets when i export the report into excel? I did setup page break to export into different pages but having trouble to give the sheet names the way i want.
Rahul 4/20/2009 6:46 AM

Hi,
Can anyone let me know how can I export report from Reporting Manager in excel format and show gridlines,in the exported report.

I am using SSRS 2005

Rahul
sreenivas 4/28/2009 1:35 AM

hi,
does any body have info on stop default execution of SSRS report till click on view report button. usually SSRS report run with out click on button if we set the all parameters. for me it should not run till i click on view report button?
Amit 5/1/2009 3:58 AM

Hi Sreenivas,

You can specify default parametr which should be none of your actual parameters.

For e.g. , if your parameter has values A,B, and C, Declare parameter with Value D in default parameter. This way, it will not match with any of the Report Parameters and report will not get renedered. Once you will select proper parameter from Dropdown, It will start rendering.

Thanks,
Amit
Amritha 5/8/2009 8:00 AM

Hi!

I have developed a report in SSRS 2008. I have implemented document Mapping in the Report. The Problem is, all the Labels are not displaying in the PDF Export. Whereas in Excel report, I get all the Labels display whereas in PDF , I get only 3 Labels out of 25.I am sure there is no problem from the design side as this is working fine while generating the report. Plz. help.

Thanks,
Amritha
Codruta 5/18/2009 2:35 AM

Hi Ryan,

I just "entered" the Reporting Services field and I need some help in automatic exporting a report to Excel format.
My question is: Is there any way of saving automatically (sending the file name as parameter or something similar) when I launch a report directly to Excel?
example: http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=Excel .... &filename_output="D:\myfiles\stam.xls"
Thank you in advance,
Codruta
P.S. I am honored to learn a lot from you!
Nilesh 5/19/2009 3:38 AM

The hidden columns are not get displays in HTML view(SSRS 2005) and but when it exported thru the Reportviewer control, the hidden column are get visible in the csv file. how can I fix this issue?
baitnicart 5/20/2009 11:43 PM

hi ryan,

we're using rs. problem is, after exporting a report to excel, the report cannot be opened. there were some repair errors and the data presented in excel is not complete. what im wandering is, why oh why did this thing happened only to one instance of my report? the same RDL rendering the same thing, only with different data can be opened excel without a fuss. any help here?
why-not 6/8/2009 5:32 AM

Automatic exporting a report to Excel (or other) format is possible through "Subscriptions", for details:
http://msdn.microsoft.com/en-us/library/ms159762(SQL.90).aspx
eric 6/9/2009 2:40 PM

does anyone know why my group header does not show up on the last page when exported to pdf? it does in the report viewer and every page in pdf except for the last one???
Soniya 7/10/2009 2:23 AM

Hi Ryan,

I need ur help.
I hv created a Report, embedded in a web page, which accpets two parameters from user directly in report viewer. As clicks on "View Report" button. Page gets refresh but report doesn't generated. Here I hv a requirement to prompt to User for parameters in Reports directly instead of creating a seperate web page.

I hv been stuck in this problem since two days. Could u pls help me out.

Thanks
Soniya
Timi 8/12/2009 7:11 AM

Hi Ryan,
I have a client that uses MS reportig services to generate csv files. The record layout and contents are as requested but when i attempt to import the file using a custom application i get an error - "Unable to import. row #: 0 cannot be found".
Strange thing is when i create a new text file (using desktop - new - text document), copy contents from my clients csv file unto the new text file, rename as csv, the import works fine with no problem.
This leads me to believe that the issue is related to how the csv file was generated in MS reporting. Maybe some sort of parameter or control character when generated.
Any thoughts?

Thanks
Timi
Mike 8/12/2009 11:26 PM

try using sql server 2008 reporting services coupled with report builder 2.0. much easier.
Harshil 9/17/2009 4:11 AM

Problem while exporting report in PDF formate in SSRS 2008

It does nor shows the header for some of the pages
Saritha 10/26/2009 10:00 AM

Hi Ryan - I am very new to SSRS 2008 ,I need to generate couple of reports like based on diff datatypes ,Stored Procedures, Dropdowns ,Text,I can do Dropdowns and text,I wanted to generate report using query string ,but with no code.Can you please help me.

Thanks,
Saritha
Glenn 11/3/2009 2:47 PM

Does any one have any ideas on how to adjust the reporting services config file to export to Word from CRM 3.0.

For those people having trouble with exporting to pdf in both landscape and portrait, I found the following code. This works great.

Open the rsreportserver.congif file from the following location in either notepad or VS

C:programfiles/microsoftsqlserver/mssql2.2/reportingservices/reportsever

Scroll through this file until you find a section called RENDER.

Then insert the following code. No need to restart the server.

Enjoy.

<Extension Name="PDF (A4 Landscape)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF in A4 Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>8.27in</PageHeight>
<PageWidth>11.69in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="PDF (A4 Portrait)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF in A4 Portrait</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>11.69in</PageHeight>
<PageWidth>8.27in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
mieloosh 11/10/2009 10:36 AM

hi all,

Solution for Kochie, Victoria, and Cathy

Very useful information on merged or hidden cells in excel exports / exporting from reporting services

http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx
Andy Novak 1/25/2010 11:08 PM

Hello there. Great content here. I am rendering reports via URL and was wondering what type of parameter I should use in order for the report viewer to open up in a new window. Any advice would be greatly appreciated.
Siva 1/28/2010 8:52 AM

very useful information.

if the report is not present in the root of the report server how do i modify the URL

Please suggest
Elisha 2/4/2010 9:59 PM

Hi

I included the following code in the rsreportserver configuration file:
but the problem is I don't see those configuration changes, I restarted ssrs services, but no use. My reporting services is configured in share point integration mode. Can any help out in this.
Thanks

<Extension Name="PDF (A4 Landscape)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF in A4 Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>8.27in</PageHeight>
<PageWidth>11.69in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="PDF (A4 Portrait)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF in A4 Portrait</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>11.69in</PageHeight>
<PageWidth>8.27in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
Anjali 2/5/2010 3:41 PM

Hi,
I have to replicate a bursting report effect in SSRS. I have a report (R1) which according to the stored procedure, should create multiple copies of report (R2) with different parameter values and should store them as different filenames. Is there a way to do that? Thanks
Bharat 2/12/2010 12:03 PM

Hi,
Is there a way after opening a RS report in browser to save it automatically in excel format with Report's Title, when user clicks "Save" button on report page?
This is a great forum for new ideas and great place to learn new tricks.
Thanks in advance.
Alicia 2/18/2010 9:03 AM

Hola,

Configuro el fichero rsreportserver.config de mi reporting services 2005 para que la exportación a csv salga bien y aún así no me sale. Los caracteres especiales (tildes, ñ, etc...) salen bien pero las columnas salen juntas.

La configuración es la siguiente:

<Extensión de nombre="CSV" Type="derer.CsvReportMicrosoft.ReportingServices.Rendering.CsvRen,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<FieldDelimiter xml:space="preserve">;</FieldDelimiter>
<Encoding>Unicode</Encoding>
<NoHeader>True</NoHeader>
</DeviceInfo>
</Configuration>
</Extension>

¿Alguien puede ayudarme?

Muchas gracias de antemano.
Hi 2/18/2010 9:49 PM

Hi

can some one please let me know how to render gridlines when the report is being executed. I.e. when I run the report which option to select for the gridlines to appear in IE

thanks
vamshi 3/9/2010 12:31 PM

When a new subscription is created a job with craxy name is being created in SQ server Agent. Can we rename the job that would make more sense. Would that affect the subscription?
Perry 3/9/2010 3:18 PM

Ryan:

I hope this is a simple one. In SQL RS 2008 R2 I'm trying to utilize the Go To URL action expression of a report object to open static pdf's in a new IE window not associated with the report server. I am able to open these pdf's just not in a new window. The static pdf's are in a seperate IIS 7.0 folder.
Perry 3/9/2010 3:42 PM

To answer my own question, I just found this on another post, tried it and it worked nicely. Notice the concatenation of dynamic database fields into one URL that opens in a new window.

Type this into your SQL RS object Go To URL Expression:

="javascript:void(window.open('" & Fields!URLReportLocation.Value & Fields!URLReportName.Value & Fields!URLReportID.Value & Fields!URLReportExtention.Value & "','_blank'))"

Enjoy!
Ananya 4/2/2010 1:24 AM

Hi ,

I am working on SSRS and using it to show reports from an silverlight application.

I am facing one problem as below:
I.My application shows a grid with some records.
II.User has to select a records and print its details in SSRS.
III.We have created report and it is running fine.
IV.problem here is, when I select first records report gets generated with its details correct but when I click scond record then it shows same report generated earlier for first one.
V.We are setting coookies for sending data to report.
VI.we have cleared the cokkies and though same problem occurs....

Please let me know if anyone faced same issue..
Shaun 5/6/2010 2:54 AM

Hi All,

Might be a little trivial (and hopefully easy), but I just got a new PC and some things dont work like they used to.

On my old one I used to right click a report in the solution explorer of Vis Studio 2005 and then click RUN rather than "deploy" or "build". The project would build and the report would deploy. It still does this ok. BUT it used to then launch internet explorer with the report I just deployed. It is this last part it no longer seems to do.

Any ideas

Thanks
Shaun
Foo 8/8/2010 8:00 PM

For those of you having problems setting the file extensions of saved files (such as when generating tab-delimited files from the Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport renderer) you should note that the Microsoft CSV Device documentation is wrong (hardly surprising):
http://msdn.microsoft.com/en-us/library/aa179571%28v=SQL.80%29.aspx

The <Extension> value should instead be entered into the RSReportServer.config file as <FileExtension> and also note that it is case sensitive.
11/28/2012 7:10 AM

Generate Wonderful and Simple SQL Reports