Requerying

rbuser

Using 14.01 (14.03 breaks a report for me)

Question 1: I have a report that is set to TwoPass.

It seems every pass it is requerying. is there a way to keep that to one
query and still be a twopass report?

Question 2:

I have a page in my application that contains a ppViewer. It used to
refresh it self when the report was "printtodevices" but now i have to
printtodevices and then do a regeneratereport. Did something change?

If i do not regenerate the report it continues to show the old report on
the screen.

Thanks.

nicocizik

Hi Chris,

The definition of a two pass report is that the data will be traversed
twice. The first pass is just to measure pagination and make
calculations. The second is to actually draw the report. If you need
to look ahead at field values to make calculations or determine the page
count before the report is displayed, a two pass report is necessary,
otherwise a singe pass report is recommended.

What exactly needs refreshing when you make a call to PrintToDevices?
In my testing with a simple application (two reports on a form with a
single viewer and two buttons), simply calling PrintToDevices refreshes
the viewer as expected...

procedure TForm1.Button1Click(Sender: TObject);
begin
ppViewer1.Report := ppReport1;
ppReport1.PrintToDevices;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
ppViewer1.Report := ppReport2;
ppReport2.PrintToDevices;
end;

nicocizik

For the second issue, it may be that I'm using RB 14.03 that it
functions correctly. How does 14.03 break a report? Are you receiving
an error? Can you send an example?

If so, please send the example to support@digital-metaphors.com and I'll
take a look at it for you.