Question Status

Verified
Jeeva Ganeshan asked a question on 11 Mar 2015 2:27 AM

#MSCRM2015 ONLINE

customer want to view chart report in dashboard.

The requirement will not acheieve through direct chart option in CRM so I have done through SSRS

Reply
Verified Answer
Mithilesh Kumar responded on 11 Mar 2015 2:34 AM

Hi Jeeva,

You cannot show Reports in Dashboards, only Charts are possible.

However, you can create SSRS Reports using FetchXML but you won't be able to show them in the Dashboards.

Hope that helps

Thanks

Reply
Jeeva Ganeshan responded on 11 Mar 2015 2:40 AM

Thanks for ur reply Mithilesh,

yes,directly we can't show reports in dashboard.

but we can show reports in Dashboard by using Iframes,it is working.

but the problem, I want to create chart report in SSRS for CRM Online.is there any option to do..?

Reply
Verified Answer
Mithilesh Kumar responded on 11 Mar 2015 2:55 AM

Hi Jeeva,

Yes, you can create SSRS Reports in CRM Online using FetchXML.

For that you need to have following installed.

1. SSDT (SQL Server Data Tools) Installed

2. Report Authoring Extension installed for your CRM Version.

www.microsoft.com/.../details.aspx

You can follow this fantastic tutorial for reference

www.youtube.com/watch

Hope that helps

Thanks

Reply
Suggested Answer
Mahendar Pal MVP responded on 11 Mar 2015 2:59 AM

You can only develop a FetchXML report for CRM Online. So you can develop a fetchxml report and use chart in that report, Once it is upload to MS CRM you should be able to show that report over iframe.

refer: technet.microsoft.com/.../dn531151.aspx;MSPPError=-2147217396


Need help in CRM Contact US | Our Blog | Follow US | Like our Facebook Page | Our Book

Make sure to Vote as Helpful and  Mark As Answer ,if you get answer of your question.

Reply
Verified Answer
Mithilesh Kumar responded on 11 Mar 2015 2:34 AM

Hi Jeeva,

You cannot show Reports in Dashboards, only Charts are possible.

However, you can create SSRS Reports using FetchXML but you won't be able to show them in the Dashboards.

Hope that helps

Thanks

Reply
Verified Answer
Mithilesh Kumar responded on 11 Mar 2015 2:55 AM

Hi Jeeva,

Yes, you can create SSRS Reports in CRM Online using FetchXML.

For that you need to have following installed.

1. SSDT (SQL Server Data Tools) Installed

2. Report Authoring Extension installed for your CRM Version.

www.microsoft.com/.../details.aspx

You can follow this fantastic tutorial for reference

www.youtube.com/watch

Hope that helps

Thanks

Reply
Suggested Answer
Mahendar Pal MVP responded on 11 Mar 2015 2:59 AM

You can only develop a FetchXML report for CRM Online. So you can develop a fetchxml report and use chart in that report, Once it is upload to MS CRM you should be able to show that report over iframe.

refer: technet.microsoft.com/.../dn531151.aspx;MSPPError=-2147217396


Need help in CRM Contact US | Our Blog | Follow US | Like our Facebook Page | Our Book

Make sure to Vote as Helpful and  Mark As Answer ,if you get answer of your question.

Reply