Cross Tab in Summary Band
I am placing two cross tabs in one summary band and am having problems. I
want both to be Sum and the second cross tab, using the same pipeline, seems
to be forcing me to have the second cross tab be Count. Both are to sum the
same dollar field, but for different fields (cost by GL Expense and another
cross tab for cost by GL Accum. Also the second band seems to remember its
contents when running the report a second time for another customer
altogether, second band doesn't seem to clear itself and holds onto the
first report's dataset content values. Have to run the second customer
twice to get the correct value.
Any help much apprciated.
Thanks.
want both to be Sum and the second cross tab, using the same pipeline, seems
to be forcing me to have the second cross tab be Count. Both are to sum the
same dollar field, but for different fields (cost by GL Expense and another
cross tab for cost by GL Accum. Also the second band seems to remember its
contents when running the report a second time for another customer
altogether, second band doesn't seem to clear itself and holds onto the
first report's dataset content values. Have to run the second customer
twice to get the correct value.
Any help much apprciated.
Thanks.
This discussion has been closed.
Comments
report, I was able to resolve by setting the report cache property to True.
I had noticed in the report preview that the second preview of the report
"remembered" the first report's second cross tab when the first report was
closed while viewing the second to last page of the report and where the
last page (uncached) contained the second cross tab. The second cross tab
seemed to have been remembered by the second report and so ws not
re-generated in the next report previewed and continued to show its former
content for the previous customer.
Charles Wood