-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Reports Topic   Print This     

Report Printing 2 duplicate rows

Report Printing 2 duplicate rows in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Printing   duplicate   Report Printing   Report Printing 2   duplicate rows  
Shellbot
Dublin, -- UNK

Now, sorry if I am not using the correct terms here, but I'll try my best to explain whats happening:

EDIT: using Paradox 7 for win 3.1

Have a report which we print off which gives us the reg numbers of all vehicles under a companies licence. In a particular licence, there are 65 reg numbers. When we print off the report for this licence, 67 rows are printing out. 2 of them are duplicate values.

Now, I've gone into the table where I believe the data is coming form for the report, and there are only 65 rows in the table for that licence. So somewhere I am getting 2 duplicate values printing out.

This does not appear to happening (yet anyways) in any other licence reports that we print out.

I've no clue where to even start on this..

The only thing I can note is that it is a 6 page report, and the positioning of the duplicate rows are as such:

page 1 - information page, no data

page 3 - last row reg no=1234

page 4 - first row reg no=1234

page 4 - last row reg no=5678

page 5 - first row reg no=5678

Page 6 is an empty table (no data to fill it)

Could this be a layout issue? Thats what I was wondering at first, but then surely we'd have noticed it before on similar reports?

If anyone could maybe even point me in the right direction, I'd be delighted!!

Thanks very much,
Shellbot

 Posted 17 years ago (Thread Starter)
Comment Quote
About Shellbot
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13604, 1 replies
Thread Started 7/16/2009 6:21:59 AM
View Counter=4429
Last Reply Posted 7/21/2009 11:13:23 AM)
Location=Dublin, -- UNK 
Joined=17 years ago   MB Posts=3  
Most Recent Post
Shellbot
Dublin, -- UNK

Was the formatting.

The top part of the report was taking too much space..rearranged it all and took out as much white space as could at the end of it and that fixed the duplicate record coming out.

Must be the way it reads the data or something?

Shell

 Posted 17 years ago (Thread Starter)
Comment Quote
About Shellbot
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13616 (Level 1.1)  Reply to 13604
Thread Started 7/21/2009 11:11:14 AM
Location=Dublin, -- UNK 
Joined=17 years ago   MB Posts=3  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1147A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #13604 Counter
4429
Since 7/16/2009

Regarding...

Linked Knowledge Base Article.

This thread is linked to the following KB article.


Mike Prestwood
1. Power: Chapter 12, Handling Reports

Chapter 12, "Handling Reports" from Paradox 9 Power Programming by Mike Prestwood.

Posted to KB Topic: P9 Book: Power Programming
23 years ago, and updated 17 years ago

KB Post
Nothing New Since Your Last Visit
19442
Hits

Corel Paradox / ObjectPAL Coding

Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]