Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Trouble with Dataset

Author  Topic 

viperbyte
Posting Yak Master

132 Posts

Posted - 2013-06-17 : 14:25:09
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?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-18 : 00:37:36
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

132 Posts

Posted - 2013-06-18 : 08:07:01
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

52326 Posts

Posted - 2013-06-18 : 10:12:16
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

132 Posts

Posted - 2013-06-18 : 11:40:58
It's a Report Server project.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-19 : 01:10:31
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

132 Posts

Posted - 2013-06-20 : 07:59:28
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

52326 Posts

Posted - 2013-06-21 : 02:19:26
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

132 Posts

Posted - 2013-06-26 : 08:53:16
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

52326 Posts

Posted - 2013-06-26 : 09:29:55
Thaks for sharing the solution!

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

- Advertisement -