SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Trouble with Dataset
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 06/17/2013 :  14:25:09  Show Profile  Reply with Quote
Good afternoon everybody,

I'm having a hard time with a tutorial that I'm following along with. This tutorial goes through creating a simple report based off Adventure Works 2008. I'm able to create a datasource, a dataset and add a report. I'm also able to create a second dataset which has a select query that will display category IDs so that the user can select a Category ID which is going to be supplied as a paramater to the first dataset/report. The trouble I'm having is that when I expand parameters and right click CategoryID and then click Parameter properties and then click Available Values/Get Values From a Query..I don't see my second dataset. I only see one dataset that I can choose which is the wrong one(DS1). Has anyone experienced this before? What am I doing wrong?

This is how I go about doing the project.
1. I create the project
2. Add datasource. (Datasource1).
3. Right click "Shared Data Sources" Add New Item. I create a dataset named DS1 which uses Datasource1.
I can't add an item by right clicking Datasource1, I have to right click "Shared Data Sources".
4. I then design a report/ I add reportname and a table.
5. I then create a Dataset2 which has the CategorID select statement.
6. Then I right click the CategorID field from parameters and I don't see a Dataset2 which I created.

Can someone please give me a hand?

Edited by - viperbyte on 06/17/2013 14:32:37

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/18/2013 :  00:37:36  Show Profile  Reply with Quote
which reporting services version are you using?
Is your source a sql server database or analysis server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 06/18/2013 :  08:07:01  Show Profile  Reply with Quote
When I first started reading about Reporting Services In my 2008 flavor book, I learned that there was two ways to go about report writing one was a Report Builder 2.0 and the other I beleive is using Visual Studio. As far as which version of reporting services I'm guessing that the answer to that question is that I'm using the Visual Studio 2008 approach. When I start a report project I go into "SQL Server Business Intelligence Development Studio". My source is an SQL Server 2008 R2 database.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/18/2013 :  10:12:16  Show Profile  Reply with Quote
quote:
Originally posted by viperbyte

When I first started reading about Reporting Services In my 2008 flavor book, I learned that there was two ways to go about report writing one was a Report Builder 2.0 and the other I beleive is using Visual Studio. As far as which version of reporting services I'm guessing that the answer to that question is that I'm using the Visual Studio 2008 approach. When I start a report project I go into "SQL Server Business Intelligence Development Studio". My source is an SQL Server 2008 R2 database.


whats the type of project you used? report builder or report server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 06/18/2013 :  11:40:58  Show Profile  Reply with Quote
It's a Report Server project.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/19/2013 :  01:10:31  Show Profile  Reply with Quote
Can you try creating datasets first and then moving to report design part?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 06/20/2013 :  07:59:28  Show Profile  Reply with Quote
Hi Visakh16,

I'm excited to try your suggestion of creating the datasets first. It's going to have to wait till the weekend though. Thanks for the suggestion. I'll let you and all other members know how it went after I try it. Thanks for the help.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/21/2013 :  02:19:26  Show Profile  Reply with Quote
no issues. let me know how you got on!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 06/26/2013 :  08:53:16  Show Profile  Reply with Quote
That didn't work either. But I did get it to work with slight variations on my approach. The way I got it to work was by doing these steps and in this order.
1.Create Report Server project.
2.Right click reports/Add/New Item/select report.
3.On the report right click on the designer/select table.
4.Select the "Use a data set embedded in my report" radio button. In the data source section click the new button and set up the data source.
In the query box enter the SQL statement.
5.I now design the report.
6.Now I right click the data source and add a dataset.
7.Now if I go to parameter and right click the CategoryID parm and select "Available Values\Get values from a query\DataSet", I'll be able to see both datasets.

That worked and hope that may help anyone else stuck with the same problem.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/26/2013 :  09:29:55  Show Profile  Reply with Quote
Thaks for sharing the solution!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000