Onion - the missing ingredient for Sage Line 50 / Sage Instant accounts packs in Excel

Onion - the missing ingredient for Sage Line 50 / Sage Instant accounts packs in Excel
Full audit trails to underlying transactions from P&Ls, Balance Sheets, graphs, PivotTables, and departmental TBs in a stand-alone Excel file. Aged Debtors and Aged Creditor files too. Free 30 day trials. Download today at www.onionrs.co.uk

Friday 1 October 2010

Passing prompt parameter displayValue in URL to Cognos

I'd been used to passing prompt parameter values for Cognos reports in a URL by just simply using &p_<parameter_name>=<value>.

However, I came across a report where both the useValue and displayValue of the parameter were involved in the final output and I discovered that using &p_<parameter_name>=<value> seems to result in <value> being used as both the useValue and displayValue.  This was no good as the report required the two different values as set up on the prompt page in the report.

After endless searching and guesswork I eventually stumbled across how to send the two values separately in a URL:

&p_<parameter_name>=<selectChoices><selectOption useValue="<useValue>" displayValue="<displayValue>"/></selectChoices>

No comments:

Post a Comment