Last post Jul 26, 2011 11:11 AM by pigenio
Dec 20, 2010 12:02 AM|gprasadholla|LINK
Hi, I want to make use of Word and PDF export feature of SSRS in my .net Application.
In my webpage i have a dataset with all the required data, now i want to call report viewer API and pass it to the report and generate the report and get the PDF output.
I can query directly in my report, but its a complex query and i already have that data on my page. Now i just want to fill a tablix and generate the report.
Does anyone have a working sample of this?
thanks in advance...
Dec 21, 2010 06:30 AM|gprasadholla|LINK
DataSet ds = new DataSet();
DataTable dt = new DataTable();
repViewer.LocalReport.ReportPath = "Report1.rdlc";
ReportDataSource rs = new ReportDataSource();
rs.Name = "DataSet1";
rs.Value = ds.Tables;
Only catch is in the name of Data source. It has to be same as of the DataSet name used(ignore the connection name).
Dec 22, 2010 02:54 AM|You-Hu Fu|LINK
Excellent job, great sharing. Thanks.
I think other communities will get the right direction when encounter the same issue.
Jul 23, 2011 07:18 PM|pigenio|LINK
Hey How did you manage to create a report with a tablix with this dataset as resource?
I tried what you did but all I get is an empty table with titles only.
Jul 26, 2011 08:06 AM|gprasadholla|LINK
I have written an article describing this in detail.
Jul 26, 2011 11:11 AM|pigenio|LINK
Thank you very much,
This was exactly what i was looking for!
I appreciate how you took time to write the article. I'm sure it will help the comunity.