Cross Tab Drilling using OpenDoc

[bideveloper82]

Hi,
My cross Tab is like this. 1,2,3 are the periods.
My requirement is to be able to drill down on the measure(Period Count) in the body, and it must take me to a target report. Which means that, I should be able to pass the corresponding start_date, End_Date and the period to my target report. I've created prompts for these 3 parameters in my target report.

Start Date End Date 1 2 3
1/1/2010 1/31/2010 123 245 345
2/1/2010 2/28/2010 234 238 290
3/1/2010 3/31/2010 129 278 345

My BO version is XIR2. I'm having no luck with the Open Doc function syntax.
Below is the link.
="<a href=\"

http://laxyby89:8080/businessobject...ayout1&sWindow=Same&sType=wid&lsSStartDate="+

[Start Date]+"&lsSEndDate="+[End Date]+"&lsSPeriod="+[Period]+" > "+[Period Count]+"</a>"

Any help is greatly appreciated.

Thanks.

 

[skrandel]

What error are you getting?

It looks like your prompt text is not the same. 'Start Date" is not the same as "StartDate".

Try doing this first with single word prompt text. If the multi-word is important try substituting %20 for the space.

Steve Krandel
Intuit