Home Server

Extra Field in DB Template

edited September 2003 in Server
I hope i'm wrong with my conclusion, if there is a workaround it would be
quite easy.

Our setup, RBServer on a SQL Server, presenting all reports over a
RsWebTier, reports are also stored in the DB. In several reports we are
using autosearch fields, in the WebTier we must provide the wanted Html page
to enter the values. The checking on what report gets what form/html is
based on the name of the report.
Unfourtunatly in our company it happens from time to time that the name of a
report changes slightly, this means that we have to change code in the
webTier. Normally we would only change the report and upload it in the
server and that's it.

I think that it would be great to add a extra field in the properties of the
Db-template, a thing like rep_code, that once a reports has been created,
never changes, but the name could be modified.

--
Harry Leboeuf
Email Inversed moc.silopenik@fueobelh (For Spam-Reason)
Visit us at http://www.kinepolis.com

Comments

  • edited September 2003

    From your description I assume that on the WebTier you are using custom
    search pages rather than the built-in autosearch html form support.

    Try using the Report.Parameters to save this additional metadata.

    For each report, use the Report.Parameters property to defin a
    parameter named rep_code and an associated value for each report. This
    information will be saved as part of the report definition.

    On the WebTier side use the WebTier.GetReportParmeters method to
    retrieve rep_code value from the report server.





    Best regards,

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