?
Solved

Reporting Services - Report without a datasource/dataset?

Posted on 2009-05-04
6
Medium Priority
?
2,637 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 2000 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
New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

 

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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

764 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