Fetch the query in the report

Dear Friends,

Do we get any technical or functional information regarding the system
generated reports.

I've one more doubt in MS CRM 3.0, when we create account and
Opportunity entities in the system, it automatically creates the
reports like Account Distribution and Account Overview, actually I
want that which query is getting executed in the report. If anyone
have acheive this please help me if possible.

With Regards,
Jeetu T.

Amol
Wed Jul 23 02:29:34 CDT 2008

Hi Jeetu,

These are predefined reports shipped with MS CRM 3.0. You would get
more information in MOC or you can Google for it.

Answer to your question, these report uses store procedure to get the
data out of CRM. Inside store proc these use filtered view to
implement security in reports.

If you want to know which store proc is running for which report, try
using SQL profiler.

Thanks,
Amol Gholap.
(www.amolgholap.blogspot.com)

Dodd
Wed Jul 23 08:41:55 CDT 2008

The Report Queries for Account Distribution and Account Overview are
fairly complex, in that they utilize multiple datasets using multiple
parameter based Dynamic SQL queries within the Report itself, and, as
Amol mentioned, Stored Procs in the [Organization]_MSCRM db.

I have done several customizations to these reports and they can be
somewhat time consuming to reverse engineer for other purposes. This
is mainly due to the extensive use of parameters within these stored
procs that are driven by the Dynamic SQL code on the report.

That being said, I can give you what I have in my personal files (the
Report SQL, Stored Procs, etc), just email me at my G-Mail account,
which should be visible on my profile

--MD