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

Directly Call a report

edited March 2003 in Server
I'd like to have various links on my web page that directly call a report
rather than via an 'explorer' How would I go about this?

Thanks!
Nick Hustak

Comments

  • edited March 2003
    Specifie volume name and file name like this


    Var Marequete:Trswebrequest
    begin
    marequete:=Rswebtier1.CreateWebRequest(Request.QueryFields,Request.Content);
    Marequete.SessionParameters ['Accountname'].value:='JP';
    Marequete.SessionParameters ['AccountPassword'].value:='ILoveRB';
    Marequete.SessionParameters ['Color'].value:='All';
    Marequete.ContentParameters['Name'].Value := 'myReport';
    Marequete.ContentParameters['Volume'].Value := 'myVolume';
    Response.Content := rsWebTier1.ProcessWebRequest(MaRequete);
    End;


    Nick Hustak a ?crit dans le message :
    3e865a20$1@dm500....
  • edited March 2003
    Hrm.. That's not what I meant - I want to create an anchor on a web page to
    directly call a report. I use ColdFusion for my web site development and
    need to be able to call the reports directly.

    Thanks for the reply!
    Nick

  • edited March 2003

    Below is an article on this subject. Starting with RB 7.02, I think you can
    ommit the "frameset=1" parameter....


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






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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited April 2003
    You rock Nard! I looked in the tech-tips but missed this - sorry!

This discussion has been closed.