problem with report item in page header

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

problem with report item in page header

Author

Topic

roy mm
Yak Posting Veteran

62 Posts

Posted - 2008-10-02 : 03:12:28

Hello.

I'm trying to use the same reportItem (textbox) twice in a report header.

Like:
=switch(reportItem!txt1.value="a","a", reportItem!txt1.value="b","b")

and I'm geting the error:
[rsMultiReportItemsInPageSectionExpression] The Value expression for the
textbox 'txt1' refers to more than one report item. An expression
in a page header or footer can refer to only one report item.

This is dispite the fact that I'm useing the same report item.

Is there any thing I can do about that?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-02 : 04:01:02

what are you trying to display in report header?

roy mm
Yak Posting Veteran

62 Posts

Posted - 2008-10-02 : 04:48:33

quote:
Originally posted by visakh16

what are you trying to display in report header?

I'm trying to display a text according to a reportItem value.

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-02 : 04:51:41

quote:
Originally posted by roy mm

quote:
Originally posted by visakh16

what are you trying to display in report header?

I'm trying to display a text according to a reportItem value.

Thanks.

ok. but isnt below

=switch(reportItem!txt1.value="a","a", reportItem!txt1.value="b","b")

same as =reportItem!txt1.value
since you're trying to display the same value that's in report item.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources