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.
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.
You can grab the input from a text box type prompt and pass it to a SP.
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
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.
Quote from: zammi on 09 Apr 2008 11:46:26 PM
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>'
Hi,
You can see this article.
http://www.inergex.com/blogs/business-intelligence/2011/04/21/write-back-your-database-cognos-bi
well do u need to write complete dataset or just what ever user selects or enter in the prompts