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

Reports With Delphi.NET

edited September 2007 in Server
Hello Friends,

This is mallik. I am using rbServer7 for developing reports with
Delphi.net project.

These are parts I am using in development.

1. WebTier (through ISAPI)
2. Report Server

In report server I am placing the units which contains report template,
pipeline, query components for accessing data from database etc.

The WebTier will generate the Dll, this DLL i am calling from my asp.net
web application.

My Problem is, I need the data for the parameters of query in report
server. I want to pass that data from my application web page.

Actually I am executing the query in BeforePrint event of Report Template.

Any one tell me how to pass the data from my asp.net wep application to
report server.

Please help me.



Thanks&Regards,
Mallik.



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • edited September 2007

    - for an example of handling parameters, check out
    RBServer\Demos\WebTier\Custom Parameters. The example contains a ReadMe.doc
    and commented code. The example shows how to use the WebTier to request the
    parameters from the server.

    - for an example of using ASP.NET to call the WebTier, download this demo

    www.digital-metaphors.com/tips/AspDotNetWebTier.zip

    As the ASP.NET example shows, rather than an ISAPI WebTier, you build a COM
    WebTier that can be called from ASP.NET.

    ASP.NET --> COM WebTier---> Report Server



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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited September 2007
    Thanks for your reply.

    Can you please give me one example with ISAPI?

    I need webtier, reportserver and asp.net application in that example.

    Please help me.


    Thanks&Regards,
    Mallik.




    --- posted by geoForum on http://delphi.newswhat.com
  • edited September 2007

    If you want to have the WebTier in an ISAPI application and the ASP app be
    separate, then you can pass parameters in the URL. See the following..

    ---------------------------------------------
    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
    www.digital-metaphors.com

    Best regards,

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