Help me to Find Learning Resources for Advanced SSRS based Reports(subreports, aggregates etc) using FetchXML

(0) Share

Report

Posted on by JahangirDanish

650

Can anybody help me to find resources (tutorial, blogs, books etc ) for generating Advanced reports such as sub-reports, aggregates(all types of aggregates) using FetchXML. I have some googling but not find any helpful resources.

And how can I used Advanced find to make FetchXML based query of these aggregates functions.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Community Member on at

Like (0)

Report

garethtuckercrm.com/.../fetch-xml-reports-for-crm-2011-online

This one helped me in the beginning to start off with SSRS reports

Was this reply helpful? Yes No
JahangirDanish 650 on at

Like (0)

Report

Thanks Sameera Salih, I will check it.

Was this reply helpful? Yes No
Verified answer

Rugved Gokhale on at

Like (1)

Report
check this out. Parent page for all the reports related basics & advanced level techniques. These links should help you with both SSRS as well as FetchXML based reports.

http://technet.microsoft.com/en-us/library/dn531183(v=crm.6).aspx

http://blogs.msdn.com/b/crm/archive/2011/03/18/parameterizing-fetch-based-reports.aspx

Was this reply helpful? Yes No
JahangirDanish 650 on at

Like (0)

Report

Thanks Rugved Gokhale. I will check them.

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (1)

Report

Hi Jahangir,

The advanced find XML will not return the aggregate, you should modify to show the aggregate:

dynamicsofdynamicscrm.wordpress.com/.../aggregate-fetchxml-queries-for-dynamics-crm-20112013

But, basically, create the reports, you just generate the raw data, then you use the SSRS expression : Sum, Count, etc based on that raw data.

So, in your data you will have 5 records

Opp Amount

Opp1 1000

Opp2 500

Opp 3 1500

Then from that row data, you just using the grouping in SSRS

technet.microsoft.com/.../bb630415(v=sql.100).aspx

This is what I usually do, don't use adv find to get the sum total, but use SSRS feature to find the aggregate total.

Thanks.

Was this reply helpful? Yes No
JahangirDanish 650 on at

Like (1)

Report

Thanks Aileen Gusni. Ok got it.

Was this reply helpful? Yes No