It looks to me like it is printing the same number of pages as there are in the query output...which is 5. 5 lines of output from the query and 5 pages of the same report.
I added a grouping on RiskDecision with the following:
Group Header = No, Group Footer = no, Group on = each value,
Group interval = 1, keep together = first detail.
I still get multiple pages. No change
I do have the chart in the group details section of the report. I do not have a grouping on risk decision. I will add a grouping and let you know what the output is.
I have created a 1 page bar chart. The bar chart prints 5 pages of the same chart and it should only print 1 page.
The report's recordsource calls the following query
TRANSFORM Sum([Fit Gap].RiskCount) AS [The Value]
SELECT [Fit Gap].RiskDecision
FROM [Fit Gap]
GROUP BY [Fit Gap].RiskDecision...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.