Hi.
I have a report, within which are 2 subreports.
Each subreport is the result of a crosstab query.
They sit side-by-side on the main report page.
Each crosstab query produces monthly sales totals and a line total for the current year and the previous year.
I would like to show the % sales comparison between the current year and the previous year.
i.e. (Current year line total / Previous year line total ) * 100
Is it possible to have a field in the body of the main report, which is a calculated field using the line total values from the two subreports?
(Showing the % comparison)
i.e. the resultant value appears at the right hand side of the page, at the end of the line of data returned by the 2 crosstab queries.
Any advice will be welcomed.
Thanx.
I have a report, within which are 2 subreports.
Each subreport is the result of a crosstab query.
They sit side-by-side on the main report page.
Each crosstab query produces monthly sales totals and a line total for the current year and the previous year.
I would like to show the % sales comparison between the current year and the previous year.
i.e. (Current year line total / Previous year line total ) * 100
Is it possible to have a field in the body of the main report, which is a calculated field using the line total values from the two subreports?
(Showing the % comparison)
i.e. the resultant value appears at the right hand side of the page, at the end of the line of data returned by the 2 crosstab queries.
Any advice will be welcomed.
Thanx.
