Complex report

[pradeepmaran]

Hi All,
           I need a perfect example for complex report. It will be better, if you share your experience on the most complex report you came across in  your projects.




Thanks & Regards,
Pradeep

[Lynn]

Why?

[blom0344]

.. on earth..?

[MFGF]

...would you need that?

[pradeepmaran]

It will help others, if such scenario arises....... :)

[blom0344]

help with what?  such scenario?   :o

[MFGF]

Is it for an interview question, maybe? :)

[blom0344]

I'd consider a report truly complex when it takes a good 10 seconds to just open query panel. Say, 80-120 queries all together with local joins , some unions or a combination of both..   ;)
Of course page sets, complex crosstabs and juicy conditional formatting and rendering    ;D

[cognostechie]

I would consider a report to be truly complex if it has the logic of determining what the data in future would be so that it can run by itself instead of having to go to the database to get the data every time. This would resolve all performance issues ;D

[blom0344]

I would consider a report to be truly complex if it has the logic of determining what the data in future would be so that it can run by itself instead of having to go to the database to get the data every time. This would resolve all performance issues ;D

I found your post - before the extensive editing - quite hilarious!!!!!

[cognostechie]

I thought some people may not like it so I edited it. Maybe I shouldn't have  :)

[blom0344]

I'm pretty sure none of the - active - moderators would have been alarmed  :)