CRM dynamics 4.0 Lead reports

Hi All,

I have been asked to extract CRM lead data out of our CRM dynamics (4.0). In particular and for example we are wanting to know the leads that were opened in October and out of those opened leads how many were converted to an opportunity,how many are still open and how many are closed...

Is this or a report similar to this achievable and if so how do I go about pulling this data from our CRM?

Thanks in advanced.
A.
Adma1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Feridun KadirConnect With a Mentor Principal ConsultantCommented:
I think you will need an SSRS report if you want all this information in one report.  

You can use two separate Advanced Finds, one to return the Leads opened within specific date ranges and one to return Leads within specific data ranges that have related opportunities. But Advanced Find doesn't show totals.

Another idea might be work depending on whether you are happy to work off a lead status of qualified rather than looking for leads with opportunities. If so, the you can create a chart that shows, perhaps, a pie chart of leads by status.
0
 
NetminderCommented:
Adma1,

I changed the Topic Areas for this question from

--Microsoft Dynamics

to
--Microsoft Dynamics
--Databases Miscellaneous
--SQL Reporting

Netminder
Senior Admin
http://www.experts-exchange.com/R_25282.html
0
 
Adma1Author Commented:
Hi All,

I'm still in need of assistance here to get this report sorted.

Any assistance anyone can offer would be greatly appreciated.
0
All Courses

From novice to tech pro — start learning today.