Crystal Reports using SQL

Hi, I have been programming in SQL for a long time, but I have just bought Crystal Reports. I have a city and state field in one of my SQL tables, and would like to plot dots on a map in all the cities where we have customers. I cannot get the map feature to work in Crystal Reports though. Does anyone have any experience working with this?

 

I did a lot of CR & SQL Server for Siemens AG, however DASP does not support CR.


I can help you with some code but not for a DASP server.


All the best,


Mark

 

I am sorry, but you lost me. I've gotten CR to show a tabel with the city, state, and count of the number of contracts in each. I just want to plot those on a map. I click on the map button and select city as the geographic field and the count as the map value, but no dots show up. It always defaults to a Canadian map too, and I have to change it to USA.

 

What I was trying to say is DASP (discountasp.net) does not support CR, but I can still help you with it if you need.

Are you using the ActiveX reports or bound to SQL Server with the CR Engine? (2 totally different dogs.)

 

I am not sure what you are asking. (sorry, like I said, I'm a newbie). I am just trying to make static reports, so that shouldn't have anything to do with DASP, right? Even though my SQL database is hosted with DASP?

 

OK, in brief, there are two delivery methods for CR.

The CR Engine uses a licence you purchased with CR, and for which you can purchase additional processor or users for.

You can also skip using the CR engine and simply code your reports then load them into IE via ActiveX components.
That flavor does not use the licensing or the CR Engine.

Both can use live or disconnected data.

The CR Engine does a better job but the component method can even do complex matrix reports like Excel.

Now I've got one more question for you...
Are you going to be hosting these reports on a local machine that is using data from a remote DASP SQL Server?

 

Yes. I am just creating local reports and e-mailing them. However, the SQL data is hosted on DASP.

 

OK, I'll do what I can to help.

The last version I used was CR 9 and I don't have it installed anymore but I can help from memory because I did a ton of reports in version 9 with SQL Server 2000.

To save on costs we ditched it to create shaped data reports via SQL Server, ASP v3 and Excel.

What was the nature of the problem you were having? Creating a structured query in the report?

 

Specifically, I have a SQL view that shows the city, state, and count of contracts in each. I would like to create a geographic map of the United States, with dots on each city that has contracts. When I go to set up the map, I select city as my geographic field, and the count of the contracts as my map value. However, after I hit okay, it always defaults to a Canadian map. I go into the mismatch thing and change canadian cities to USA, but there are no dots on the map anywhere. I don't understand what I am doing wrong.

I'm using Version 10 by the way, but in the book I am reading about it, it says that there is virtually no difference between the map feature in 9 and 10.

 

If you're comfortable with SQL Server SPs create one on the DB for each of the table structures you want to use in reports, you can even use more than one.
Something I found handy was to use temp tables to dump some report data into.
That way you can have the structure you're after without any doubts.

Let the SP create distinct or filtered data for you, then the report will be easier.

You can get a bunch of Developer help on their site:
http://support.businessobjects.com/documentation/product_guides/default.asp

From the dropdown select the version you want help with and the product.
Some of the documentation is in D/L form, most is in PDF format.