IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

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

Adding line # in table report

Adding line # in table report in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Adding line   Adding line #   table report  
davidc
Kansas City, KS

I'm sure there is a simple way to do this, but I can't find it!

I have a simple tabular report, based on a table with 3 dependant tables. For the report, I'm using a sort and a filter.

I'd like to add a field to the table which is the filtered record number rather than the "real" record number (meaning 1, 2, 3, etc. rather than 23,49,123, etc.).

Is there a simple way to do that?

(Worst case, I can run a query with the filter and do the report off of the result, but that seems like a lot of work.) 

Peace,
David Cheney

 Posted 9 years ago (Thread Starter)
Comment Quote
About davidc -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14545, 2 replies
Thread Started 4/8/2011 2:46:02 PM
View Counter=3103
Last Reply Posted 5/2/2011 4:01:15 PM)
Location=Kansas City, KS  
Joined=18 years ago   MB Posts=44  
Mark Metz
Fort Lauderdale, FL USA

I got this to work on a simple table I tested with.  First, I set the filter in the data model.  Next, I inserted a blank column into the report.  Then, Right Mouse Click to bring up the define field menu option.  In the Define Field Object dialog, in the summary section, select Count in the drop-down and Cumulative in the radio.  It will show the field definition as CumCount(:Alias:table_name.field_name). 

HTH!

 Posted 9 years ago
Comment Quote
About Mark Metz -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14594 (Level 2) and Parent is 14545
Reply Posted 5/2/2011 2:55:11 PM
Location=Fort Lauderdale, FL USA 
Joined=10 years ago   MB Posts=2  
Most Recent Post
davidc
Kansas City, KS

Perfect! Thanks!

(minor additional detail: have to select a field to do the summary on)

Peace,
David Cheney

 Posted 9 years ago (Thread Starter)
Comment Quote
About davidc -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14595 (Level 3) and Parent is 14545
Reply Posted 5/2/2011 3:53:58 PM
Location=Kansas City, KS  
Joined=18 years ago   MB Posts=44  

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 = P1311A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14545 Counter
3103
Since 4/8/2011
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


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