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

Appl.

edited October 2004 in Server
Hy !

I have a project where i work with delphi 8 dot net.

I want with an URL to access to the report server with parameter and with
parameter execute a query and after execute directly the report and view it.

Some body can tell me how to do that and tell me the different components to
use.

thank you for your help.

J?r?me

Comments

  • edited October 2004

    ---------------------------------------------
    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

    --


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2004
    Thank you very much for your answer !

    But when i execute the demo i receive the error 404 of the IS server !

    Why ?

  • edited October 2004

    I just tried the following:

    1. Compile the RBServer\Demos\Servers\Main\rbServer.dpr application and got
    it running within the context of ReportBuilder Services.

    2. Compiled the RBServer\Demos\Servers\Main\Report.dpr application and got
    it running with the context of IIS.

    3. Performed a simple test to make sure the applications are up are running
    propertly. To do this I pasted the following into my web browser

    http://127.0.0.1/rbWebPub/report.dll

    4. To request a specific report, I pasted in the following and it worked
    properly.


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


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

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