How to create reports in RS by using crystal report SQL code

[ra]

Hi Cognos Gurus,

We need to create reports in RS by using Crystal SQL code, we have  the SQL code for all the  crystal reports.

we have to develop cognos reports based on the crystal reports SQL code so can any one please help me on this how to do and how to use SQL code in cognos, we are revers engineering in cognos.

I will provide full detail about crystal reports SQL if any one can help on this.

Thanks in advance for your help.

Thanks,
Rams

[bdbits]

Please do not do this. The correct answer is to examine the database, reports, and SQL to design a proper Framework Manager model.

If this is a one-time, temporary situation, it might be excusable. Otherwise, using raw SQL like this completely defeats the reasons for using Cognos. Long-term, such a shoddy implementation will make people think Cognos is a lousy tool, when in fact it is very good when used as intended.

[cognostechie]

Just to expand on the answer given by bdbits -

You will have to interpret the SQL coming from Crystal to identify the tables and relationships . Draw a diagram on the paper with the relationships. Look at the 2nd SQL and add the tables and relationships into the same diagram. Go on doing this until the last SQL. Now you have something which you can use to create a Framework model. Publish a package  if your Crystal reports are only relational otherwise create cubes using Cube Designer, transformer etc. Use these to make reports in RS.

There is a short cut way too which you can use to avoid all of what is written above and that way will let you put the SQL straight into RS but for that we usually charge
USD 48776363.868696060 Million as that much is required to convert insanity into sanity after giving you that suggestion..

[bdbits]

There is a short cut way too which you can use to avoid all of what is written above and that way will let you put the SQL straight into RS but for that we usually charge
USD 48776363.868696060 Million as that much is required to convert insanity into sanity after giving you that suggestion..

HAHAHA! I literally laughed out loud. My co-workers probably think I am insane, or perhaps I merely confirmed it.  ;D

I probably came across as a grouchy old man (which I can be says my wife). Thanks for explaining it better, cognostechie.