Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Crystal Reports 2008 a...
Microsoft Dynamics RMS (Archived)

Crystal Reports 2008 and RMS

(0) ShareShare
ReportReport
Posted on by mikelondon 195

Please - can anyone give some guidance on linking RMS SQL tables for generating reports in CR?

 Thanks.

 Micky

*This post is locked for comments

  • mikelondon Profile Picture
    mikelondon 195 on at
    Re: Re: Re: Re: Crystal Reports 2008 and RMS

    Hi Steve,

    Please let me know about your solution.

    Thanks.

    Micky

  • Steve Weber Profile Picture
    Steve Weber 135 on at
    Re: Re: Re: Crystal Reports 2008 and RMS

    We have a solution that allows you to edit Microsoft Quick Reports and present the results using aspx pages hosted on your own server, allowing for filtering, export to excel etc.   Solution works for any QRP file.

     Let me know if you're interested

  • mikelondon Profile Picture
    mikelondon 195 on at
    Re: Re: Crystal Reports 2008 and RMS

    Hi Alexandre,

    Thanks for your reply.  I've connected CR2008 to the SQL database OK.  My question relates to links between the SQL DB tables.  I'm having trouble creating the right links so that my reports provide meaningful results and I was wondering if you might be able to give me any guidance on this?

    Thanks.

    Micky

  • alexandre Profile Picture
    alexandre 200 on at
    Re: Crystal Reports 2008 and RMS
    This is my way to do it. I've first created an ODBC Data Source for the underlying MS SQL Server. I've also created a DNS file for my Excel connections to the database. When you create a new report in CR2008, it ask you for connection. Create a new connection with an ODBC Data Source, then select either your DNS file or the ODBC link you've created. Maybe it isnt clear enought, in that case i'll try to explain in another way.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans