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...

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...

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...

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...

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

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...

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...