September 30, 2014 at 1:46 pm
Wasn't sure if I should post under the Newbies or Reporting Services so I'm trying here first. I am currently using SSC Stairway to Reporting Services to learn how to use SQL Reporting Services. I am in Level (Lesson) 3. I have gone through the steps as instructed: Created new Report Server Project and added new data source. That's as far as I can get. The next step is "Tying a Shared Data Source to a Report Data Source". In my Report Data pane there is no Data Sources option to select, there is only Built-in Fields, Parameters and Images. I am using BIDS,Visual Studio 2008.
I've followed the steps over and over, my screens match all the screenshots in the lesson but when i get to the point where I'm supposed to tie the shared data source to the report data source there is no Data Source option. I have googled it, watched various You Tube videos and wasted a great deal of time. What am I missing?
September 30, 2014 at 2:20 pm
Took me a minute to figure out what you did. If you've created a shared datasource, the Report can't see it yet. You have to create a datasource there, but instead of pointing at the database (like you did when you created the original), you need to select the Use Shared Data Source Reference and then select the datasource you created earlier. Then you can right-click on that (in the Report Data window) and add a dataset from it.
September 30, 2014 at 5:35 pm
Here are precisely the steps I have followed:
File->New ->BI Project->Report Server Project
•Named Project: SSC_Report, clicked ‘ok’
•Right click Shared Data Sources, selected Add New Data Source
•In Shared Data Source Properties I changed the name (SCC_Data), Type is Microsoft SQL Server, Connection string: I clicked the Edit button which brought me to the Connection Properties screen;
oData source: Microsof SQL Server (SqlClient)
oServer name: Et2-pc
oLog on to the server using Windows Authentication
oConnect to a database: AdventureWorks2008
?Tested connection, test succeeded, clicked ok 2X
At this point I can go no further. There is no Report Data Pane, I tried pressing Ctrl+Alt+D but that didn't do anything at all. It is also not available under the view menu so I have no access to the report data pane. Your advice, as well as that which is in the lesson is: "select the Use Shared Data Source Reference" but I don't see where to do this.
September 30, 2014 at 6:51 pm
Oh, okay. So right now you have a shared data source. If you Right-Click on the Reports folder in the Solution Explorer, you can add a report (if you want to build from scratch, select Add, New Item, Report). Then you can specify the shared data source as the source for your report (choose it in the dropdown). From there you can add a dataset.
October 2, 2014 at 9:19 am
Following those steps still does not provide me with a dataset. I end up in a Report Wizard screen which has a Query Builder button and when I click on the button it opens a query designer screen with no data attached.
October 2, 2014 at 11:28 am
If you right-click the Reports folder in Solution Explorer, and select Add>New Item> and then select Report (not Wizard), you should get a blank report that opens. At that point, if you right-click the Data Sources folder under the Report Data window, you can add a new report-level data source. At that point, you can select the Use shared data source reference, and select the shared data source you created previously. Then you can create a dataset. (right-click the Data Source you want under Data Sources folder, and that's one of the options).
October 2, 2014 at 12:47 pm
I did click "Report", NOT Report Wizard.
Steps: ->Right click 'Reports'
->Options available from menu:
Add New Report,
Add (submenu): New Item, existing item
Import Reports
Properties
If I select 'Add New Report' I am then taken to the aforementioned Report Wizard.
If I select 'Add ->New Item ->Report, it opens a blank report in design mode with no option to add a data source or data set.
October 2, 2014 at 8:27 pm
If I select 'Add ->New Item ->Report, it opens a blank report in design mode with no option to add a data source or data set.
Once you have done this, there should be 5 folders in the Report Data window... one of them is Data Sources. Right-click and add new data source. If you successfully created a shared datasource, you should be able to choose it in the dropdown below the option "Use shared data source reference". This creates a data source reference inside your report (as opposed to your project).
If you right-click on the data source you just created (in the Data Sources folder under the Report Data window), you can create a dataset that you can use in your report. Then under Query Type, if you choose Stored Procedure, you'll get a list of all stored procedures in the database specified in the DataSource. If you choose "Text", you can just type the query in or use the query designer.
Does that help?
October 5, 2014 at 2:18 pm
I've got to say I'm mighty discouraged, we seem to be going round n round about the same issue. The problem is: I do NOT get the five folders in the Report Data window. I get three: Built-in Fields, Parameters and Images. I have found something of a work around by clicking "Add New Report" which then opens the Report Wizard screen, 1st screen has Shared data source selected by default. I select "next" and it takes me to the Query Builder. Since I already know how to write SQL Queries outside the report builder, I just add the scripts to create a report but that defeats the purpose of using the report builder. If I select Add -New Item-Report I get the report designer screen with no data, just the three menu items under report data: built in fields, parameters and image.
October 6, 2014 at 1:58 am
Ah, you need to learn the tool controls. It's an "easy when you know how" thing.
Above those three in the report data window is a New dropdown.
Choose new datasource. This is where you get your datasource into the report. Give it a name and then choose use shared datasource and chose your shared ds you already created that's listed in the solution explorer window.
Now right click the datasource you've just created in the report data window and choose add dataset. This is where you put your query.
Do it again to add another query against the same datasource e.g. for parameters.
Then switch to the toolbox window and build the report layout such as dragging fields onto a table
Don't forget to click outside your report on the yellowy area and set the report properties, especially sizes and language, as that determines date formats
October 8, 2014 at 6:25 am
Okay, that seems to have worked. Thank you so much for your help and patience.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply