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

Is it possible to include PHP-code in a SearchParams template?

edited March 2004 in Server
Hello,

I like to run php code in my searchparams template.
I fill like 3 select comboboxes in the searchparams template with data
from a mySql database.
Depending on the choise of the first select the second one gets filled
with data and so on for the third one.
These are three values I like my clients to choose from and send through
as search parameter.

Can I do this?

Thanks,
Pascal

Comments

  • edited March 2004

    I am not familiar with PHP, but...

    1. You can call a report via a URL and include the parameters - see article
    below.

    2. For an example of custom forms via WebBroker, see
    RBServer\Demoes\WebTier\Custom Parameters\. There is a ReadMe.doc and
    commented code included with the example.



    ---------------------------------------------
    Tech Tips: How can I request that the webtier
    execute a specified report?
    ---------------------------------------------


    Question:
    ---------

    Without using the Web ReportExplorer, how can I request that the webtier
    execute a specified report?


    Solution:
    ---------

    The webtier processes requests for web content. These requests consists of

    1. The URL for the webtier

    example: http://127.0.0.1/rbWebPub/report.dll


    2. A parameter specifying the content type.

    example: content=viewer

    {note: content=viewer, is used to request report viewer content.}


    3. Additional parameters that are specific to the content request.

    volume=Report Forms (the volume name)
    Name=Basic\Biolife Table (the full path name to the report)
    frameset=1 (show the framset with the toolbar etc., this is required)


    Use a web browser to access the webtier demo that displays the report
    explorer.

    Notice that when you place the mouse over a report in the report explorer
    that the status bar in IE shows the url plus some params. That is the string
    required to run the report on the web tier.

    Example:
    http://127.0.0.1/rbWebPub/report.dll?content=viewer&volume=Report
    Forms&name=Basic\Biolife Table&framset=1


    So the parameters here are

    content=viewer (type of content is report viewer)
    volume=Report Forms (the volume name)
    Name=Basic\Biolife Table (the full path name to the report)
    frameset=1 (show the framset with the toolbar etc., this is required)


    4. AutoSearch Parameters

    To specify autosearch parameters for a report, include the parameter
    'newsearch=T' followed by the autosearch parameters.

    AutoSearch parameters have the following naming convention: asgXfYse and
    asgXfYsa.

    The asgX specifies the autosearch group number, where X is the number. The
    fY specifies the field number, where Y is the number. The se indicates that
    the value is a search expression and the sa specifies that the value is the
    "show all" boolean expression.


    Example:

    content=viewer
    newsearch=T
    asg0f0se=S
    asg0f0sa=false


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited March 2004
    Thanks Nard,

    I can use the tip for sure.
    The php code does not work directly in the searchparams page
    but I found a workaround.
    I now redirect to a different page an pas along the report parameters.

    Greetz,
    corpa

This discussion has been closed.