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

Further developments - we have created a file dsn as opposed to a system dsn and this gives us the correct information. We have applied the service packs. It looks as though we are going to have to have to search for another odbc driver.

Thanks for your reply but it appears that my description of the problem was unclear. It is not a format issue, it's as though the data is incorrect. Some lines (same field) that have been brought forward are correct - 0.2 in both crystal and the data table yet some are different - 0.07 in...

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

Thanks for that. I can get the correct value showing in the sub-report but it always shows as 0 in the main report. Does it matter that it is an on-demand report? Does it matter also that I have groups in the sub-report?

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

There are no merged cells. It is just a basic crosstab that I have exported. There are differences without me even doing anything.

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!

Unfortunately not - still searching!

Thanks for your help (& confusing you all!) but I have managed to sort it by using manual running totals.

Sorry for not being more precise. The problem with creating a sub-total on the field is that it always totals on this field. I have a selection criteria which specifies whether summary or detailed data is required. That's the problem - I need to be able to sub-total on either the detail or...

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