Reports With Delphi.NET

rbuser

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

nardmoseley

- 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

rbuser

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

nardmoseley

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