We are doing some web development can I access my delphi reports from ASP. Eg have an end user click a button and receive either print a report or have one emailed
Download a trial version of RB Server Edition. It contains an ASP example. The RB WebTier can publish a report explorer interface and you can optionally bypass it and just invoke the reports directly (see tech tip below). To get started, work thru the tutorials in the RB Server Developers Guide.
Live Web Demo www.digital-metaphors.com/rbServerLive
--------------------------------------------- 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
{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.
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. Session parameter
Each user request is assigned a session id (a GUID). Include the session id parameter with subsequent request for the same user session.
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.
Comments
Download a trial version of RB Server Edition. It contains an ASP example.
The RB WebTier can publish a report explorer interface and you can
optionally bypass it and just invoke the reports directly (see tech tip
below). To get started, work thru the tutorials in the RB Server Developers
Guide.
Live Web Demo www.digital-metaphors.com/rbServerLive
Product information http://www.digital-metaphors.com/products/report_server/
---------------------------------------------
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. Session parameter
Each user request is assigned a session id (a GUID). Include the session id
parameter with subsequent request for the same user session.
Example:
SessionID=%7BA891340B%2D359B%2D40A0%2DB5B8%2D4DA1B91C0114%7D
5. 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
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com