sql server reporting services: Comparing 2 different Group's aggregate Values -- sql server reporting services

Comparing 2 different Group's aggregate Values

Sen
9/2/2005 4:23:36 PM

sql server reporting services:

Hi All,

In my report, i've 3 groups and i want to hide a group footer by
comparing a textbox value in group1 and a textbox value in group2, for
eg., i've Sum(Fields!Amount.Value,"table1_group1") in one of group1
footer's textbox and Sum(Fields!Amount.Value,"table1_group2") in one of
group2 footer's textbox, if both these values are same i want to hide
group1 footer, but i am getting "The value expression for the textbox
has a scope parameter that is not valid for an aggregate function. The
scope parameter must be set to a string constant that is equal to
either the name of a containing group, the name of a containing data
region, or the name of a data set.", any workaround methods for this?.
Your help is highly appreciated.

Thanks in advance
Sen

RE: Comparing 2 different Group's aggregate Values

OriginalStealth
9/2/2005 5:51:21 PM

Textboxes are ReportItems. To hide a footer base on the value of two
textboxes set the Visible(Hidden) property to:

1. =ReportItems!textbox1.Value + ReportItems!textbox2.Value = 10 or

=IIF(ReportItems!textbox1.Value + ReportItems!textbox2.Value = 10,
False, True)

[quoted text, click to view]

RE: Comparing 2 different Group's aggregate Values

Sen K
9/7/2005 2:31:02 PM

Hi,

Thanks for your suggestion.

I tried your option also, but i'm getting the following error,
"Report item expressions can only refer to other report items within the
same grouping scope or a containing grouping scope". The problem here is i'm
trying to compare 2 different group's textboxes. So i'm getting this error.
Any help is highly appreciated. I tried with other options of hidden
expressions and all, but it didn't help me. I cannot modify the Stored Procs
used for this report.

Thanks and Regards,
Sen

[quoted text, click to view]

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 in the sql server reporting services group.