Stored Proc in Cognos report studio

[Prajam]

HI guys,

i have a requirement of stored proc. in one of the reports having 5 drill thrus which has to update the values
in next drill thru from parent parent

suppose: consider a query item "type code" having A,B,C.
if A in parent report then change to B in child report
vice versa


can any one tell the procedure for this using stor.proc?

thanks in advance

[blom0344]

There is no such thing as a SP within a report. Reports simply show the outcome of queries. You can define an SP within the database an to some extend and use it within a Cognos model. I doubt whether SP's that update data are supported, I never had much use for them.  Are you by any chance a programmer switching to BI?