Search results for query: *

Is it possible to format the chart axis on 8.5? If so, how can I do it? The text is too large and I'd like to reduce it. Thanks a lot.

Does anyone know if there are any known problems with Crystal version 8.5 and Pervasive version 8.0? I posted an issue last week but am still struggling to resolve it. We are now in a situation where we cannot trust the information coming through our reports in crystal from our Pervasive...

I am trying to retrieve data from pervasive using odbc. I am selecting one field (i.e. no formulae, parameters etc). However, when this data appears in crystal (8.5), the results are inconsistent when compared to viewing them directly in the table. Examples are 0.07 in crystal as opposed to...

I have created a report with a field on which shows purchase orders outstanding. There is a sub-report behind it which details the individual purchase orders. I am having trouble though getting the total from the sub-report to show on the main report (it shows the first purchase order only)...

We currently have several crystal reports which are scheduled to run at various times over our intranet. When the user selects an instance of the report, they can view all pages on screen. However, when they request a print, not all pages are printed (we have checked all the obvious print set...

I have created a simple crosstab query in Access 2002 (SP2) from one table and have tried to export it to Excel 2002 (SP2). However, the resilts in the excel file are different to the results in the crosstab in that it seems to be moving the figures to other cells. Some results are correct and...

I am trying to export a report from crystal to excel but keep getting the following error message; "Failed to export the report. error in MS ExcelExport Format DLL". Is this a crystal or Excel error? What do I need to do? Thanks a lot.

Is it possible to change the font size / format of chart labels and legends? If so, how do I do this please? Thanks a lot.

Is it possible to suppress a row and its's data in a crosstab based on a parameter? If so, how can this be done please? I have customer level information but I want to suppress this if "summary" is selected on the parameter. Thanks a lot!

I have the following fields which I have converted to give me the month and the year. formula= Year({SOP_Order_Line.Date_Required}) dim a as number, b as string If isdate(toText({SOP_Order_Line.Date_Required})) then a = datepart("m",{SOP_Order_Line.Date_Required}) If a > 0...

I have 3 columns of data. I do not want the line to show if all 3 columns have a zero value. Example: Stock record1 0 0 0 Stock record2 6 0 0 I do not want stock record1 to appear. How do I do this please? Thank you!

I am trying to create a grand total based on a group total which has selection criteria against it. Can someone please help me in doing this? Thanks

I am having great difficulty in ordering dates in the correct order. I have created the following formulae to string together the numberical month and year, e.g. 12/2002 (December 2002) and 01/2003 (January 2003). I keep getting January before December as 01 comes before 12. dim a as number...

I want to concatenate 2 number fields as follows; field 1 = 4563 field 2 = 4 to 4563 / 4 However, when I do this, I get the following; 4,563.00 / 4.00. How can I remove the 1,000's comma and the decimal places please so that it shows as 4563 / 4? Thanks a lot.

I have a Btrieve dbase which holds our invoice data etc, I have created an access dbase which shows dates and the assoicated period end month. I need to link these tables together based on the invoice date but am having difficulty as I keep getting an ODBC error. They are both date formatted...

Can I create a cross-tab which has the following columns (current month, budget month, lya month) for each row? If so, how can I do this please? Thanks a lot!

I would like to be able to create a cross-tab report which will drill down into another report showing the detail for that particular month (either another cross-tab report or a normal). Can this be done, and if so, how....please!! Thanks a lot!

Our period end dates vary from month to month (e.g. July = 01/07/02-02/08/02, August = 03/08/02-30/08/02 etc). I need to create a formula in a crosstab to pick up these "months" accordingly so that I can record sales for each period across the top. Can someone please tell me how I...

We publish our reports on Crystal Enterprise but several users prefer to download / export their reports to Excel in order to manipulate them further. However, even if we create a very simple formatted report (no sub-totals etc), the export to Excel still maintains all the headers, footers and...

By simply adding a certain field to a report or part of a selection criteria causes an odbc error ("You have been unexpectedly disconnected from the server"). Can anyone offer any suggestions as to what causes this error and how I can get round it. Thanks!