sql server reporting services: compare values within subreport to main report -- sql server reporting services

compare values within subreport to main report

aggiechick717
10/9/2006 1:52:37 PM

sql server reporting services:

I was wondering if anyone knew how to take a value from a subreport and
compare it to a value iwthin the main report. We are trying to see if
the value in the subreport is greater than the value returned in the
main report. We want to make the value test red if it is greater than.
I know how to compare these values if they were in the same report, but
when it comes to subreports I am lost. Any ideas? Thanks in advance.

Missy

RE: compare values within subreport to main report

daw
10/20/2006 11:59:02 AM

Did you ever find an answer to this? I'm having the same issue.

[quoted text, click to view]

RE: compare values within subreport to main report

daw
10/20/2006 12:55:02 PM

Nevermind. I was trying to access the total in a subreport for use on my
main report, but I just setup a second datasource on my main report with the
total. That worked.

[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.