Help with passing date parameter in CR 2008 Hyperlink

[paj016c]

I have a report that calls another report using hyperlink in CR 2008. I have been successful with passing all the parameters except the two which happen to be date values. I've read through other posting but the solution seem to all be for jsp; unfortunately for me, my report is an aspx. Can you help with the syntax below...
"

http://server/OpenDocument/opendoc/...s70Rhj.gdK0&sIDType=CUID&sWindow=new&lsSmkt="

& GridRowColumnValue("Command.mkt") & "&lsSrpt_grp=" & GridRowColumnValue("Command.rpt_grp") & "&lsSrpt_mth=" & GridRowColumnValue("Command.rptdt15") & "&lsSgrp_by=" & {Command.grp_by} & "&lsSpaid_date=" & {Command.paid_date}

Below is an example of the hyperlink that was passed....

http://server/OpenDocument/opendoc/...nfoView&service=/OpenDocument/appService.aspx

Again, all the parameter values pass correctly from the parent report to the child report except the two dates (rptdt15 & paid_date)I know it's the format of the dates that is wrong. I just cannot find anywhere how to format correctly.

 

[Turkbear]

Hi,
It might parse better if you pass them as strings:

[URL unfurl="true"]http://server/OpenDocument/opendoc/openDocument.aspx?isApplication=true&iDocID=AWJUeWopZ7tGs70Rhj.gdK0&sIDType=CUID&sWindow=new&lsSmkt=CHATTANOOGA&;lsSrpt_grp=NORTHWEST&lsSrpt_mth=0'06/15/2010[/URL] 12:30 AM"&lsSgrp_by=POD&lsSpaid_date="01/31/2001 12:20 AM"&appKind=InfoView&service=%2fOpenDocument%2fappService.aspx

Then use the DateTime function in your report's selection criteria to convert it to a DateTime.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[paj016c]

Thanks for your prompt response. Although this probably wouldn't work because the dates are fields being passed from parent report, I tried to use it just to see how the child report would look. And I'm still running into the same. No matter what dates I pass (either hard coded dates or dates from parent report) the child report uses November 1999 as the dates. I can see this because I have the parameters displayed in the header of child report. I've attached a copy of reports to help with my explanation.

 

[Turkbear]

Hi,
I avoid mediafire due to the many pop-ups and pop-unders and redirects.

Be sure that the report is configured to accept changed parameter values when called and not set to use the default ones that may be in the value list.



To Paraphrase:"The Help you get is proportional to the Help you give.."