we have a 7series report .imr and we are trying to upgrade on c8.
what we have done is-save .imr to .iqd and open on notepad then copy the sql on c8 report
studio.....
but issues are=
there are multiple prompt defined in iqd, and we are not able to solve those prompt issues
in c8
any ideas/suggestion
thankx in advance
Really, do not go down the SQL road :-\
Build your C8 model and base your reports on the model. This will generate the SQL for you underneath. The prompt issues will resolve itself by using the excellent C8 prompt possibilities.
Did you even look into the framework manager to build your model?
we thought so.....but this particular report we hardly used, so our PM
wants us do this way
please advice if you can
thank you so much
This approach is probably not going to work. The architectures of Impromptu and Cognos 8 are radically different.
As Blom suggests, create a new Framework Manager package for the relevant data source, then rebuild the report from scratch using Report Studio.
MF.
thank you MGMF, Bloom
I understand your advice, BUT
for this particular report,i need to write/copy sql from series-7 .
It would be great ig you could provide some hints/solution...!!!
thank you so much in advance