Search results for query: *

On our database we have a field that is displayed as 20071 where 1 is a week number and 2007 is the year number. In case we are in 200712 the week is two digit. Curent formula used (Dutch): ="week "+Rechts(Min(<Jaar Week>) ,2)+"-"+Links(Min(<Jaar Week>) ,4)+" t/m "+"week "+Rechts(Max(<Jaar...

We have a MYSQL 4 database. But we are unable to connect Crystal report version 8. We do see the tables but at the moment we select a table an error will follow. We read on the internet that it is is not possible to connect Crystal version 8 with MySQL version 4. Therefore we decided to install...

I don't succeed to set up an ODBC connection for Access and Crystal reports to mysql however i have created many ODBC connections before but not to mysql. Error message I receive after debuging is: The instruction at "0x1b000952e" referenced memory at "0x0ff685d0", could not be "read", That's...

Hi, I am using Crystal reports version 8.5. Examble situation: ============== Database I Order table SKU: A, C, D Receipt table:B SKU: B, D =============== Database II Order table: SKU: A,B Receipt table: SKU: D =============== I need to create a report that shows only SKU's...

Hi, We are using CRM version 1.2. Since a while we seem to have an issue with the modification date / time in the sql database. We are using the dutch regional settings on the SQL server. When updating timezone in CRM we do not see any change in the modification date on the SQL server. We...

I have a database field that is a character field and looks like this 875.127.00. I want to remove the last 2 zero's from the report. How should I do this? I have already done this via the format field but it should also be possible via a formula. Formula used: Left ({tsdsmd.dosvlg},6) Error...

We are currently using crystal desk - line generator for scheduling Crystal reports. But we are still experiencing problems with this tool. Is there a different tool available where we can schedule Crystal reports via mail that is working properly? If possible a cheap tool.

Best wishes for the new year! We are using Crystal desk option Crystal Command - line generator. This will automatically run / schedule crystal reports. If I create a windows task and schedule the report, it runs but it is not updating the crystal report output. Output is always the same...

Hi I am working with CR 8.5 I have build a CR report that need to be runned by around 60 people on different locations. User are logged in via 3 Citrix servers. Till now we build a report, saved the report, deleted all printers from the develop environment, send print to printer, "No printer...

Hi, We are using Crystal version 8.5.3.936. Situation I have is one table: DOSIER Part Supplier TYPE trip X A HENK C 2 Y B PIET C 5 2 R 5 R I want a report that reports all type C per...

We have version 8.5.3.936 I have changed a report and compiled the report. The change is the selection criteria. Selection criteria used: isnull ({WAVEDETAIL.WAVEDETAILKEY} ) and (Isnull({CODELKUP.LISTNAME}) or {CODELKUP.LISTNAME} = ["ISOCOUNTRY"]) and left({ORDERS.STATUS},1) <> '9' and...

I am using Crystal report version: 8.5.3 I have a document that can be downloaded from a web page as CSV file. I open this file and save it as DBF 4 file. I load this file into a Crystal reports table via add tables option Find database files. I browse to the correct location and select the...

I am using Crystal report version: 8.5.3 I have a document that can be downloaded from a web page as CSV file. I open this file and save it as DBF 4 file. I load this file into a Crystal reports table via add tables option Find database files. I browse to the correct location and select the...

I have created a formula. It is comparing specific fields from two tables. Depending on the outcome of the formula a yes or a no is displayed. I don't want to display all displayed fields when a no is shown. How do I surpress all fields for the specific line on the report where the value of...

Hi I am a new with Crystal report I have 2 tables for the same database. The location and pallet table. I want to show only the locations for which no pallet is available. In the table pallet are pallet from history that have a value zero. If such a record is available the location should show...

I have created a primary report and a subreport. In the sub report I have defined page header. When I export the sub report as primary report to PDF the report is showing the page header. When I export the defined primary report and export the report including the sub report the page header for...