Dataset

[Anonymous]

Hi,

I have a custom report build on a dataset. I am planning to split the report with orignal dataset. One of sub report will replace existing dataset name as that of original name and 2nd sub report will be with different name.

Will the split of dataset will impact the custom reports? Do I need to rebuild custom reports?

Thanks 

[GilbertQ]

Hi there

If you keep the original report it should not have any impact?

Could you give more details as to what you mean about splitting the dataset?
Do you mean splitting the reporting visuals?

[Anonymous]

Hi Gilbert,

The original report needs to replaced by 2 sub reports.

The orignal report is having 10 tabs and 4 dataset. I am splitting report with 5 tabs and 1 dataset in one of the sub report and the remaining in second sub report.

Dataset name of 1 of these sub report is similar to the original dataset hence it will replace the existing dataset. So will data of the other sub report(having different name than original dataset) will be available is custom report?

[GilbertQ · Accepted solution]

From the sounds of it I would suggest creating your 2 datasets.

Then having the new dataset open and the old dataset. Using the new copy and paste feature you can copy all the contents from one report into your new dataset. As long as the column names and measure names are the same the report will work perfectly. I think that will be less effort than trying to do the above.