Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Search Not Appearing

edited October 2004 in Server
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

Comments

  • edited October 2004

    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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2004
    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

  • edited October 2004


    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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.