Hi,
I am facing an issue. I created a Crystal report based on Stored procedure and want to pass the parameter values from Webi.
I am able to pass only one MRN value but not able to pass the Begin and End Date to the Crystal report
Please check the below hyperlink syntax and let me know where its wrong
="<a href="…/…/opendoc/openDocument.jsp?iDocID=AQOIoZentnlIno69rNXJNR8&sIDType=CUID&sType=rpt&sRefresh=Y&lsSMRN="+URLEncode(""+[MRN])+"&lsSFromDate="+URLEncode(""+[v_start_date])+"&lsSToDate="+URLEncode(""+[v_end_date])+"" title="" target="_blank" nav=“doc”>Patient Itinerary Report"
The v_start_date and v_end_date are variables and have the below syntax
v_start_date=FormatDate(ToDate(UserResponse(DataProvider([MRN]);“Enter FromDate:”);“MM/dd/yyyy hh:mm:ss a”);“MM/dd/yyyy”)
v_end_date =FormatDate(ToDate(UserResponse(DataProvider([MRN]);“Enter ToDate:”);“MM/dd/yyyy hh:mm:ss a”);“MM/dd/yyyy”)
s7jyothi (BOB member since 2008-09-07)