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

rbuser

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

nardmoseley

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

rbuser

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