Delphi 7 Rave 5 reports database connection

[lexd]

I'm running Delphi 7 and updated Rave 5.0 reports standard freeware edition. I have not used rave before but it looks good. I have a ADO connection to MS access database that's working fine in all respects.
My objective: - I'm taking my clients table to print on a envelope with current record in clients table.
Rave RvProject object is set to the envelope, no problems.
RvDataSetConnection finds the database tables from my DataModule very well but I cannot link RvDataSetConnection to a text object in RvProject object.

I have registry strings that I wish to place in text fields in my RvProject object but I need an appropriate method to insert the text before printing.


Thanks in advance





database

[GeoWink]

Here is what I do...

On the FormCreate Event I put in the following...

DH := 'c:\YourDirectory' + 'MyDataBase.abs';
DB.Connected := False;
DB.DatabaseFileName := DH;
DB.Connected := True;

I use the Absolute Database.

Then in a RVSystem I put in

with Sender as TBaseReport do
begin
FN := 'SchoolRemarks'; // The table name
with LineQuery do
begin
Close;
SQL.Clear;
SQL.ADD('select * from '''+FN+'''T');
SQL.ADD('order by T.Breaker');
DisableControls;
Open;
EnableControls;
gYPos := 0.6;
I := 0;
while not eof do
begin
gYPos := gYPos + 0.2;
GoToXY(4.25,gYPos);
PrintLeft(FieldByName('TheLine').asString,1.0);
Next;
end;
end;
end;

This prints as many lines as there are in the table. I just like to be simple and straightforward.

George

[lexd]

yes you have set up your data base the same as me

DH := 'c:\YourDirectory' + 'MyDataBase.abs';
DB.Connected := False;
DB.DatabaseFileName := DH;
DB.Connected := True;

I'm very happy with that
Loading RVSystem text objects from code is fine if I new what RVSystem event I can do that with.

I understand RVSystem.exicute executes the print I think.

You see I do not have my head around how to drive RVSystem properly and use its events.

[GeoWink]

To run the print use

RVSystem1.Execute;

George

[lexd]

1/ Does RVSystem run an event before its print starts.
2/ Can RVSystem be placed in any form I like and can i place 2 separate RVSystem's in a form for separate pages like envelope and A4 page format

[GeoWink]

Whenever I run RVSystem I get a choice of Preview or Print. You can also do a setup so you can change printers if necessary. Otherwise it uses the default printer. See System Options.

I have some forms that have 20 RVSystems on it. You do as many as you like.

George

[lexd]

Its I'm not use to Rave as its not an normal object.
I will simply load it up before the print in one procedure

I just did not want to upset my database with heaps of trials

Lex Dean.

[GeoWink]

Not sure what you meant by not a normal object, looks pretty normal to me. Also should not bother any database you have, just write using it, simple.

George

[lexd]

A rave object displays its own form and not an IDE style form. to me that's not normal and more tings can be going behind the seen that I do not know about.

Thats all
Thanks.