Can I use an existing dataset in SSRS?

Question

Related to a question I've asked earlier regarding SSRS, could anyone please tell me - Is it possible to reuse an existing dataset in SSRS?

I know we can have shared datasets and we can convert a dataset to a shared one too.

Currently we are using Crystal Reports. We are trying to migrate to SSRS. So we were trying to reuse the existing dataset which we've used to create Crystal Reports. There is no option I could see to convert this dataset to a shared dataset so that I can reuse it. I could see the option to convert a new dataset to a shared dataset but not an old one. Or else what are the other options?

We're using VisualStudio 2015, SSDT for VisualStudio 2015, SQL Server 2008 R2.

Hope someone could help me.

Answer 1

SSRS can't use a Crystal Reports Dataset. But you can take the same query you used from Crystal Reports and paste it into a new Dataset in SSRS.

Answer 2

SSRS datasets are specific to SSRS reports, you can't migrate dataset from any other reporting service to SSRS. In your case, you can create a new dataset similar to crystal report by copying your query in new SSRS dataset and by refreshing the parameters/fields values in report being used with that dataset.

In case dataset is to be used by multiple reports you can use shared dataset.