Changing a data set in SSRS
Am in SSRS- have a report similar to previous one, so used it as a base by copying it to a new rdl file and renaming it, then added existing new report fiel to project- Problem: I need to use a different data set. Attempted: added new data set, and deleted old one Results: no matter what i do, I get a 'Data Set XXX does not exist in this report' error when I try to click on the data field and change the field for it. No kidding it doesnt exist, I deleted it and added the new one. Have tried for 2 days to get it to accept the new data set. Current method is to have to recreate each report from scratch, instead of using an existing one and adjsting. Over 230 reports - this will quadruple development time and in reality makes SSRS useless. Is there a way to get it to recognize that yes, in fact i changed the data set, so it should be looking at the new one? Thanks gej61
April 27th, 2011 2:29pm

Click on the table and go to properties, there is a property called Dataset Name, change it to the new dataset. Have you done this already?
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 3:03pm

Have you considered using Shared DataSet functionality? If all your reports are using the same dataset, then you should use this feature. It will make managing the dataset very easy. More details at : http://msdn.microsoft.com/en-us/library/ee636147.aspx Thanks, RamaThis posting is provided "AS IS" with no warranties, and confers no rights.
April 27th, 2011 6:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics