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...
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 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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.