Last post Oct 12, 2011 11:28 AM by Anindita.Basak
Oct 12, 2011 10:17 AM|macca|LINK
I have a form with a datagrid.
I want to be able to click a button which will launch an SS Report which will contain the data from the datagrid.
Anyone any ideas?
Oct 12, 2011 11:28 AM|Anindita.Basak|LINK
There is no direct staight way of exporting data from Gridview to SSRS. But you have many options.
Option1 : Use Telerik grid view [3rd party] which has nice option of exporting data to .pdf with out writing a single line code.
Option2: Use some open source/free 3rd party pdf creator component, and programtically align your .pdf from grid view like PDFSharp component.
Option3: Insted of showing data in GridView you can display data in ReportViewer control which has in-bult functionalities of exporting data from ReportViwer to .pdf/xls/.doc.
Option4: Use DataGridViewReportDataAdapter from codeproject which will export your gridview data to SSRS report than and .pdf.
The best option should be to use DataGridViewReportAdapter to export datagridview data to SSRS.