I'm running cf 5.0, crystal report 8.5, on win2k
I tried calling the report with cfreport tag but am getting timeout errors,
I also noticed other developers having the same problem on the messsage
boards. So what I'm doing is calling the report via URL.
This is the url that I'm using:
RentAdjustmentReporttest.rpt?sf={cases.caseStatus}+%3d+1&{cases.receivedDate
}+%3d+06/01/2002&promptonrefresh=1
The report name is RentAdjustmentReporttest.rpt and two parameters that I
want to pass thru is cases.caseStatus and cases.receivedDate.
These are the formulas:
{Cases.ReceivedDate} >= {?receivedDate} and
{Cases.CaseStatus} = {?caseStatus}
Whats happening is that the first parameter caseStatus is working but the
receivedDate doesn't seem to go thru. When I view the source this is what I
see:
Dim webSource0
Set webSource0 = CreateObject("WebReportSource.WebReportSource")
webSource0.ReportSource = webBroker
webSource0.URL = "/RentAdjustmentReport.rpt"
webSource0.PromptOnRefresh = True
webSource0.AddParameter "sf", "{cases.casestatus} = 1"
am I passing the parameters in correctly? or is there another way of doing
this?
Please advise,
Thanks
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
