How can I execute custom sql proc in my reports.

rbuser

I dont want to use autosearch parameter.
I am always using sql proc on my reports, my reports are stored in
'root\webreports\' in this case how can I execute my reports as like "exec
[dbo].[getCustomerDetail] (@CusID = '01'".
I dont need report explorer in web browser I just want to execute directly
my report.
Thanks.

nardmoseley

Below are two tech tips. The first discusses how to execute a specified
report on the webtier and the second how to implement custom parameters.

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

-------------------------------------------------------
Tech Tips: RB Server and Custom Parameters
-------------------------------------------------------

The RBServer Custom Parameter demos show how to define custom session and
report level parameters that can be used to implement security and other
types of custom processing.

The are three projects that work together. Each project includes a
ReadMe.doc and commented code.

1. RBServer\Demos\Servers\Custom Parameters
2. RBServer\Demos\WebTier\Custom Parameters
3. RBServer\Demos\Clients\Custom Parameters


The demos include examples of how to...

1. Define Custom Session parameters.

A custom login form is displayed. Based upon the login, the catalog of
reports available to the user is filtered.

2. Define Custom Report parameters

A custom parameter form is displayed. The parameters are used by the report.

3. Custom AutoSearch form

A custom autosearch form is displayed. The parameter values are used by the
autosearch criteria.





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