Solved

Reporting Services - Report without a datasource/dataset?

Posted on 2009-05-04
6
2,421 Views
Last Modified: 2012-05-06
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.

Thanks,
-Matt
0
Comment
Question by:tds_softwaredev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Emes
ID: 24296857
can you use a simple excel spreadsheet ?

0
 
LVL 3

Expert Comment

by:mfreuden
ID: 24297083
You can easily do this with Report builder 2.0

download at:

http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en

When you create a report, you will be prompted to select a data-source on a blank report-page.  simply remove the the Data-Region from the page that has the connection prompt within it.   Don't get tricked thinking you have to select one od the datasources.

Now you'll have a blank page ready to work with.
0
 
LVL 3

Accepted Solution

by:
mfreuden earned 500 total points
ID: 24297178
You can also do this in the Development Studio by:

1. Create a New "report server" project.
2. Add a Blank report by right-clicking on "Reports" in the Solution Explorer and select "Add-->New Item", then select "Report".
3. Switch to Layout view and modify to your hearts content.
4. You'll need to specifiy the "Startup" Item" by right-clicking on the soluction in the Solution explorer window.

0
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 

Author Comment

by:tds_softwaredev
ID: 24297258
Ah, after taking a look at Report Builder 2.0, it looks like I'm mistaken. I can create a report without a datasource, even in VS 2005, but when I try to use the Table or Matrix objects, it gives me an error that they must be bound to a dataset. Anyone know if there's a way around this? Otherwise I'll just redesign without using those objects, but it would just be nice if I could since it allows them the columns to be easily aligned and manipulated.
0
 
LVL 3

Assisted Solution

by:mfreuden
mfreuden earned 500 total points
ID: 24297320
Nope, you can't use Table and Mattrix objects without a data source... sorry.
0
 

Author Comment

by:tds_softwaredev
ID: 24297389
Alright, thanks!
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question