| 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 project2. 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
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. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2013-06-18 : 11:40:58
|
| It's a Report Server project. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
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. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-26 : 09:29:55
|
| Thaks for sharing the solution!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
Trouble with Dataset