Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tuigvlieg

    How do I format a year week field

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

    ODBC for Mysql

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

    How do I link Crystal report version to MYSQL version 5

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

    ODBC for Mysql

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

    Link data from from multi database multi table

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

    Link data from from multi database multi table

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

    Link data from from multi database multi table

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

    Link data from from multi database multi table

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

    Link data from from multi database multi table

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

    Microsoft CRM date / time setting (modification date)

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

    How to use the &quot;left&quot; option?

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

    How to schedule Crystal report?

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

    Crystaldesk&gt; Crystal command - Line generator

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

    Crystaldesk&gt; Crystal command - Line generator

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

    Set printer to letter instead of memo

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

    Modify selection criteria

    Hi dgillz, Under file I have the option "Save data with report". This is marked off so is not solving the issue. Any other suggestions? Rgds, GJ
  17. tuigvlieg

    Different selection criteria but one report (extracting data)

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

    Modify selection criteria

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

    Need to create index on imported DBF file

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

    How to create an index on a DBF file

    I forgot to say that the file is coming from an Microsoft environment and the table is running a Oracle database.

Part and Inventory Search

Back
Top