Passing Multiple Selection Criteria In A Web Report

[jessedh]

I haven't been able to figure out how to do this yet...

I have a web report where I can sucessfully pass closed.rpt?sf={CLOSING_QUERY.LoanOfficer}+%3d+'AdamDejak'

I would like to pass two more critera, basically to mimic a date range. I tried

closed.rpt?sf={CLOSING_QUERY.LoanOfficer}+%3d+'AdamDejak'&{CLOSING_QUERY.Closed}<'1/1/2005'

with no luck (I honestly didn't thinkit would work). Is this feasible? Do I have to add parameters to the query and if so, will this then prompt the web user?

Thanks!

 

[pgtek]

hi
create a parameter for the date
if you used asp page the result will be pass to the report

cheers

pg

pgtek

 

[jessedh]

What do you mean?

I was just pulling the report directly for the url string.

Do you have a sample of an asp page that would call a report with parameters?

I currently have it pulling data from an Access Query. Do I have to change this over to Crystal SQL?

Thanks for your help!!

Jesse