Sunday, March 25, 2012

data set problem in RTM Professional Edition - sql server 2005

Hi,
I create a report with the Report Wizard Designer and are able to pre-view and deploy it (it’s a simple table with an OLAP data source), but if I switch to the "Data" tab the related DataSet seems to be empty and then, if I go back to the "Pre-view" tab, I can't view the Report no more and have this kind of error: "

[rsFieldReference] The Group expression for the table ‘table1’ refers to the field ‘Semestre’. 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 ‘Valore’ refers to the field ‘Valore’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
..................

Build complete -- 5 errors, 0 warnings
"
As if the DAta Set were empty, in effect. But I didn't make any changes in the "Data" tab, I only switch there to see the Data definition.
Which can be the problem?
Thank you very much.

This is a known problem. It will be fixed in the next Service Pack. The workaround is not to use the Wizard to create the report. Instead use the Data tab to create your query.

Thanks,
Albertsql

No comments:

Post a Comment