Cached report
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
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
This discussion has been closed.
Comments
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