Losing my parameters and fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MrGrundh - 24 Sep 2007 09:06 GMT

Dear MSDN!

I have designed a report in VS 2005 Report Server Projekt. The report
connects to a Analysis 2005 server. Everything works fine in Layout tab and
preview tab until i click data tab. After i have clicked the data tab the
report starts to show errors in the output and error list window:

[rsFieldReference] The Value expression for the textbox
‘Sales_Price_Gross_Incl_Discount_1’ refers to the field
‘Sales_Price_Gross_Incl_Discount’. Report item expressions can only refer to
fields within the current data set scope or, if inside an aggregate, the
specified data set scope.

Visual studio have automatically checked out the report and changed the xml,
deleted the parameters and field definitions.

What is the problem?

Thanks in advance!

Reply to this Message

Wei Lu [MSFT] - 24 Sep 2007 10:12 GMT

Hello Grundh,

I found this is a Known issue in SQL Server 2005 and has been fixed in SQL
Server Services Pack 1.

I suggest you applied the latest service pack of SQL Server 2005 and check
it again.

913089 How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/default.aspx?scid=kb;EN-US;913089

Hope this helps.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

MrGrundh - 24 Sep 2007 10:32 GMT

Hell Wei!

I installed SQL2005 SP2. It seems that creating new reports works fine but
my old reports still have the error.

> Hello Grundh,
>
[quoted text clipped - 21 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Wei Lu [MSFT] - 25 Sep 2007 03:16 GMT

Hello Grundh,

Have you recompile the project?

It seems that the data tab changed some value when you open the old report.

Could you please recreate the data query you use?

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

MrGrundh - 25 Sep 2007 07:22 GMT

I've created new reports for thoose who dit not work.

Thanks for your help!

> Hello Grundh,
>
[quoted text clipped - 16 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Wei Lu [MSFT] - 25 Sep 2007 09:24 GMT

Hi Grundh,

If you have any questions, please feel free to let me know. Thanks!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Losing my parameters and fields?

Free Magazines