Reset report for second run

rbuser

Hi,

I have a problem to reset report before user run report again. I call
Report.Reset method but it does not help - the report shows old values!

It may be because report is using MS SQL view for source data (not the
table). Even table contents has changed, the RB or the connention has cached
data from the view.

Can anybody help?

Jan Najvarek

rbuser

Hi Jan,

so why not refreshing the view?

HTH,
Chris Ueberall;

rbuser

The view refreshs itself (I can check it in SQL analyzer), but reports still
uses old values.

I got hint form support to use:

TppDBPipeline(Report.DataPipeline).CloseDataSource := True;
Report.Reset;
Report.DataPipeline.Close;

which partially helps, but still does not refresh the data in the report for
detail tables.

Jan


"Chris Ueberall [TeamDM]" p??e v diskusn?m

rbuser

To answer myself:

I have realized ALL subreports must be reset the same way as the main
report, then it works!

Jan