RSS 2.0 Feed
RSS 2.0


Atom 1.0 Feed
Atom 1.0

  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.




                   



Leave a comment below.

Comments

  1. Matthew 1/30/2006 12:33 PM
    Gravatar
    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,
  2. Clemens 2/7/2006 12:39 AM
    Gravatar
    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
  3. Ryan Farley 2/7/2006 6:11 AM
    Gravatar
    Wow. Great link Clemens. Thanks!

    -Ryan
  4. Sam 3/23/2006 10:44 AM
    Gravatar
    If render a report is possible as ANSI. Then how can I have a subscription email a report as an ANSI?

    Thanks,
    Sam
  5. chad 6/5/2006 2:44 AM
    Gravatar
    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
  6. Vinod Ramkumar 7/27/2006 12:52 AM
    Gravatar
    Do i have to have MS Office installed on the server which renders the reports to be able to export the reports in excel.
  7. Ryan Farley 7/27/2006 8:36 AM
    Gravatar
    Vinod,

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

    -Ryan
  8. Ron 8/30/2006 8:06 AM
    Gravatar
    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.
  9. Ryan Farley 8/30/2006 8:12 AM
    Gravatar
    Ron,

    You would have to modify the settings for the XLS file type on each machine to open automatically without the prompt.
  10. Sunil 10/12/2006 9:06 AM
    Gravatar
    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.
  11. Ryan Farley 10/12/2006 9:18 AM
    Gravatar
    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
  12. Sunil 10/12/2006 10:24 AM
    Gravatar
    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.
  13. Ryan Farley 10/12/2006 10:41 AM
    Gravatar
    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?
  14. Sunil 10/12/2006 10:55 AM
    Gravatar
    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.
  15. brian 11/3/2006 10:11 AM
    Gravatar
    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
  16. Chris 12/13/2006 2:44 AM
    Gravatar
    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
  17. Ryan Farley 12/13/2006 4:55 AM
    Gravatar
    Chris,

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

    -Ryan
  18. Cathy 12/13/2006 10:28 AM
    Gravatar
    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?
  19. Chris 12/13/2006 7:16 PM
    Gravatar
    Thanks a lot Ryan!!!

    Regards,
    Chris
  20. Manny 12/20/2006 3:09 PM
    Gravatar
    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
  21. Ryan Farley 12/21/2006 8:45 AM
    Gravatar
    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)
  22. badri 1/4/2007 8:28 PM
    Gravatar
    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.
  23. bruce 1/4/2007 11:47 PM
    Gravatar
    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?
  24. Navish Singh 2/19/2007 4:56 AM
    Gravatar
    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.
  25. Trupthi 2/24/2007 11:42 PM
    Gravatar
    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.
  26. Gabby 2/28/2007 7:50 AM
    Gravatar
    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
  27. Victoria 2/28/2007 10:16 AM
    Gravatar
    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?
  28. Shankar 3/5/2007 1:04 AM
    Gravatar
    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
  29. Stu 3/21/2007 3:27 AM
    Gravatar
    Similar problem to Brian above. Exporting a date to Excel loses it format. Any ways around this?
  30. prathesh 3/22/2007 3:15 AM
    Gravatar
    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.......

  31. Mookie 3/22/2007 3:34 AM
    Gravatar
    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 )
  32. Asish 3/25/2007 11:07 PM
    Gravatar
    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
  33. Lloyd 3/30/2007 12:21 PM
    Gravatar
    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.
  34. Greek 4/8/2007 11:44 PM
    Gravatar
    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
  35. Kamran 4/23/2007 8:48 AM
    Gravatar
    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.
  36. Joseph Don 5/13/2007 8:16 PM
    Gravatar
    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.
  37. Test 5/14/2007 4:51 AM
    Gravatar
    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
  38. BryanJ 5/15/2007 7:25 AM
    Gravatar
    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!!!
  39. Sankar 6/1/2007 1:26 PM
    Gravatar
    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?
  40. Santos 6/6/2007 6:35 AM
    Gravatar
    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?
  41. Sree 6/7/2007 10:28 AM
    Gravatar
    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.

  42. siva 6/19/2007 3:09 AM
    Gravatar
    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
  43. yuva 6/21/2007 11:32 PM
    Gravatar
    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.
  44. mariano 7/5/2007 8:19 AM
    Gravatar
    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
  45. Krishna Joyodiharjo 7/31/2007 12:51 AM
    Gravatar

    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.

  46. Oakland Raiders 8/17/2007 12:50 PM
    Gravatar
    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.
  47. Navster 8/19/2007 3:54 PM
    Gravatar
    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.
  48. Monir 8/22/2007 8:10 AM
    Gravatar
    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?
  49. Monir 8/22/2007 8:11 AM
    Gravatar
    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?
  50. Liliane 8/30/2007 10:55 PM
    Gravatar
    To Greek, there is a property for the field called "DataElementOutput", you can choose "NoOutput"
  51. scott lancaster 9/12/2007 6:18 PM
    Gravatar
    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
  52. Dimeji 10/29/2007 6:36 AM
    Gravatar
    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...
  53. ben 10/31/2007 6:23 AM
    Gravatar
    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.
  54. Prathap 11/18/2007 9:05 PM
    Gravatar
    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?
  55. Arun 11/19/2007 11:32 AM
    Gravatar
    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.
  56. Satish 12/4/2007 10:50 AM
    Gravatar
    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>
  57. RG 12/19/2007 5:53 AM
    Gravatar
    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
  58. CJ 1/7/2008 11:46 AM
    Gravatar
    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
  59. sheetal 1/28/2008 11:43 PM
    Gravatar
    Please let me know How to rename worksheets after rendering the report in excel format?
  60. Ramya 2/14/2008 8:05 PM
    Gravatar
    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!
  61. BS 2/26/2008 6:42 AM
    Gravatar
    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?
  62. kiran nelluri 3/20/2008 1:29 PM
    Gravatar
    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
  63. Ankur Mittal 3/24/2008 9:08 AM
    Gravatar
    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
  64. Test 4/22/2008 7:20 AM
    Gravatar
    Hi, is there any way to bind a map image to a sql reporting service
  65. Charu 4/22/2008 10:05 PM
    Gravatar
    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.
  66. Charu 4/23/2008 3:48 AM
    Gravatar
    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.
  67. Damodar Baliga.B 4/24/2008 2:50 AM
    Gravatar
    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.
  68. Nancy 6/18/2008 7:02 AM
    Gravatar
    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.
  69. Soniya 6/18/2008 6:55 PM
    Gravatar
    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.
  70. Corine 7/8/2008 12:03 PM
    Gravatar
    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
  71. Corine 7/8/2008 12:05 PM
    Gravatar
    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
  72. Joe 7/15/2008 5:29 AM
    Gravatar
    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.
  73. Rob 8/27/2008 1:12 PM
    Gravatar
    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?
  74. Jeff 8/28/2008 9:49 AM
    Gravatar
    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
  75. C.Penhall 10/6/2008 7:52 AM
    Gravatar
    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"/> -->
    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
    <Configuration>
    <DeviceInfo>
    <Encoding>ASCII</Encoding>
    </DeviceInfo>
    </Configuration>
    </Extension>

    2. Restart IIS
  76. Lewis 10/21/2008 3:53 AM
    Gravatar
    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.
  77. raffy 11/13/2008 6:22 AM
    Gravatar
    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.
  78. Sami 11/14/2008 11:36 AM
    Gravatar
    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.


  79. schmack 11/27/2008 9:02 AM
    Gravatar
    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
  80. Bhushan Laddad 11/29/2008 1:21 AM
    Gravatar
    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?
  81. Bhushan Laddad 12/1/2008 1:46 AM
    Gravatar
    Hi Ryan, pls provide me the solution, it's urgent..I need ur help
  82. Andy 12/17/2008 9:45 AM
    Gravatar
    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
  83. hbjh 12/18/2008 9:30 AM
    Gravatar
    knm
  84. Ramu 1/2/2009 2:58 AM
    Gravatar
    When export a report from reportserver, the images are exporting.

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

    Regards,
    Ramu
  85. 1/21/2009 10:19 PM
    Gravatar
    Using reporting services | keyongtech
  86. AHall 1/27/2009 7:44 AM
    Gravatar
    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!
  87. AHall 1/27/2009 7:45 AM
    Gravatar
    my apologies, we are running SQL Reporting Services 2000 now, but we have 2005 if necessary. Thank you.
  88. bill 2/6/2009 8:55 AM
    Gravatar
    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?
  89. Ryan Farley 2/6/2009 9:40 AM
    Gravatar
    @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
  90. Nick 2/10/2009 12:37 AM
    Gravatar
    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.
  91. Elizma 2/10/2009 2:16 AM
    Gravatar
    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
  92. Cathy 2/10/2009 10:01 AM
    Gravatar
    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
  93. Kochie 3/23/2009 9:38 AM
    Gravatar
    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.
  94. kamal 3/26/2009 8:53 AM
    Gravatar
    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.

  95. ali 4/15/2009 5:16 AM
    Gravatar
    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.
  96. Rahul 4/20/2009 6:46 AM
    Gravatar
    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
  97. sreenivas 4/28/2009 1:35 AM
    Gravatar
    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?


  98. Amit 5/1/2009 3:58 AM
    Gravatar
    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
  99. Amritha 5/8/2009 8:00 AM
    Gravatar
    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
  100. Codruta 5/18/2009 2:35 AM
    Gravatar
    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!
  101. Nilesh 5/19/2009 3:38 AM
    Gravatar
    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?
  102. baitnicart 5/20/2009 11:43 PM
    Gravatar
    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?
  103. why-not 6/8/2009 5:32 AM
    Gravatar
    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
  104. eric 6/9/2009 2:40 PM
    Gravatar
    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???
  105. Soniya 7/10/2009 2:23 AM
    Gravatar
    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
  106. Timi 8/12/2009 7:11 AM
    Gravatar
    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
  107. Mike 8/12/2009 11:26 PM
    Gravatar
    try using sql server 2008 reporting services coupled with report builder 2.0. much easier.
  108. Harshil 9/17/2009 4:11 AM
    Gravatar
    Problem while exporting report in PDF formate in SSRS 2008


    It does nor shows the header for some of the pages
  109. Saritha 10/26/2009 10:00 AM
    Gravatar
    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
  110. Glenn 11/3/2009 2:47 PM
    Gravatar
    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>
  111. mieloosh 11/10/2009 10:36 AM
    Gravatar
    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
  112. Andy Novak 1/25/2010 11:08 PM
    Gravatar
    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.
  113. Siva 1/28/2010 8:52 AM
    Gravatar
    very useful information.

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

    Please suggest
  114. Elisha 2/4/2010 9:59 PM
    Gravatar
    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>
  115. Anjali 2/5/2010 3:41 PM
    Gravatar
    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
  116. Bharat 2/12/2010 12:03 PM
    Gravatar
    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.
  117. Alicia 2/18/2010 9:03 AM
    Gravatar
    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.
  118. Hi 2/18/2010 9:49 PM
    Gravatar
    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
  119. vamshi 3/9/2010 12:31 PM
    Gravatar
    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?
  120. Perry 3/9/2010 3:18 PM
    Gravatar
    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.
  121. Perry 3/9/2010 3:42 PM
    Gravatar
    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!
  122. Ananya 4/2/2010 1:24 AM
    Gravatar
    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..
  123. Shaun 5/6/2010 2:54 AM
    Gravatar
    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
  124. Foo 8/8/2010 8:00 PM
    Gravatar
    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.
  125. 11/28/2012 7:10 AM
    Gravatar
    Generate Wonderful and Simple SQL Reports
Comments have been closed on this topic.



 

News


Also see my CRM Developer blog

Connect:              


Sponsor

Sections