?
Solved

multi-select for stored procs in cognos8

Posted on 2008-10-31
4
Medium Priority
?
1,306 Views
Last Modified: 2013-12-07
A stored procedure with input parameters linked to prompts has been succesfully created in Framework Manager and Report Studio.
In Report Studio however I'd like to use for some prompts a multi-select option.
I have changed the preference of the prompt to multi-select but it is not possible to select more than 1 in the LOV.
Is this possible or is the delimiter default ; (semicolon) and causing a problem in the stored procedure? The IN list should use , (comma).
Is there a workaround?
0
Comment
Question by:fiersken
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 

Author Comment

by:fiersken
ID: 22865094
This is very important for me to be able to use the Stored Procedures in cognos 8, reportstudio, so I'd appreciate the attention to this issue.
0
 
LVL 12

Accepted Solution

by:
RWrigley earned 1125 total points
ID: 22869054
Product limitation...Cognos can only pass single values to a stored procedure.  However, there are some workarounds.  Check the following KB for an example:

http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=140460
0
 

Author Comment

by:fiersken
ID: 22884441
Thanks for the link to the KB, this solution for cognos v8.3 works. I tried it with 1 multi-select prompt and the InList is sent back.
Additional questions:
1/ the code uses now node.getAttribute('type') == 'checkbox'. How to change the java script for a List Box?
2/ My report has many input parameters that need to have the multi-select. How to change the java script in the html item to embed many variables? Can I use only one function assignParamValue() where many var prompt1, var prompt2,... are being declared and called?


Multi-select-and-stored-procedur.doc
0
 

Author Closing Comment

by:fiersken
ID: 31512094
Links to the KB are useful, but I still need to contact someone to open them as I don't have any account on the cognos DB. Is it possible to add a file in the future?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question