Search results for query: *

A strange one. My report, which includes a pie chart, does not display the 'pie' when the report is previewed. In design I can see the pie chart title, the pie itself and the key which shows the percentage breakdown of the pie. In preview I just see the pie chart title and the key which shows...

I am trying to use the Crystal Reports wizard in Access97 but although I have no security on the db a dialog box appears requesting a password. I have trawled the previous posts on this subject and was helpfully referred (thanks Malcolm) to a Crystal KBase article. It is available at...

Want an easy way of setting up a multiple line address? Use this formula (courtesy of Frobisher) : Dim Address(6) As String Local I Local AddressOut As String If Not IsNull({ADDRESSES.ADDR_LINE1}) Then Address(1) = {ADDRESSES.ADDR_LINE1} End If If Not IsNull({ADDRESSES.ADDR_LINE2}) Then...

New fields had been added to the database. Nothing of significance had changed, at least I don't think so. I will try and re create the problem at some point but for now must press on with the project Thanks again

When in doubt read the instructions... I checked Crystals' own help on this one and it states that 2 subreports should not be run from the shell of a main report (which contains nothing but the 2 subreports) Rather you should make one of your sub reports, the main report and the second is a...

Hi Ken Thanks for your response. I had verified the database. I have now discovered the cause of the problem. As I said in my last post, I had disabled the record selection criteria, which stopped the report from crashing, so I decided to concentrate my efforts on the parameters I was...

I am having major problems with 4 reports written recently for a client. We have made some changes to the database and the reports now crash when I attempt to run with a CRW32.exe error. I have referred to the Crystal Knowledge Base article number c2004374 on the subject which says either...

Hi rhinok Many thanks for your response. I have checked all the record selection criteria for the sub reports and they are already in the form you outlined. I can't see any reason why this shouldn't work, but it doesn't

I am trying to create a report that contains 2 subreports. I want to enter from and to dates at the level of the main report and have them used by both the subreports The subreports are based on different tables but have the same column name, so I have renamed each of the tables as O as in...

I am using the dummy union workaround (using Where 0=1) to do a Select Distinct. My problem is that I have a customer group sorted in ascending order on the report and Crystal is inserting an Order By clause at the end of the query in the form TABLENAME.FIELDNAME When I run the report I get...

Hi Ken Thanks for the response, but putting the ledger date into the select expert doesn't work. The whole query I am using is: SELECT "CLIENTS"."CLIENT_ID", "CLIENTS"."CLIENT_REF", "CLIENTS"."FORENAMES&quot...

I have a parameter which prompts the user to input a date. I then want to use that date in the main SQL statement. I am selecting records to populate a "customers" type main report which has a "transactions" sub report. I only want the Customer name to appear in the main...

Hi Ken I am using the default format for the field. If I use the customise option to show zero values as 0, it makes no difference, it still displays a blank. I definitely have a zero, rather than a null, in my (Oracle) database, and I am using CR8.5 I'm still puzzled as to why I cannot get...

I'm sure the answer to this is simple but I can't find it. I have a field in my report which displays a blank if the database value is zero. Is there an option to get this to display the number 0 rather than the blank? Thanks in advance

Thanks for that Gord. I should have mentioned that I need to do it this way because the users want to be able to direct output to the printer of their choice. I previously ran it the way you suggest without a problem.

I am trying (unsuccessfully) to deploy an application. The application captures concert bookings and then prints contracts for the bands. The problem is this: I have tested it thoroughly on my machine and it works fine. When I deploy it on the client machine the print process randomly...

The answer was in the first line. Although I said I was sure I hadn't used the offending field in any formula, I found it when I started to strip out everything, section by section, from the report. I had used it to conditionally suppress a section. Once I removed this, the problem was...

I have a problem with my Select statement. If I remove a field from my report it does not remove it from the Select statement. I seem to able to add and remove any other field but this one. I joined two tables in error when I created the report. I want to remove the join and the offending...