rs_to_more_than_one_report_item -- sql server reporting services

Andrus
6/6/2007 6:03:42 PM

I have the following expression in page header:

=Iif(Code.GetGroupPageNumber(ReportItems!Textbox4.Value,Globals!PageNumber)<>1,CStr(Code.GetGroupPageNumber(ReportItems!Textbox4.Value,Globals!PageNumber)),"")

this causes error

The Value expression for the textbox ‘Textbox2’ refers to more than one
report item. An expression in a page header or footer can refer to only one
report item.

How to fix ?

Using WinForms ReportViewer in local mode.

Andrus.

Lisa Slater Nicholls
6/8/2007 3:14:49 PM

First, I don't see Textbox2 being referred to at all. I see Textbox4.
Assuming that is a typo...

What happens if you use First(ReportItems!Textbox4.Value,<scope>) instead?

[quoted text, click to view]

Andrus
6/11/2007 9:36:07 PM

[quoted text, click to view]

This is not typo.

My expression

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : rs_to_more_than_one_report_item