Reporting Services - Report without a datasource/dataset?
Posted on 2009-05-04
Perhaps I'm going about this in the wrong way, so if there's a better way please let me know.
I'm trying to create a report in Reporting Services without a datasource or dataset. That may sound odd, but the idea is that we want to create a form that is easily printable and exportable to different formats, and Reporting Services is a simple way (with a technology we know) to do that. It will be filled externally purely by parameters that are passed to it through the ReportViewer control in ASP.NET.
When I try to run the report by setting the data source to Sql Server, but leave the connection string blank, I get the error:
"A connection cannot be made to the database. Set and test the connection string"
I've tried the other types of connection strings without any luck and when I try to run the report, it won't display and gives me another error about the datasource being empty. I understand why it's complaining, but is there any setting that will allow this to work? I'd rather not set it to an existing database if possible, I'd like for it to be able to live on it's own.
Otherwise, is there a different way I should be going about this that's relatively straightforward? Basically, we just need to print a PDF form with specific values passed in. From what I saw, it looked like I would have to basically create the entire format of the PDF in code, but I'd rather start off with a template I could create manually (in a GUI designer) where I could designate where each parameter should display, then just pass in parameters each time the PDF would be generated to fill in the specific data. Basically, the same approach I'm already taking with Reporting Services, but perhaps with a different library.
We develop using Visual Studio 2005 with ASP.NET 2.0
Please let me know if I need to clarify anything.