Hyperlink sRefresh set to No but still refreshing

system · December 7, 2009, 3:52pm

Hi,
I searched through the forum, found quite a lot of information on hyperlink syntax, I have one issue I am calling a detailed report from a Master report. Passing parameter values to the detailed reports. Have scheduled both the master and detailed report. Have provided a link back from the detailed report back to Summary Report.

Please refer the syntax:
=If([Resolved Out of SLA]=0 Or IsNull([Resolved Out of SLA]);0;"<a href=…/…/opendoc/openDocument.jsp?&sDocType=wid&iDocID=2581&sReportName=Details&lsMEnter%2FSelect%20SLM%20Service%20Target%28s%29="+URLEncode([var_SR])+"&lsMEnter%2FSelect%20SLM%20Progress="+ URLEncode(“Attached;In Process;Pending;Unknown;Missed;Invalid;Missed Goal;Warning;Available;Unavailable”) +"&sInstance=Last&sWindow=Same&sRefresh=N>"+[Resolved Out of SLA]+"")

The above link always refreshes I have also tried &sRefresh=NO
but no luck

now if I update the above to remover both the &lsM attributes i.e.
=If([Resolved Out of SLA]=0 Or IsNull([Resolved Out of SLA]);0;"<a href=…/…/opendoc/openDocument.jsp?&sDocType=wid&iDocID=2581&sReportName=Details&sInstance=Last&sWindow=Same&sRefresh=N>"+[Resolved Out of SLA]+"")

Then this always navigates to the latest instance faithfully, I think it kind of makes sense i.e. the prompt parameters will be available only when you hit the refresh buttton, so I think there is no way you filter using prompts on the saved instances using hyperlinks…

Any feedback would help me.

Thanks in advance

friend123 (BOB member since 2008-05-30)

system · December 7, 2009, 10:24pm

G’day,

Yes you’re right, you can’t prompt on a report, but not refresh. So if you’re feeding prompt values, you’ll be refreshing the linked report.

Cheers!

mjyoungman (BOB member since 2006-10-06)

system · December 8, 2009, 9:03am

Many Thanks for re confirming it gives me more confidence

friend123 (BOB member since 2008-05-30)

system · December 8, 2009, 10:55pm

Hi,

I support mjyoungman. However, in my scenario the detailed report opens with the prompt window whre I have to click on Refresh button. I do not want the prompt window to come up. Instead I would like the child report to refresh automatically with the parameters that I am passing from the opendoc syntax. Does anybody know how to achieve this?

Thanks guys

arun9911 (BOB member since 2008-01-16)

system · December 8, 2009, 10:58pm

Yes, this is possible, what syntax are you using at the moment. One thing I remember causing this was having the open doc call passing one value, but having the Prompt in the target report with an ‘in list’. You need to make sure if the Open Doc call is sending a single value (eg Customer Number) then you’re prompted report has an ‘equal to’ condition for the prompt…

Give me some more details and I may be able to assist with the open doc syntax.

mjyoungman (BOB member since 2006-10-06)

system · December 8, 2009, 11:07pm

I agree on the single value vs. list issue. Also, the exact prompt value is required as well.

maverick976 (BOB member since 2004-07-06)

system · December 9, 2009, 12:08am

Hello mjyoungman,

Thanks for replying to this post mjyoungman and maverick976.

For the below syntax 1 i do not get the prompt box and the child report refreshes with the parameters that are being passes with the opendoc syntax

syntax 1:

="<a href=“http://acebo-dev.ssdc.kp.org:8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocName=Contribution-Report-Variable-Cost-Components-Group&sPath=[Public+Folders],[ADSS],[CO],[Profit+and+Loss±+Contribution+Margin+Report]&iDocID=470589&sType=wid&sWindow=New&sType=wid&sWindow=New&lsS”+URLEncode(“Select Service Class or % for All to Re Calculate”)+"="+[Detail]+"&lsS"+URLEncode(“Enter Period Post (Start):”)+"="+URLEncode(UserResponse(“Enter Period Post (Start):”))+"&lsS"+URLEncode(“Enter Period Post (End):”)+"="+URLEncode(UserResponse(“Enter Period Post (End):”))+"&lsM"+URLEncode(“Enter value for Market or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for Market or % for all: “))+”&lsM”+URLEncode(“Enter value for Network or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for Network or % for all: “))+”&lsM”+URLEncode(“Enter value for Group or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for Group or % for all: “))+”&lsS”+URLEncode(“Please input percentage(0-100) of Labor costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Labor costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Mid Level Provider-Other costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Mid Level Provider-Other costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Physician costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Physician costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Mid-Level Provider Medical Group costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Mid-Level Provider Medical Group costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Supply costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Supply costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Equipment Depreciation costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Equipment Depreciation costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of IT costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of IT costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Facilities costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Facilities costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Other costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Other costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Depreciation costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Depreciation costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Regional Admin costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Regional Admin costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Local Admin costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Local Admin costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Malpractice costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Malpractice costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of PMG Overhead costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of PMG Overhead costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Non-Util costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Non-Util costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Claims costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Claims costs”))+"">"+ [Detail]+""

For syntax2 it pops up with the refresh prompt window. Weird…

syntax2:

="<a href=“http://acebo-dev.ssdc.kp.org:8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocName= Contribution-Report-Variable-Cost-Components-Market-01&sPath=[Public+Folders],[ADSS],[CO],[Profit+and+Loss±+Contribution+Margin+Report]&iDocID=468901&sType=wid&sWindow=New&sType=wid&sWindow=New&lsS”+URLEncode(“Select Service Class or % for All to Re Calculate”)+"="+[Detail]+"&lsS"+URLEncode(“Enter Period Post (Start):”)+"="+URLEncode(UserResponse(“Enter Period Post (Start):”))+"&lsS"+URLEncode(“Enter Period Post (End):”)+"="+URLEncode(UserResponse(“Enter Period Post (End):”))+"&lsM"+URLEncode(“Enter value for Market or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for Market or % for all: “))+”&lsM”+URLEncode(“Enter value for Network or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for Network or % for all: “))+”&lsM”+URLEncode(“Enter value for Product Line or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for Product Line or % for all: “))+”&lsM”+URLEncode(“Enter value for LOB or % for all: “)+”=”+URLEncode(UserResponse(“Enter value for LOB or % for all: “))+”&lsS”+URLEncode(“Please input percentage(0-100) of Labor costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Labor costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Mid Level Provider-Other costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Mid Level Provider-Other costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Physician costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Physician costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Mid-Level Provider Medical Group costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Mid-Level Provider Medical Group costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Supply costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Supply costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Equipment Depreciation costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Equipment Depreciation costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of IT costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of IT costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Facilities costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Facilities costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Other costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Other costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Depreciation costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Depreciation costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Regional Admin costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Regional Admin costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Local Admin costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Local Admin costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Malpractice costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Malpractice costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of PMG Overhead costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of PMG Overhead costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Non-Util costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Non-Util costs”))+"&lsS"+URLEncode(“Please input percentage(0-100) of Claims costs”)+"="+URLEncode(UserResponse(“Please input percentage(0-100) of Claims costs”))+"">"+ [Detail]+""

Thanks guys…

arun9911 (BOB member since 2008-01-16)