Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    -Dell

    Add comment
    10|10000 characters needed characters exceeded