Solved

Geographical Reporting in Crystal Reports

Posted on 2013-05-21
3
478 Views
Last Modified: 2013-05-24
Hi,

I am in the UK and have a table which contains post codes, and town names. I would ideally like to plot the volume of A on the map, and then overlay the volume of B.

I have plotted the volume of A, however, I can see it is not a complete picture. When I go to Resolve Mismatch I can see that lots of places have not been plotted, and the selection of Crystal towns/cities is far from complete.

I do have post codes though, but I do not seem to have any better luck with these.

I have many questions..
Is there a way to update the crystal list of towns/cities to plot my data against?

Once I have done so, is it possible to layer a second map over the first? I see Layers as an option, but it doesn't seem to do anything when I click it.

My data is a table pulled from multiple sources in our SQL MS. Would it be better to create a new column in the warehouse, one which crystal would find easier to work with, and if so, what and how? I always thought latitude and longitude references were preferred.

Perhaps crystal reports isn't the best suited for this sort of reporting. If not, what tools would you suggest I look at instead?

Thanks for your help
0
Comment
Question by:BananaFury
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
I don't believe there is a way to upgrade the mapping capability through Crystal.

Crystal uses a commercial mapping tool

http://www.kenhamady.com/addmap.shtml

How to use mapping in Crystal

http://aspalliance.com/1838_Geographic_Data_with_Crystal_Reports.2

http://www.apos.com/content/esri-live-viewer

mlmcc
0
 

Author Comment

by:BananaFury
Comment Utility
Anybody else have anything to offer?

I am surprised that Crystal is unable to map against places like "Cardiff"
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
What do you mean unable to map against Cardiff?

Did you purchase the additional maps for that area?

mlmcc
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video discusses moving either the default database or any database to a new volume.

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now