Home Datapipelines
New Blog Posts: Merging Reports - Part 1 and Part 2

Cached report

edited June 2007 in Datapipelines
Hi.

I have a simple report (header and detail only) in ReportBuilder 7.02 (i
know, it's old).
I'm using a tppBDEPipepline as datasource.
I do a select statement from a very big table(AS_ASANA), and then insert the
records into a temporary print table (AS_ASANA_PRT).
Then i do some calculations for some of the colums, and show the report
using this code:
ppFPCReport.PreviewFormSettings.WindowState:=wsMaximized;
ppFPCReport.PrintReport;

If i change something in my select-statement, delete everything in the print
table, re-populate it and show the report again, it still shows the previous
selected data.
I've tried close/open on the table and pipeline and the reports Reset
procedure.
But the report still shows cached data. I check it using the IsCached
function.

How do I go about to always show the data in the print-table?

Greets,

Bjarne Anker
ADCom Data AS
Norway

Comments

  • edited June 2007
    I figured it out:
    data.ds_AS_ASANA_PRT.Dataset.Close;
    data.ds_AS_ASANA_PRT.Dataset.Open;

    This refreshes det datastore(dataset?) which the pipeline is connected to.

    At last....only 2 workdays down the drain for those 2 lines of code....:-/

    Bjarne



This discussion has been closed.