Solved

How to create a CRM 3.0 Quote Report

Posted on 2009-04-10
9
625 Views
Last Modified: 2012-08-13
Morning all,

Ok, for some reason, I've been given the uneviable task to implement Microsoft CRM 3.0 which I have now done.  

Everything works fine, and I think I understand everything about work flow etc.

BUT

I cannot for the life of me work out how to implement a new quote template.

ideally, we use the Report option and I've got the one from the Microsoft Sandbox site and uploaded that quite happily but it doesn't display the way I want it to, so I want to customise it

So, my questions to the world are

1) What is the industry standard method of using quotes - is it with a Word Mail Merge or a Quote report ?

2) How on earth do I go about creating a quote template ?  I've googled but can't find any good (well, any actually) tutorials on how to create a quote report.  I'm the proud owner of CRM 3.0 for Dummies (good read) but it doesn't tell you how to create a customised Quote report

I'm tearing my hair out, so max points :-)

Cheers
Si
0
Comment
Question by:legalsrl
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 11

Accepted Solution

by:
rakeshAgarwal earned 200 total points
ID: 24114545
I will answer you second question so half points  :)


1. You can customised the reports using Sql reporting services.

You have to learn sql reporting services to do this.  :(


Regards
Rakesh Agarwal
Spell check for crm 3.0 on email activity release d
0
 
LVL 16

Author Comment

by:legalsrl
ID: 24114595
Cheers Rakesh

I don't suppose there's an easy way to do this  then :-( ?

Can you point me to any tutorials or suchlike ?

Cheers
Si
0
 
LVL 9

Assisted Solution

by:VikramMullick
VikramMullick earned 100 total points
ID: 24114693
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 16

Author Comment

by:legalsrl
ID: 24114892
OK,
I've had a look and it seems more than an Easter Weekend project :-(

Are there any resources where I can just buy a premade quote template ?

Thanks
Simon
0
 
LVL 10

Assisted Solution

by:crm_info
crm_info earned 200 total points
ID: 24115109
Here are a few items for thought:
(1) What's the standard? There really isn't one - some prefer Word merges, others prefer to do an SRS report. Displaying line items in a mail merge is a bit tricky (i.e. Quote Products), so my preference is an SRS report.
(2) CRM 4.0 has some slightly improved reporting capabilities vs. CRM 3.0 - plus a number of other improvements. You should really consider updating (esp if your software assurance is still up to date b/c the new licenses are free!). Info on 4.0 can be downloaded from this page: http://www.customer-connect.com/Home/Library/Documents/tabid/1200/Default.aspx (you'll have to register to be able to retrieve the download). You can also learn a bit more about 4.0 here: http://www.askcrm.com/Home/tabid/866/EntryID/48/Default.aspx
(3) Okay, so how do you build reports for MS CRM? Some of the other books on the market have instructions - but I originally learned by following some fairly simple instructions available in the SDK (SDK = Software Development Kit ... it's really just a set of free documentation from Microsoft that defines how to get some of the deeper customizations done with Microsoft CRM). You can download the SDK for free or access it via MSDN. Download it here:
* SDK 3.0: http://www.microsoft.com/downloads/details.aspx?FamilyID=9C178B68-3A06-4898-BC83-BD14B74308C5&displaylang=en
* SDK 4.0: http://www.microsoft.com/downloads/details.aspx?FamilyID=82E632A7-FAF9-41E0-8EC1-A2662AAE9DFB&displaylang=en
(4) If the Quote report that you installed is close to what you want, then you CAN edit it. You just find the report in the reports section, open it (under More Actions, choose Edit) and then download it. It will save as an .RPT file and you can then open it in SQL Server/Visual Studio Business Intelligence Designer (or something like that) and make edits. It sounds a lot easier than it is in reality - but it's a helpful starting point.
Hope that gives you a helpful starting point.


Signature deleted
modus_operandi, EE Moderator

Open in new window

0
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 24115225
Hi

Great note  

Just  a correction

 It will save as an .RDL file  not .RPT file
0
 
LVL 16

Author Closing Comment

by:legalsrl
ID: 31568843
Very good answers, thank you to everyone, what a lot of things to learn so due to the timescale, I'm better off outsourcing it.  Thanks again
0
 
LVL 10

Expert Comment

by:crm_info
ID: 24117548
Well...if you're outsourcing ... www.customer-connect.com
 
0
 
LVL 16

Author Comment

by:legalsrl
ID: 24117736
Thanks for the link, just submitted an enquiry

Cheers
Si
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to add SSRS subscription in Team Foundataoin server(TFS) 3 52
crm 2010 on premise 5 77
SSRS Dynamic Date Parameter 25 371
SSRS 2008 r2 - finding the selection Screen 3 125
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question