REPORT in Clarion 6

1

Good morning, I am currently modifying an old management application of mine that generates invoices. Until now, the invoice total was located at the top in the ‘Page header’. Now, I’ve decided to move the invoice total to the bottom of the line items list, separated by a line, just like we are traditionally used to seeing.I am aware that Clarion 6 is quite outdated, but before migrating the app to Clarion 12 (which I have just purchased), I would like to make sure the current application works perfectly without any flaws.I looked through the Examples and found the one in INVOICE.APP, which shows the creation of a second RPT:Detail1 in the REPORT. I’ve read up on it, experimented, and even consulted AI, but I haven’t been able to achieve what I want. It prints, but it prints a small line after every single detail line. I also tried adding a counter to check for the end of the records (usually around 20), but to no avail.I am reaching out to the community to see if anyone can give me a hint or some guidance on how to solve this issue. Thank you in advance!Good morning, I am currently modifying an old management application of mine that generates invoices. Until now, the invoice total was located at the top in the ‘Page header’. Now, I’ve decided to move the invoice total to the bottom of the line items list, separated by a line, just like we are traditionally used to seeing.

I am aware that Clarion 6 is quite outdated, but before migrating the app to Clarion 12 (which I have just purchased), I would like to make sure the current application works perfectly without any flaws.

I looked through the Examples and found the one in INVOICE.APP, which shows the creation of a second RPT:Detail1 in the REPORT. I’ve read up on it, experimented, and even consulted AI, but I haven’t been able to achieve what I want. It prints, but it prints a small line after every single detail line. I also tried adding a counter to check for the end of the records (usually around 20), but to no avail.

I am reaching out to the community to see if anyone can give me a hint or some guidance on how to solve this issue. Thank you in advance!

2

These pics are from Clarion 11, but all versions should be pretty much the same since those examples have been around a long time.

Notice that the second detail is set as filtered to FALSE in the report properties.
Then it’s manually printed in code at the end of the report. (Here, they’ve stuck that in ThisWindow.TakeCloseEvent.)

reportDetail1
reportDetail1558×278 47.5 KB

reportDetail2
reportDetail2384×602 103 KB

3

Jane’s answer is the correct answer to your question, but my question is…

why you haven’t used a “Surrounding Break” around your invoice line item detail and then added a group footer to that surrounding break so you can place a field for the total in the footer? Doing so will automatically calculate the totals for you.

I’m guessing you have calculated the totals manually, in which case just use Jane’s solution.

4

Thank you very much for your invaluable help. My mistake was that I wasn’t using the TakeCloseEvent PROCEDURE, but other procedures instead. It is worth noting that in my Print Procedure properties, I cannot set detail1 - FALSE in the Filter, but it works without it anyway. It is finally working now, thanks to all of you!
SilvanoThank you very much for your invaluable help. My mistake was that I wasn’t using the TakeCloseEventPROCEDURE, but other procedures instead. It is worth noting that in my Print Procedure properties, I cannot set detail1 - FALSE in the Filter, but it works without it anyway. It is finally working now, thanks to all of you!

Silvano