How to Create a Shared Dataset manually in the Report manager

Question

Hi,

I am currently working with the SSRS 2008 R2 reporting services. I have designed a report in such a way that, it is having a Shared Data source and Shared Dataset.

When I build and deployed the project  from the BIDS, in report manager, automatically the following folder structure I got. Please find the screen shot below:

Now I want to manually deploy only the report instead of deploying the project  from the BIDS. So that I have to create the folders like Data Sources, Datasets and Reports project Name.

From Data Sources folder I can create and manage a dasource by clicking on the option called “New Data Source”. Similarly how can create a shared data set manually, as I am not having any option like “New Data Set” to create it.

I hope my explanation regards the problem is clear. If it is not clear please revert to me for the clarity.

Thanks in advance.

 

Manually

Answer 1

The answer is you cannot.

A shared dataset gets registered and this is something you cannot do manually, w/o tools as BIDS or you can kind of pseudo-manually create it using the Report Builder.

---

Arthur My Blog

Answer 2

Hi SSRS,

Report Manager is a Web-based report access and management tool that you use to administer a single report server instance from a remote location over an HTTP connection. We cannot create data source or dataset on it. We can use Report Manager to perform the following tasks:

• View, search, print, and subscribe to reports.
• Create, secure, and maintain the folder hierarchy to organize items on the server.
• Configure role-based security that determines access to items and operations.
• Configure report execution properties, report history, and report parameters.
• Create report models that connect to and retrieve data from a Microsoft SQL Server Analysis Services data source or from a SQL Server relational data source.
• Set model item security to allow access to specific entities in the model, or map entities to predefined clickthrough reports that you create in advance.
• Create shared schedules and shared data sources to make schedules and data source connections more manageable.
• Create data-driven subscriptions that roll out reports to a large recipient list.
• Create linked reports to reuse and repurpose an existing report in different ways.
• Launch Report Builder to create reports that you can save and run on the report server.

For more information about Report Manager, please see:
http://msdn.microsoft.com/en-us/library/ms157147.aspx

We can deploy report only by right-click the report and select deploy. And we can deploy it to specify folder by setting the deployment properties. For more information about it, please see:
http://msdn.microsoft.com/en-us/library/ms155802.aspx

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support

Answer 3

As Arthur said, you cannot create shared datasets through the Report Manager.  But you can actually upload existing ones, if that's what you're looking for.  If you click the Upload button, you'll get a screen that mentions the following:

"Upload a report (.rdl), model (.smdl), shared dataset (.rsd), report part (.rsc), or other resource into FolderName." Note that the file will be uploaded to the folder that you had open when you clicked the Upload button, in this case "FolderName".

---

MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)

Answer 4

Hi,

When you deploy a Data set or shared data set from a report project solution it'll be reflected on report server as new data set only there will not be any separate shared data set concept.

so instead of "Thought of" creating shared dataset you can create a new data set manually and then link the deployed reports to this new manually created data set as shown below.

 Please feel free to revert if any help needed, thank you....

 

---

- Arun Gangumalla, Please mark as helpful or answered if it resolves your issue to help others in finding solutions easily.

Answer 5

Arun, what you're explaining is how to create a Data Source.  The question was referring to the manual creation of Shared Datasets, not Data Sources.  Datasets and Data Sources are two different types of SSRS-related objects.

---

MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)

Answer 6

Hello,

Sorry i have overlooked on data source thing,  as u said we have no option for manual creation in case of dataset ..can only be uploaded if needed.

thank you...

---

- Arun Gangumalla, Please mark as helpful or answered if it resolves your issue to help others in finding solutions easily.

Answer 7

Hi Valenino,

Thank you very much for the update :)

My shared data set is existed one so that I have uploaded my shared data set file(.rsd) file through the upload functionality and it's working fine in locally for my two dataset which are mapped with this shared dataset.

But when I deploy this report on my Development environment along with the shared data set it's not working as expected.

The issue is as follows:

I have a shared data set (parent) with the columns “Name, Account Number, Transaction ID, Amount, etc.” This data set is returning 100 records because it is showing the transactions of all the Account Numbers.

Now I have created two data sets(Dataset1, Dataset2) and mapped to this shared data set(parent) but I have applied the filter on the Account Number field in Dataset2 so the Dateset2 contains data w.r.t the only specified transactions.

Then I have mapped these two datasets with two different tables in the same Report and run the report.T he Dataset1table  is properly mapped and showing data but the Dataset2 table is just showing the table headings only. i.e it is not showing any data even there is data.

For the verification I have print the CountRows("Dataset2") and it is returning 6 so I can confirm that it has 6 rows but I don't know why it is not showing these 6 rows?

Kindly do the needful help J

Answer 8

Hi SSRS2008R2,

Sorry for delay.

You add a filter in dataset2, and you can confirm that there are some data in this dataset through the CountRows("DataSet2") expression. So please ensure that the row visibility is set to show. Right-click the handle of the row and select "Row Visibility", if the "When the report initially run" radio button is set to "Hide", please change it to "Show".

Hoep this helps.

Charlie Liao

---

Charlie Liao
TechNet Community Support