| :: more that one user defined parameter.... :: (11) | Post a New Message | Post a Reply |
 more that one user defined parameter.... | Post a Reply |
from: Van BC
i have been able to use one user defined parameter by putting ?VarName into the filters. but when i try to add another one, the report does not show up (ie. blank white screen source:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>
one user defined, and one regular filter works....
thanks for the help.
tane.
 Re: more that one user defined parameter.... | Post a Reply |
from: Washington, DC
Please explain more clearly so we can fix the bug. In the mean time, check out this report
http://www.aspwebsolution.com/products/report_wizard/demos/demo_wiz.asp?rid=DEMO2
It uses two user-defined parameters
-------------------------
Ghost
| Re: more that one user defined parameter.... | Post a Reply |
from: Van BC
i dont understand how that demo has user-defined parameters.
for me, when i put ?VarName into the filters and then try to load the report, it says: required parameter(s): with an input box and submit button. (i assume because it has not found it in the queryString)
the problem is when i try to add another parameter...
| Re: more that one user defined parameter.... | Post a Reply |
from: Washington, DC
You created a report with report id = R1
you added a user defined parameter ?VarName into the filters
when you try to load the report it says:
required parameter(s): with an input box and submit button.
That is correct.
To link to this report from another report, by adding a hyperlink field that references this report (R1). Link one of the fields in your current report to R1 by selecting Insert Hyperlink and adding a link as shown in the format below:
YOUR_FILE_NAME.asp?rid=REPORT_ID&VARIABLE_NAME1={{FEILD_NAME1}}&VARIABLE_NAME2={{FEILD_NAME2}}&closewin=true
for example
e.g. demo_wiz.asp?rid=R1&VarName={{Your Field Name}}&closewin=true
The closewin=true is optional. It only serves to replace the Home url above the report with a Close button.
Also make sure you have installed the latest version 2.1.26
Also check out this report Employees Report (Linked to Employee Detail) it is connected to this report (Employee Detail ) that has user-defined parameters.
For more information on Report Parameters, please check our online tutorial at Adding Report Parameters
Let me know if this helps
-------------------------
Ghost
| Re: more that one user defined parameter.... | Post a Reply |
from: Van BC
i need two (or more) parameters. so that the url might look like:
.....demo.asp?rid=1&StartDate=01/01/04&EndDate=01/31/04
for example a date range: a report for records after this date, but before this other date. this requires two parameters.
i get the 'required parameter' message for when i have only one user-deinfed parameter, but when i try to add another, i get a blank white screen.
thanks for the help here.
tane.
 Re: more that one user defined parameter.... | Post a Reply |
from: Washington, DC
<% Response.Write(objWiz.Version)
%>Also make sure reports look like this:
1. The report that requires the parameters should have filters like this:
SomeField='?Param1'
AnotherField='?Param2' 2. The report that is linked to the report above with the Insert Hyperlink Text format, should have its URL look like this:
demo.asp?rid=1&Param1={{Field1}}&Param2={{Field5}} -------------------------
Ghost
| Re: more that one user defined parameter.... | Post a Reply |
from: Van BC
Response.Write(objWiz.Version)
%>
gives me the error:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'Version'
| Re: more that one user defined parameter.... | Post a Reply |
from: Van BC
im sure this is something stupid. this is exactly what i am doing:
from the 'home' page i click the checkbox of a table containing a field called DateEntered. i choose 'build report'. i select the checkbox next to DateEntered and choose next, and next again.
then under filters i enter:
-DateEntered for the field.
-is greater than for the condition
-?StartDate for the value.
then i choose add filter.
then i add another filter exactly the same, except i change the condition to less than, and the value to ?EndDate
i choose add filter and finish.
i get a blank white screen.
thanks for much for the help.
tane.
| Re: more that one user defined parameter.... | Post a Reply |
from: Washington, DC
Why don't you download a newer version from the link below and install it.
http://www.aspwebsolution.com/products/report_wizard/download.htm
You can also check your file version by right-clicking on the AWSReportWizard2.dll and selecting properties then click on the version info tab.
Let me know if this information helps.
-------------------------
Ghost
| Re: more that one user defined parameter.... | Post a Reply |
from: Van BC
forgot to post....
i think a reinstall of the dll did it.
ghost, thanks for the help.
also, where can i find info on 'Advanced support for HTML printing' as in the features list.
thanks again.
tane.
| Re: more that one user defined parameter.... | Post a Reply |
from: Washington, DC
http://www.aspwebsolution.com/products/report_wizard/t_print.htm
Don't forget to set the number of records you want per page before clicking on the Print link button.
Note that the first page will be empty because we put a page break before the start of your report and after the end of your report
When you click the Print link button, you can preview your page to see what I mean.
-------------------------
Ghost