A custom number for every report page

rbuser

Hi Support;
I am just wondering is it possible to give a different and sorted custom
number for every record page.?


Thanks

nardmoseley

1. Please configure your newsreader to post using your real name. (It
currently says "news.digital-metaphors.com").

2. One solution is add an auto-increment datafield to your database tables.
Then you can build a SQL query that orders the records by the autoincrement
field and use a DBText in the report to print the value.

rbuser

its not possible to use autoincrement field for me.. I want to use different
custom number everytime.. So Thats why I ask..

I just create a No field in different table. How can i show it in the report
for example:

If I enter asssign 14500 and there are 45 records

Last page number has to be 14545

Did you understand what I mean..Every page +1.

rbuser

sorry for username..

nardmoseley

Try using a TppVariable. In the Variable.OnReset event intialize the value.
In the Variable.OnCalc event increment the counter.

rbuser

is there any example in your tutorials about this? Can you explain it
alittle bit..
Thanks Nard.

rbuser

Dear Nard;
Can you explain me how can I initialize an increment couinter??

Thanks

nardmoseley

Try this:

1. Add a TppVariable to the report. Set the DataType to dtInteger

2. Position the cursor over the Variable and press the right mouse button.
Select the Timing... menu option.

3. Set CalculateOn to PageStart and set ResetOn to ReportStart

4. Add code to the TppVariable.OnReset

Value := 150;

5. Add code to the TppVariable.OnCalc

Value := Value + 1;