cancel
Showing results for 
Search instead for 
Did you mean: 

URL Reporting Time parameter value.

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Adam_Stone
Active Contributor
0 Kudos

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
0 Kudos

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

Adam_Stone
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

What if you try:


prompt0=Time(1,2,3)

Does it work?

Sincerely,

Ted Ueda