Search results for query: *

That worked. Thanks a million for your help. In George Pecks book 'Crystal Reports, The complete Reference', it says that Distinct and Count are two separate words.

I am in the add formula section of Crystal Reports. I have the following statement in Crystal syntax Distinct Count ({Users.TelephoneNumberID}, {Zone.Name}) The error says that the remaining text does not appear to be part of the formula. If I use the query Count ({Users.TelephoneNumberID}...

I'm having problems setting the location of the server in code. The following code results in the report showing but it still returns records from the database on its original server. Hence the code is not resulting in a change of server. Can anybody help with this issue? Thanks in advance...

Hi, I am trying to search for records between certain dates to be displayed in a Crystal Report using vb application. If I use the date format 'dd/mmm/yyyy' in the record selection formula, I get the correct results. My problem is that I must localise it. If for example I search using...

Hi I'm attempting to get and set the regional settings(country) using vb code. I'm not having much success. Can anybody help. Thanks in advance Sinead

I have deployed a compiled application including embedded Crystal Reports on a remote machine. I have tested this with from the Visual Basic development environment with my machine to the same database and it works. I have duplicated the ODBC setting I use on this machine on the other one. I am...

Hiya, I want to draw a line across the top of a line chart so that actual values can be compared with the targeted value (inputted by user). Can anybody tell me how to do this?

I have a report which has two groups in it. One is 'by Zone' and one 'by Day'. I want the report to group by just one of these groups, depending on which group the user chooses. However if I suppress one of the group headers it still groups by both. Can anybody help?

I am trying to search for a particular date from a report. When searching I have the following code Set SelectField = VSelExpert1.GetField(1) With SelectField .FieldType = crDateTimeField .FieldName = "ParkingHist.StartTime" .AddValue...

I am using the search expert to search for particular information on the main report. It allows me to manually jump through the relevant results of the query. However, I want to create a new report which will just show me the relevant results, based on the query. Can anybody help me?

Hi, Just to rephrase a question I asked earlier. I am trying to reduce cost by not buying mapinfo or any other type of geographic information systems. Basically, I want to put a map of Cork City(Ireland) onto a Crystal Report and try to split it up into 4 zones. Is this possible without...

Every time I make a change to a Crystal report within a VB project (it can happen on other occasions as well), I get the error above. Why is this occurring? Even if I create a new project, it still happens...

Hi everyone, I am trying to put a map of a city in Ireland on a Crystal Report. I want to be able to double click on particular zones of the map to get information. Is it possible to do this or do I need some other software?

In the developers guide for Crystal Reports it says... Dim report As New CrystalReport1 CRViewer1.ReportSource = report CRViewer1.ViewReport The CrystalReport1 object gives an error saying that the 'User Defined Type is not defined'. I have 2 controls on the form. 1 is the crviewer and the...