End-user reports

rbuser

Hello,

we have several subreports defined in a report.
Each of them has a query. The report is stored in the database.
Is it possible to send the sql statement for each subreport to the report
before printing it.
We have tried using autosearch values, but some don't get filled in for an
unknown reason.

Thanks,
Bernaert Dominique.

digitalmetaphors

We need to figure out why the AutosearchValues aren't getting set.

There is an example of setting DADE autosearch values in your installed
..\RBuilder\Demos\AutoSearch\6.SetEndUserSearchCriteriaInCode


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hello,

I've looked at the demo code you indicated.
We do exactly the same.
We are working with SQL Server and are accessing it using Asta.

Dominique.

digitalmetaphors

Take ASTA out of the equation as a test. Just connect ot SQL Server without
other middleware. Try to reduce the complexity to find what piece may be
causing the problem.

As for us being able to research the problem, we'll need more information.
If there is a problem with the autosearch criteria not getting applied to
the sql, then we need to fix it. What is the dataview configuration? Can
you send us an example report template, connected to sample SQL Server data,
which shows this behavior, or tell us how we can reproduce it? Send an
example to support@digital-metaphors.com


Cheers,

Jim Bennett
Digital Metaphors