AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: Parameters Yet? :: (4)

Feb 18 2004, 2:58 PM

Parameters Yet?

karena

since: Jan 16, 2004
from: somewhere Hello! Does v2 have the ability to receive parameters into reports?

Thanks.

Feb 19 2004, 5:12 PM

Re: Parameters Yet?

Post a Reply

whichman

from: Laurel, MD

Sorry for the late reply Karena... I have been working hard trying to fix an installer problem which a lot of people seem to have.

Yes you can add parameters to your reports.
There are 2 kinds of parameters:

system parameters and user-defined parameters. You add these parameters at the filter screen of the dialog wizard.

System Parameters (screen_shot)
The system parameters are basically some popular information which the report wizard can get from the system. The report wizard will then replace these values as shown below:

@DATETIME: - the current date & time
@DATE: - the current date
@TIME: - the current time
@YEAR: - current year
@MONTH: - the current month
@DAY: - the current day
@USERNAME: - the value in Session("UserName")
@USERID: - the value in Session("UserID")

As time goes on we will add more system parameters.

User-Defined Parameters (screen_shot)
User-Defined parameters are parameters that the current user will be asked for when they try to view the report.
The report wizard first looks for the paramter's value in the URL query string. If it does not find it, it will then ask a the current user only once for the value.

For example:
Consider that your reports are located at the following web address:
http://mycompany.com/reports/default.asp

If you have a report with report id = ORDER
If this report has a user defined parameter called ?ORDERID

You can make a direct link to this report as follows:
http://mycompany.com/reports/default.asp?rid=ORDER&ORDERID=10528

to view the order details for Order 10528

-------------------------
Master of the Game

May 12 2004, 3:02 PM

Re: Parameters Yet?

Post a Reply

Yimei

from: Myrtle Creek, OR When I use @USERID in my filter, I get no records returned!. But if I change the filter to be a constant 21 (userid is equal to 21), it shows the records that I can access to.
I know my Session("UserID") is indeed 21 by response.write to my asp page. What did I do wrong?

May 13 2004, 11:01 AM

Re: Parameters Yet? - Fixed

Post a Reply

ghost

from: Washington, DC Bug-Fixed
This bug has been fixed as of version 2.1.28
You can view a live example by checking out the following link below:

http://aspwebsolution.com/products/report_wizard/demos/forum_posts.asp

The reports are filtered based on your session UserID on this site.

-------------------------
Ghost

Pages: (1) [1]