How can I execute an .rdl report with a Report Viewer control without an SSRS server?

Question

I'm trying to set up a web page where users can select an .rdl file to run, and it will open a Report Viewer control (ASPX), load the report definition file, run it, and display the report.

So far, what I've found is, "local" reports can only accept data sources from code (so you have to execute the database code manually, which would be a pain since the datasource can vary widely between reports), and "remote" reports require an SSRS server, something I am unable to set up.

What puzzles me is, Report Builder 3 is able to run .rdl files with embedded Data Sources in them, so why can't the Report Viewer control? Is there some way I can make the Report Viewer control act like Report Builder 3 and just have it run .rdl files?

I agree, clearly there is code in existence that reads an RDL file and loads all the various datasets (including shared) etc defined within it. I was also hoping I could get the Report Viewer to do this, but have given up. I imagine MS doesn't open up this functionality because alot of people wouldn't pay for SSRS. I have found this [link](http://www.codeproject.com/Articles/607382/Running-an-RDLC-SQL-Report-in-ASP-NET-without-SSRS) which is someone parsing the RDL file to get the information. Still deciding whether to invest more time in it. — JohnB, Apr 09 '14 at 19:40
possible duplicate of [Process rdl/rdlc report files without SSRS?](http://stackoverflow.com/questions/645850/process-rdl-rdlc-report-files-without-ssrs) — bummi, Oct 15 '14 at 07:20

score 2 · Accepted Answer · edited May 23 '17 at 11:53

The Report Viewer CAN run RDL files but they need to be hosted/published somewhere first is the rub then the reportviewer is in remote mode. The ReportView has different modes it can run in and one of them is basically just talking to the SSRS server and saying: "What you got up there?". There are a great great many debates of when to the local reports or the hosted ones and what are advantages/disadvantages of one over the other. You can develop just a regular SSRS Server with 'advanced options' to get the SSRS instance on a box if costs are a concern and adjust firewalls accordingly. If it is a policy setting I can't help with that.

Honestly if you want more coupled control to something like Entity Framework or WCF service and want to massage your data BEFORE you put it to a report, I would go RDLC. If you want to create a report with large datasets and give the user lots of options to alter the report layout and values from parameters I would go rdl but know you need to set up an SSRS instance. To try to set up RDL reports WITHOUT the server and then run them is a big pain that does not get you much but heartache. If it is the parameters you are wanting you can create your own, then massage the data BEFORE it goes to the datasource of the RDLC, then present the RDLC to an end user. This method involves reading more of the MS whitepaper on the reporting language and understanding how to implement the RDLC object in code behind.

More of the eternal argument of RDL versus RDLC here: When to use RDLC over RDL reports?

score 0 · Answer 2 · answered Jul 12 '13 at 18:13

0

No, you will need an SSRS Server to do what you are trying to do, unless you use RDLC files. You could get very creative and parse the RDL xml for the datasources yourself and perform the actions, but that is basically doing the same thing as RDLC.

answered Jul 12 '13 at 18:13

Cam Bruce

5,632
19
34

1

So, why does Report Builder just run the file without an SSRS server, then? What makes it special? – qJake Jul 12 '13 at 18:14
It is a development tool and is used to preview the report you built. – Cam Bruce Jul 12 '13 at 18:15
Yes U can use reports without SSRS server deployment. U can use then local reports. It can be RDL or RDLC. – RohannG Jun 24 '14 at 09:17
@RohannG Would you post any sample code or any info? – Ayman Salah Aug 20 '14 at 11:45

score 0 · Answer 3 · edited Oct 08 '13 at 16:07

0

Here is a link to an MSDN article that will provide some information about using the WebForms ReportViewer control:

http://technet.microsoft.com/en-us/library/aa337091(v=sql.100).aspx

edited Oct 08 '13 at 16:07

qJake

16,821
17
83
135

answered Oct 08 '13 at 07:03

Murali Uppangala

884
6
22
49

How can I execute an .rdl report with a Report Viewer control without an SSRS server?

3 Answers3

Linked