Solved

dbase record numbers in Quick Report

Posted on 2000-05-17
6
388 Views
Last Modified: 2010-04-04
I have a database application written using Topaz for Delphi (database engine). On the preview of some reports i require the record number to be displayed for each record in the report.
I can not seem to find a way of achieving this. The QRSysData component does not show the actual record number but just numbers the records sequentially. I require the 'Table1.RecNo' value for each of the records in the report.

Thanks Paul.
0
Comment
Question by:pr_wainwright
  • 2
  • 2
  • 2
6 Comments
 
LVL 2

Expert Comment

by:IPCH
ID: 2820348
Add calculated field.

procedure TForm1.Table1CalcFields(DataSet: TDataSet);
begin
  Table1RN.AsInteger:=Table1.RecNo;
end;
0
 
LVL 9

Expert Comment

by:ITugay
ID: 2820354
Hi Paul,

you can drop TQRLabel onto your report and write QRLabel.OnPrint event:

....
begin
   Value:=IntToStr(Table1.RecNo);
end;

----
Igor.
0
 
LVL 9

Accepted Solution

by:
ITugay earned 100 total points
ID: 2820359
IPCH ;(

What are you talking about?

------------ RecNo -----------
Indicates the current record in the dataset.

property RecNo: Longint;

Description

Examine RecNo to determine the record number of the current record in the dataset......
-------------
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:pr_wainwright
ID: 2823466
ITugay's answer is exactly what i was looking for.

Thanks Paul.
0
 
LVL 1

Author Comment

by:pr_wainwright
ID: 2823482
Right first time. Not bad considering i am terrible at explaining what i am trying to achieve in my questions !.

Thanks Paul.
0
 
LVL 2

Expert Comment

by:IPCH
ID: 2824584
I am not Paul, I am Ivan
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Mydac connection data base issue 3 135
FMX enumerated colours 2 84
LAN or WAN ? 11 81
how can i search if string exist in array ? 3 49
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now