.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to export selected records from SSRS Report

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server


I want to export selected records from SSRS Report. I want to provide a radio button or a checkbox for the selection in the report body. So after the report renders data, i want to select few records to export.


SSRS Report generates some 10 records but i want to export or print only 4 records out of 10 records.

Please let me know how to proceed this.





View Complete Post

More Related Resource Links

SSRS report export to CSV showing column headers always in English inspite of the selected locale.


We are encoutering an issue with SSRS report export to CSV showing column headers always in English, regardless of locale.


We are using SSRS to display report results in a report viewer window launched from an ASP.net page.


When the report viewer is lauched in fr-CA locale, the report viewer window content is in French. However, when the results are exported to CSV, all the column header labels inside the CSV are always in English.


How to export SSRS report to PDF from SSIS with parameters

Hello everyone.  I am trying to setup a process in which a user, who is using a vb.net 2008 application, will need to  trigger the creation of two items.  The first is  SSRS report which will need to be exported to PDF format to a shared folder on the network.  This report accepts one parameter.  The second thing that will need to be created at the same time is an excel file with data exported from SQL Server 2008 which is generated through an SSIS package.  A couple things to note.  The excel file and the pdf file need to have the same file name, other than the extension.  For example P00000001_20100831.pdf and P00000001_20100831.xlsx and will both be stored in the same network share.  The filenames need to be created dynamically at run time and will be based on a parameter being passed to the report. So far I have the portion that creates the excel file working fine.  The way I create that is as follows.  I have a stored procedure that creates a job which calls the SSIS package and passes the appropriate parameters to the SSIS package.  After the job is created I immediately run it and then delete the job.  Ok, everything works fine with that. Now I cant seem to figure out how to get the pdf created.  If possible I would like to keep this portion together with the already created job or package.&nb

SSRS Report - Page break after the Header when export to PDF



I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.




Disabling Export option for a single individual SSRS report

HI Forum Members,

    I read some discussions on disabling Export option in SSRS for an individual report.
Some said to go into the Report Properties in the Design tab and write below code:
Set ReportViewer.ShowExportControls = false;

I'm new for SSRS apart from doing some adhoc reports - So, i'm confused here. Where should i write this code?
Can any one help me.


Not able to export a large SSRS report into Excel



I have a requirement to export a large SSRS report into Excel. The report has more than 52 columns and around 70000 lines. The requirement is to export the report into a single excel(different sheets also would do ). Can you suggest some help in this regards?

Thanks in advance!

SSRS Report Page break when export to PDF



I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.

My issue is for certain cases the line items in the body of the invoice, only the last line item moves to the next page. Cretaing a large gap in the body of the report. This happens only for some invoices. I am using Land scape type report, having Page size as 11 * 8.5 inches.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

I can also send the RDL file, sample data as well as the PDF output for review.



Strange issue with a huge SSRS 2008 report (supposed to return 3 million records)



NOTE: The strange part (as mentioned in title) will come in the end.

I am running a SSRS 2008 report which fetches 3 million records from a remote server. After around 1 hour the report processing stops and I see an error icon on the lft bottom of the browser window. When I click on that to see the error details it shows some PageRequestManagerSQLErrorException with an unknown error message with code 12029 (sometimes 12002).

When I see the reportserver logs there is an error message logged in it which says "Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached."

The <DatabaseQueryTimeOut> value in the report server configuration file is already having a value set to 7200 seconds(2 hours).<

In SSRS 2008, after export to Excel report loses nested visibility groups


I have a report  created in SSRS 2005 which is running on our new SSRS 2008 box.  It has 3 nested levels of visibility so the recipient can click the twist tie to view different levels of detail.  Each Zone has many Districts and each District has many Stores.  The report renders displaying the summary of the Zones.  If you click on the twist tie on the Zone it opens up a list of Districts.  If you click on the twist tie on a district, it opens up a list of stores.  If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.

The report renders fine in report manager.  The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.  The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts and Stores.  The client is not happy about this.  This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.

I tried converting the report to SSRS 2008, but that did not solve my problem. 

Is there anyway to fix the export process to Excel? 


P.S. I tried to upload the code, but it caused my question to be too many characters

Blank pages in SSRS Report PDF Export


I am developing a report with almost 25 columns table and the width of the report is 20pt. But I am changing the visibility of a few columns in run-time so that the resultant width will fit in one page (11pt)(I checked all the margins and resultant width of table. Sum of all the widths are with in the pagesize only). Everything is working fine when i check the report in browser, but when i try to Export to PDF there are alternate white pages, which are corresponding to the hidden columns width i guess.

How to achieve PDF Export without white pages? Also, is there any way to shrink the report to a single page?

I am using SSRS 2005

SSRS 2005 report export to excel - show text as number


When exports the report to excel, some columns are numbers(something like 00125987). We need these columns to be text,  but excel convert these columns in numbers and in result we received not "00125987" but "125987".  

How to fix that? 

We need all these columns to be text.



Export SSRS report to excel with data of pie chart



I am new to SSRS. I have a report with a pie chart . When I export the report in excel format, pie chart is displayed as picture. I want it to be displayed as editable pie chart with data. 

The requirement is, if user want to change the data in excel sheet after exporting, changes should reflect in pie chart of that excel sheet.

Please suggest me the way of achieving it.


SSRS 2008 report export to PDF get hangs



I have created a SSRS report with a tablix and some external images(both .png/.gif). This report is going to be generated for different Languages, so i have used Arial Unicode MS.

I render the report as Attachment on click of the print button (I flush() the byte[] array from the SSRS Render function as Respone on to the page). Report gets generated properly with open/save/cancel. But on click of OPEN the abode reader gets hanged. I tried to save the report and open, but no luck.

Size of the pdf is less than 150 kb. I have Abode ver 9.4 and SSRS 2008.

Please help.


Generating report for 10,000 records (SSRS 2008)


Hi Experts,

I have SQL Procedure resulting 10,000 records, which is properly indexed and working fine from db.

Using SSRS 2008 recreated a report to print the records with some parameters.

Problem : The SSRS Report Viewer Control and even Report Manager is loading all the records in 1 page, which is taking very long time to show and scroll.


Please suggest how can improve the performance. (Creating Paging??? etc)

I appreciate some quick solution.


Showing filtered Records in Crystal Report as per User Requirement


ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            CrystalReportViewer1.ParameterFieldInfo = paramFields;

RDLC Report Hide Export Option

The article RDLC Report Hide Export Option was added by mandandeo on Sunday, August 15, 2010.

protected void ReportViewer1_PreRender(object sender, EventArgs e) {DisableFormat(ReportViewer1, "Pdf"); }protected void DisableFormat(ReportViewer viewer, string formatName) {const System.Reflection.BindingFlags Flags =System.Reflection.BindingFlags

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend