Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software market. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc.

If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM ? we are giving you directions in this article.

  • Microsoft CRM SDK ? this is software development kit with C# and partly VB.net code samples ? it is supported by Microsoft Business Solutions technical support. It is based on web service calls, if you are C# .NET developer ? you are excellently positioned to do this type of customizations. This is the preferred modification scenario and this should be easily upgradeable customization. VB.Net examples will be available soon.
  • Legacy SQL Data integration. This is also easy and safe. If you have SQL database, sitting on the same or linked SQL Server ? you can create ASPX .Net application and simply integrate it into CRM. You can place it on the navigation bar or menu in isv.config ? please refer to MS CRM SDK
  • Legacy ASP integration ? this is somewhat more sophisticated. You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS. The trick is ? you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service.
  • Microsoft Exchange Programming. Microsoft CRM has Exchange connector ? which moves CRM incoming email to MS if it has GUID in its subject. You can alter this logic (for instance - move email to CRM if it doesn't have GUID but it is from the sender who is contact or account in MS CRM). Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.
  • Direct SQL touch ? in #4 above I described you the scenario with MS Exchange handlers ? this would be ideal world if MS CRM SDK does the job. But ? in real world this is not always true ? you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc). This is not supported by MBS technical support ? but you can rescue to this technique if you have to get job done.
  • MS CRM Customization tool ? this is rather end-user tool and we don't describe it here ? read the manual. We've described above the options to use when this tool doesn't do the job
  • Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.
  • Happy modifying! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally (help@albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    experienced cleaning professionals Northbrook ..
    In The News:

    Cybersecurity experts warn about one of the largest credential compilations ever found, urging users to check "Have I Been Pwned" and change passwords immediately.
    Quick iPhone and Android battery optimization techniques help your device stay powered all day by turning off hidden features that secretly drain power in the background.
    Kodiak Driver autonomous truck achieves perfect 98 safety score, matching top human fleets in groundbreaking AI evaluation by Nauto's VERA system.
    New 401k catch-up contribution rules in 2026 will change taxes for high earners over 50. Learn how scammers exploit these changes and protect your retirement savings.
    Kurt Knutsson's guide covers social media privacy protection through location settings, account privacy controls and two-factor authentication to prevent scams and data breaches.
    Revolutionary retinal implant restores central vision in 80% of patients with advanced macular degeneration, offering hope where treatments once only slowed blindness.
    Learn how to use passkeys on Windows and Mac computers without cameras or fingerprint readers. Discover secure authentication methods that replace passwords.
    Tesla's FSD v14.1.2 update reintroduces Mad Max mode, enabling higher speeds and more frequent lane changes than the standard Hurry profile setting.
    A phishing email scam targeting American Express customers shows how cybercriminals use fake urgent messages to steal personal and financial information.
    Facebook's new Meta AI feature analyzes your camera roll photos to create polished collages automatically, but requires cloud processing and raises privacy concerns.
    A New Jersey teenager filed a major lawsuit against AI/Robotics Venture Strategy 3 Ltd. over ClothOff, an AI tool that created fake nude images from her social media photos.
    Microsoft reports Storm-2657 cybercriminals sent phishing emails to 6,000 addresses at 25 universities to steal payroll credentials and redirect funds.
    Astronomers have discovered asteroid 2025 SC79, a skyscraper-sized space rock orbiting the sun in just 128 days. the second-fastest known.
    The Fox News AI Newsletter delivers the latest developments form the world of artificial intelligence, including the technology's challenges and opportunities.
    A cyberattack on SimonMed Imaging exposed personal information of 1.2 million patients, including medical records, financial details and identity papers.
    Spotify's managed accounts for kids under 13 now available in at least seven countries, allowing parents to filter and block explicit content and songs.
    Friendly text conversations about BBQs and social events can lead to WEEX gold trading scams that target older adults with fake investment opportunities.
    California company Skyeports creates self-healing glass spheres from Moon regolith that generate solar power and support plant growth for sustainable lunar living.
    Cleafy researchers discover fake VPN streaming app Mobdro Pro that installs Klopatra banking Trojan, giving attackers full control over Android devices.
    Police departments across the U.S. and Canada are adopting virtual reality training to better prepare officers for high-pressure, real-world situations.
    House Bill 469 would prevent AI systems from owning property, serving as executives, or gaining legal personhood in Ohio under Representative Thaddeus Claggett's proposal.
    Public voter records expose retirees' personal details to election scammers who create targeted cons using names, addresses, and voting history data.
    Instead of fearing what comes next with artificial intelligence, think outside the box. Here are high-earning AI jobs that don't require a computer science degree.
    OpenAI CEO Sam Altman says polite words like "please" and "thank you" cost millions annually, while direct prompts may improve ChatGPT accuracy by several points.
    Chattee Chat and GiMe Chat exposed intimate conversations and photos, revealing users spent up to $18,000 on AI companions before the breach.

    How to Tell You Have Spyware, Ad-ware or Viruses

    Usually, the easiest way to tell you have spyware is... Read More

    Assertion in Java

    Assertion facility is added in J2SE 1.4. In order to... Read More

    Collaboration Software: Index of Collaboration Software Technologies

    Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

    Ukraine: a Prospective Player on the World Software Outsourcing Market

    The destruction of the Soviet Union about 15 years ago,... Read More

    Do You Know These Facts About Spyware ?

    Imagine something that follows you home and sets itself up... Read More

    Software: What Suits Me?

    Almost all new and major brand of PCs come with... Read More

    Your Computer May Be Infected, Heres How To Check (NOT about virus)

    NOTE: Please take time to read on - it may... Read More

    Helping Newbies Understand Professional Software

    The Windows registry is a huge database that ensures normal... Read More

    Databases ? How We Love to Hate Them!

    You've finally created databases that you can actually use to... Read More

    Open Source Concepts: Dual Licensing Explained

    We were recently faced with a decision: either to let... Read More

    Linux ? Keyboard Or Mouse

    Just stress testing one of the latest Linux distributions. Been... Read More

    Microsoft CRM Modification ? Overview for IT Specialist

    Microsoft CRM is now on the scene and it is... Read More

    Who Is Minding Your Sensitive Data?

    Stealing company information used to be the specialty of spies... Read More

    The Truth about Colossus: Are You Just A Magnetic Image?

    What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

    eCommerce development for Microsoft Great Plains: tools and highlights for programmer

    Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

    Two Reasons to Use Timesheet Software

    This short paper will expand on two key reasons to... Read More

    Microsoft Great Plains Integrations ? Retail Management Sample

    Microsoft Business Solutions is emerging as very attractive vendor for... Read More

    Increase Office Efficiency With One Simple Tool

    When you need a phone number, you do a quick... Read More

    How To Identify, Cure and Prevent Spyware/Adware Infections

    Just when you thought you were Web savvy, one more... Read More

    Software Development in 2005 - Back to the Future

    2005 ? Back to the Future.What does the future hold?... Read More

    Microsoft Navision and Crystal Reports - An Overview

    Microsoft Business Solutions ? Navision is an integrated solution for... Read More

    How to Make Own CMS

    Every day millions of new web documents emerge on the... Read More

    Free Program Removes Spyware not Detected by Premium Security Scan

    What is Spyware?Spyware monitors your surfing habits and sends the... Read More

    Bridging the Gap between Paper and Data

    The cornerstone of successful automated office systems is the ability... Read More

    Theres Gold in Your Websites Server Log

    Many Webmasters have never bothered to view their website's server... Read More

    best value cleaning service Northbrook ..