Solved

dbase record numbers in Quick Report

Posted on 2000-05-17
6
386 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

9 Experts available now in Live!

Get 1:1 Help Now