Recent content by tuigvlieg

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

Hi, Did you already have a solution. I have the same issue here. Also Crystal version 8 and MYSQL 4 and also MYSQL 5. Rgds, Gert-Jan

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 Turkbear, I have solved it in the meanwhile. The proposed solution provided by you did not work. Each time I received an DLL error message. Solution I have made is to create a formula field only contaning the SKU.sku. I created via your proposed solution the distint count and that worked...

I managed to to make big progress, I still have one problem left. It seems that the ODBC connection does not accept a distinct count based on the query below. Does someone has a clue how I can get a distinct selection on the SKU? If I use the select distinct I will end op with 2 records for...

Hi, I am sorry but we are using Oracle database version 8.0. I managed to have a union. Seems to be very easy to create. Thanks as I was not familiar with this option. However I am still struckling to have the SKU table linked that should be linked based on the SKU field. ITRN.SKU = SKU.SKU. I...

HI Turkbear, Thanks for you reply. It sounds that the unions is a good solution. However I am not familiar with this options. Can you help me with this statement? The output I am looking for is a distinct overview of SKU's that have been shipped or received the last six weeks. So the I have...

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.

Hoi IdoMillet, No the save data with report is off. THe Crystal command line generates a .bat. If I start this .bat manual it runs fine. If I start the .bat with the windows taks manager it keeps repating the data of a specific timee without refreshing. I hope someone can help me out as me and...

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