SSRS 2005 loses fields when updating a query
So I've been using 2008 basically since I started working with SSRS. But for my new job they are only on 2005 and I've run into a lot of weird issues. The main thing that I can't seem to get around is this. Currently I have a report that has 5 datasets. This is a report my boss made and I am needing to update with a VERY basic change while he is gone. The report itself uses fields from the 4 datasets I need to change. All of these datasets are pretty much the same except for one different ID number, and there is one dataset for each of the 4 tables. The dataset in question (all 4 do this though) has 3 fields, "desc", "val" and "id". When I go and change ANYTHING in the query of the dataset, they vanish. It could even be something as ridiculous as adding a space, and then erasing that space. When I do that and try to run the report I get errors: [rsFieldReference] The Value expression for the textbox textbox7 refers to the field short_desc. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. [rsFieldReference] The Value expression for the textbox textbox9 refers to the field val. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. Even though it worked 100% fine before I added this space (and then removed it). So basically ANY change from the original version causes this problem. I refreshed the fields, which has fixed similar issues before, but even after I do that, on the left under Report Datasets, the dataset is showing no fields under it. So I right-click Report Datasets and 'Refresh', same problem. Oddly, when you do it this way, it adds the + sign next to the dataset like it has fields under it but if you click it, the plus vanishes instead of turning into a - and it has no items listed under the dataset. And finally, if I Edit Selected Dataset and go to the Fields tab, it is now completely blank. A simple undo fixes that but I sort of need to update the report =) Has anyone run into this particular [what I can only assume is a bug] ? EDIT - By the by, I can manually add the fields back under Edit Selected Dataset > Fields...but that is pretty time consuming and seems silly to have to do. I'm hoping there is a way around that. Dachish
March 24th, 2011 10:07am

Hi Dachish, To the issue of yours, I would recommend you have a test to the datasource to see whether it connect correctly. Execute the query in your SSMS firstly, if it works fine, then copy it to report designer. Lastly, make sure your dataset return all the fields being used on your report body and dataset name keep same as original, otherwise it will show the error. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 8:53am

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

Other recent topics Other recent topics