Skip to content

Posts from the ‘Reporting’ Category

19
Apr

CRM 2011: Bad ‘setFormMode’ error!

The other day, I was puzzled by a weird problem coming from a “Go to URL” action in a CRM sub-report.

Read moreRead more

29
Mar

BI: TARGIT Certified Specialist

Congratulations to my colleague Mathieu and I as we have successfully passed the TCS exam and are now proud to announce that we can deliver TARGIT trainings in French to customers in Belgium (French part) and Luxemburg!

Sourire

targit logo 175-14-35-SPECIALIST

18
Jul

How-to: Use SQL CTE with custom reports in CRM

One of my client asked me the other day to produce a report containing all the cases (incidents) in the system… OK, this is pretty easy and it already exists somewhere Sourire

But the hardest part was the filtering of this report: he wanted to be able to put a parent subject in the filter and the report should take care of getting all the child under this subject!

Read moreRead more

10
Feb

How-to series: Create a custom report (part 5)

So, after a long time, I’ve decided to end my how-to series by explaining how to embed a subreport in a custom report.

If you don’t already know how to create a custom report, I’ll suggest that you follow my previous posts on this same blog for more info: part 1, part 2, part 3 and part 4.

So the purpose of this last post of the series is to explain how-to embed a subreport in a parent report and how-to pass parameters to this subreport (for example: pass the account ID from the parent report to the subreport).

Read moreRead more

5
Jul

How-to series: Create a custom report (part 4)

In this article, I deal with the reporting drill-through and with the report pre-filtering to display the list of elements that are currently in queues.

Read moreRead more

29
Jun

How-to series: Create a custom report (part 3)

Okay now, I’ve already dealt with the basics of custom report creation (see Part 1 & Part 2 on this blog) so now I’m going to show you how to create a report from scratch for displaying the service activities in an other way.

Read moreRead more

12
May

How-to series: Create a custom report (part 2)

This is the second part of this “how-to” series regarding the creation of a custom report in Microsoft CRM 4.0. For those who want to read the first part, you can go here: How-to series: Create a custom report (part 1)

Well, in the first post, we looked at how to create a new report using the “Report Wizard” provided by Microsoft CRM and, honestly, this report looked awful! :-)

In this part, I will show you the internal stuff behind the scene and how you can add your own TSQL query to return the data you really want to see.

Read moreRead more

10
May

How-to series: Create a custom report (part 1)

This is the first part of my “how-to” series covering the creation of a custom report for Microsoft CRM 4.0.

Read moreRead more