Printing of 1st page twice and other problems.
I have 2 reports out of 3 that print the first page twice. I can not find
what is causing this problem. I have tried placing a new report component
on the form and manually copying the form information to the new report and
I get the same results as when I use the saved template. The commonality is
that the two reports that exhibit the problem have master-detail
relationships, 2 data pipelines and sub-reports. The one that does not
exhibit the problem is a single master.
Probelm # 2 is that on the billing report with a M-D relationship, the
sub-totals are correct but the grand total using a dbCalc component on the
master summary produces an incorrect answer. It is off by nearly $20K. If
I place a vairable on the summary band and use the on calc event, I get an
answer that is almost correct. If I use a cross tab calculation I ge the
right answer.
Finally, I have a printing problem in that if I am in design mode and
preview the form and try and print it, even though only 1 copy is selected
it keeps printing the document over and over. The only way to stop the
behavior is to select a rang of pages rather than the default print the
current document.
Any help would be greatly appreciated as I can't get out my billing reports
with these errors.
Thanks.
John
what is causing this problem. I have tried placing a new report component
on the form and manually copying the form information to the new report and
I get the same results as when I use the saved template. The commonality is
that the two reports that exhibit the problem have master-detail
relationships, 2 data pipelines and sub-reports. The one that does not
exhibit the problem is a single master.
Probelm # 2 is that on the billing report with a M-D relationship, the
sub-totals are correct but the grand total using a dbCalc component on the
master summary produces an incorrect answer. It is off by nearly $20K. If
I place a vairable on the summary band and use the on calc event, I get an
answer that is almost correct. If I use a cross tab calculation I ge the
right answer.
Finally, I have a printing problem in that if I am in design mode and
preview the form and try and print it, even though only 1 copy is selected
it keeps printing the document over and over. The only way to stop the
behavior is to select a rang of pages rather than the default print the
current document.
Any help would be greatly appreciated as I can't get out my billing reports
with these errors.
Thanks.
John
This discussion has been closed.
Comments
and Win2K SP2.
Thanks.
John
IBClientDataSet for my query. When I changed to IBQuery, DataSetProvider
and ClientDataSet as a replacement, that problem went away. However, I
still cannot get the grand total using either a variable or the dbCalc
component to produce a correct answer.
On my cross tab report, it keeps printing the report over and over and the
only way to control it is to give it a page range. Anyone have any ideas?
Thanks again
John