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

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

[DellSC]

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.

-Dell