Hi,
I have done a report which has user comment/feedback area.these comment are stored to the database.I have to pages, on both pages there is user comment area. on the first page it works fine.on the second page when he press the finish button its goes to the first page again.this ok with 2 pages.but this report gonna have 25 pages.ooopppsss.can anyone guide.how i can stop going back to the first page.
Regards....
Hi would love to know how you did this, great idea!
You have to use Stored procedures.
You trick cognos into running a stored procedure when you click on a prompt button and it runs a stored procedure.You need to setup the SP in Framework manager.
We got this working to some success, but basically canned the idea as officially writing to the DB from a reporting tool was a political hot potatoe..
Good luck..