Change data, re-print report, same data (tried many things, none work)

rbuser

I've read all the posts on refreshing, but nothing works for me. (D7,
rbe77).

I want to print 3 reports on the same data, each sorted differently, one
right after the other.

I have a storedproc that accepts a parameter indicating sort order. (it
works correctly -- tested in query analyser).

The tppDBPipeline is set to open and close the datasource automatically.

Here's a summary of what I'm doing in code:

- set sort param
- print report
- set sort param
- print report
- set sort param
- print report

After setting the sort param, I've tried report.reset, report.resetdevices,
report.engine.reset. None of these makes a difference.

At wits end,

Jeremy

nicocizik

Hi Jeremy,

ReportBuilder allows you to use the AutoSearch capability to alter your data
and then refresh the report successfully. I would suggest taking a look at
the AutoSearch demos located in the RBuilder\Demos\5. AutoSearch\...
directory for an idea of what can be accomplished with this feature.

Note that using AutoSearch does not imply that you need to accept user
input, you can insert changes to your data yourself if you want. The
AutoSearch feature is meant to act as a simple gateway to alter your data
and property reset the report engine.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nicocizik

Hi Jeremy,

You may also want to take a look at the following example that updates the
report engine without the use of Autosearch.

http://www.digital-metaphors.com/tips/RefreshReportAfterDataChange.zip

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I suspect that the pipeline doesn't close the datasource when the report is
closed, but perhaps when it is freed. In any event, I explicitly closed my
datasource before setting params for subsequent viewings, and it seems to
work now.

Jeremy