converting to Stored Procedure based report

[samthaly]

1. I have a report in place which is based on catalog folder (which in turn represents a database table).

2. Now the requirement is such that this table will be storing data based on paramaeters accepted from user.

3. This data can be inserted in the table by a stored procedure. Stored procedure will accept the prompt values as it parameters.

4. pls suggest, how to implement this... may be using macros ? I dont want a new procedure template based report as I already have catalog based report with various totals and specific format.

 

[Starg]

What we do with stored procedures is create an IMR that contains the prompts for the stored procedure, and then base another IMR on this Source IMR so that we can apply extra filtering, calculations etc...

Just a suggestion ;-)

 

[griffindm]

samthaly,

Does the table you would be populating have the same structure as your existing table? If so, you may be able to create a table with the same name under another schema id name, populate the table via an ODBC macro call to the stored procedure, and easily migrate the existing report by just changing the schema owner name in a copy of the existing catalog.

If the table will have a substantially different structure, the report will have to be rewritten anyway, as either a stored procedure report, or as a normal report based on the new table and structure.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com