Write data to a temporary table

[zammi]

I'm looking for a way to write some data from a report to a Oracle database. Basically some parameter values and a comments written by user to a temp table upon a button press. Your feedback is appreciated.

[almeids]

AFAIK the only way to implement inserts/updates is via a stored procedure in the database, but I couldn't tell you how.  You need to include the procedure in FM and then I guess you pass the values you want stored to it via Javascript associated with your button.  Sorry I can't be more specific.

[Suraj]

You can grab the input from a text box type prompt and pass it to a SP.

[tmacfarlane]

I came across this example after searching google.  It looks as if SPROCs are the way to go.

http://bicentre.blogspot.com/2007/09/cognos-8-report-studio-comments-box.html

[zammi]

Thanks for your comments everyone. I went through the http://bicentre.blogspot.com/2007/09/cognos-8-report-studio-comments-box.html and it's great if we can pass some parameters from the report into the asp fille. Any idea if it is possible in report studio 8.3.

[zammi]

I'm looking for a way to write some data from a report to a Oracle database. Basically some parameter values and a comments written by user to a temp table upon a button press. Your feedback is appreciated.

This worked for me :-)
1. HTML Source type: Report Expression

2. Expression : Example: '<a href="http://localhost/cognos8/samples/intComments/addComments.asp?'; +   [Query1].[Metric Identification Code]  +' "> Add Comments </a>'

[imnini]

Hi,

You can see this article.

http://www.inergex.com/blogs/business-intelligence/2011/04/21/write-back-your-database-cognos-bi

[Arpitagrawal9]

well do u need to write complete dataset or just what ever user selects or enter in the prompts