Some records do not print in detail databand

[Veljko Radovanovic]

Hello,

I'm using Delphi 7 and Rave reports 5.0

I have dataset (ZQuery) in Delphi project and related dataview in Rave. In
Rave project I have detail databand and a few datatext components (connected
to dataview). Sometimes happens that some records from dataset do not appear
in print preview. That happened two times (two differente our users report
this bug) for the last three years. Each time disappeared records at the
middle of dataset, and each time it was with a large number of records (over
6-7 hundred of records).
This problem is rare, but it is serious (because users do not check are all
records in dbgrid/dataset printed - especially with large amount of data).

How can I block printing if there is difference between record count in
dataset and number of detail databand repeats (how can I find number of
detail databand repeats)?

Regards,

Veljko

[Trevor Keegan]

Hello Veljko,

RAVE is only going to print what you pass it in from your datasets i.e. it
will not create new records, nor will it remove records (unless you do it
through your connection). I suggest you begin by verifying that your query
is working correctly and then moving forward from there.

Regards
Trevor Keegan

[Veljko Radovanovic]

Hello Trevor,

I can send you source code if you are suspicious in my quotes :)
I use Delphi more than 8 years and this is the first time that I'm writing
to newsgroup - because of simply reason, for the first time I have no
explanation and I'm hopeless in my efforts to solve it. Application that I'm
talking about is Invoicing software with thousands of users, every day.
Wrong query is not possible in that circumstances, because users would
"kill" me at the same moment :)

Let me give you some more details that confirm my quotes:
I need to sum some fields. I do this in Delphi project with dataset fields,
and send that amounts as project parameters to Rave project (from some other
reasons I don't use CalcTotal components in Rave in that Report on that
Page, for calculating and after that printing sums). And amounts from Delphi
project includes all records, and print preview don't include all records
(user give me printed paper document).

Of course, there is not any source code between code that calculating field
sums in dataset and code with printing.
And of course, when user repeat printing - everything is OK (all records
appear in print preview).

As I said, this happened two times for the last three years. I don't know
what is the problem, and I can't repeat it. Because of that, this is not a
bug - this is a "problem" :)

I would be very grateful if you can help me with this question:
How can I block printing if there is difference between record count in
dataset and number of detail databand repeats (how can I find number of
detail databand repeats)?

Regards,
Veljko

[Trevor Keegan]

Hello Veljko,

I do not use Delphi (I use C++ Builder), so I will probably have a hard time
understanding the code and therefore miss something<g>

Post by Veljko Radovanovic
As I said, this happened two times for the last three years. I don't know
what is the problem, and I can't repeat it. Because of that, this is not a
bug - this is a "problem" :)

Yes...it certainly sounds like a problem. At least it only happens twice in
three years.

Once it happens I assume that there is something that you/user do so that
the next time it gives the correct result.....what is done to get the
correct results next time round?
Can you explain your setup to me....you mention that you do not have any
code....you are using connections?
What version of RAVE are you using?
Are you able to give an example of what happens when the data repeats
itself?

Post by Veljko Radovanovic
How can I block printing if there is difference between record count in
dataset and number of detail databand repeats (how can I find number of
detail databand repeats)?

You will not know the number of detail prints until RAVE actually comes time
to print it. So it is not going to be possible to do this sort of test.
RAVE does not buffer the information before printing, instead it simply
prints the records as it gets them.

Regards
Trevor Keegan