Skip to Content
Former Member
Apr 06, 2016 at 08:16 PM

Crosstab Issue


Dear Experts,

I have a subreport that has a crosstab in the RH section. There are just 5 results on the crosstab which is generated by a SQL command that is not linked with the main query command.

The issue is my data (main query) is being multiplied by the number of records produced by crosstab results. Example: The total hours worked for an EIN should be 80 for a pay cycle. If my crosstab returns 1 record, there is no issue. If the crosstab returns 5 records, the total hours, in this case, is (80*5) = 400.

The hours, in this case, is @GF7.

Is there a way to fix the issue? I do not have the flexibility to take the crosstab to another section.