URL Reporting Time parameter value.

[Former Member]

We have installed Business objects XIR2 and one of our application uses URL reporting to call a crystal report. Parameter values are retrieved from the database and used in the url. Reports that do not have a time parameter works fine. Even though I pass the time parameter value Im still prompted for the value. The format of the url I use is http://hostname/businessobjects/viewrpt.cwr?init=dhtml&apstoken=<token>&prompt0=02:02:20&prompt1=LOC...

where prompt0 is of type par_time. Could someone please help me with the correct format to use for parameter type time?

[Former Member]

No. We havent applied any service packs or patches to the Enterprise.

[Adam_Stone]

I would highly recommend updating your environment to the latest service pack (SP4) as many URL reporting issues have been resolved since RTM.

[Former Member]

Ted, Its Business Objects Enterprise 11 Release 2(BOE11.5).

[Adam_Stone]

We understand what product you are using, what Ted is asking for is your patch level. Have you applied any service packs or fix packs onto your Enterprise environment. Ted has mentioned that he tested this, he wants to verify that you are on the same patch level as he tested with as this may have been fixed at some point.

[Former Member]

Ted, I checked the prompt order and the prompt type and they are correct. These reports are working fine on Crystal 9. Also reports that do not have a time parameter works fine in Crystal 11. Its only when reports with time parameter are called Im prompted for a value to be entered in hh:mm:ss format although I tried passing the value in hh:mm:ss format and Time(hh, mm, ss) format in the url. The report comes up fine after entering the value in hh:mm:ss value in the prompt. I tried encoding the url but it didnt work. If I encode the entire url Crystal prompts me to enter values for all parameters.

[ted_ueda]

Hello Senthil,

In case it wasn't clear - I've tested this on my deployment of XI Release 2.

Which Service Pack or FixPack is your deployment on?

Sincerely,

Ted Ueda

[Former Member]

Thanks for replying Ted. I tried Time(06,39,29) but it did not work. Im still prompted to enter the time in hh:mm:ss format.

[ted_ueda]

Then I would check the prompt order and prompt type, since for viewrpt.cwr:

Time values are passed as Time(hours, minutes, seconds)

Date values are passed as Date(year, month, date)

DateTime values are passed as DateTime(year, month, date, hours, minutes, seconds)

Sincerely,

Ted Ueda

[ted_ueda]

What if you try:

prompt0=Time(1,2,3)

Does it work?

Sincerely,

Ted Ueda