Search Not Appearing

rbuser

Hi All,

I'm trying to use the Custom parameters Example with SQL server (that is all
working fine) but since I combined the two, now the search dialog doesn't
come up at all ? I'm sure there's an easy explanation but Ive been
scratching my head for hours as to why. I am using directory filtering etc
too.

My ultimate goal is to have normal rb search dialog appear but have one of
the search fields not show, instead I pass in the user login name. Any
information on that would be appreciated as well.

Kind Regards,
Graham

nardmoseley

Based on your description I think you want to use SessionParameters to
capture the user login information and then apply that information to the
report query.

1. Implement the custom login form as shown in the custom parameters demo.
This will allow the user to specify the session parameters used for all of
the reports he/she runs during a session.

2. For the reports, define AutoSearch parameters for the additional info to
be entered by the user from the standard autosearch dialog.

3. Allow the AutoSearch feature to work automatically

4. The remaining piece is to apply the session parameter info to the report
query. This can be done on the server side by implementing the
ReportVolume.BeforePublishReport event. The aEventParams object passed to
the event-handler provides access to the report instance and to the
SessionParameters. You can extract the TdaSQL object associated with the
report query and apply the SessionParameter values by adding search criteria
to the TdaSQL object. Here is an example of extracting and modifying the
TdaSQL object...

www.digital-metaphors.com/tips/ExtractSQLObject.zip





--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Hi nard,

Is this example for the normal (ie non-server) report manager ? It doesn't
relevant for the server version. The report passed through via BeforePublish
is of type tppproducer not tppcustomreport. Is there a server exampel ?
Is there any documentation for the format of these SQL objects etc ?

Also how do I modify a search field as opposed to another field ?

So if i fill in data for this search field, it won't then display when the
search dialog appears ?
EG: at the moment the search dialog comes up with Load No and Supplier
code. I want to pass in supplier code, but still want the search dialog to
display load no.

Thanks,
Graham

nardmoseley

1. I provide you a downloadable example that shows how to extract the TdaSQL
object and modify it. The example is focused on showing how to do just that.
The example can be adapted for any report - stand alone or server.

2. TppProducer is the ancestor to TppCustomReport, TppArchiveReader. You can
typecast it to TppReport or TppCustomReport, etc.

3. The TdaSQL.SelectCriteria[] array contains the search criteria. Each
element in the array is a TdaCriteria object. TdaCriteria.Field.AutoSearch
would indicate whether the Criteria object is an autosearch field or not.


4. The BeforePublishReport event is too late to fill default information
that is displayed to the user. Instead, try using the OnLoadReportEnd event.


--

Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com