Skip to Content

How to make comparision between column in main report and that in sub report?

May 06 at 04:30 AM


avatar image
Former Member

I am trying compare one column in main report with that in sub report. I tried using shared variable. I realized that shared variable can be used to aggregate the entire column as sum or something but it does not help you import the entire colum. Am I correct? What I can see is that shared variable has the last value from the subreport stored in it. That same value is repeatedly populated in mainreport. Can any one suggest how to import the entire column from subreport to main report?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dell Stinnett-Christy May 06 at 03:56 PM

If you have to use a subreport, you can't pull all of the data into the main report.

If you have good SQL skills, you might be able to write a Command (SQL Select statement) that would pull all of the data for the report in a single query. This is not going to be a simple query, though.


10 |10000 characters needed characters left characters exceeded