Solved

dbase record numbers in Quick Report

Posted on 2000-05-17
6
390 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

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…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

778 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