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!

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

Recent content by cm1234

  1. cm1234

    fields in a table

    Hej IBASS This did just do the trick, thank you very much for your help its very commendable. best regards cm1234
  2. cm1234

    fields in a table

    I am running CR 9.0 and have a issue in getting fields in a tabel to display in a different way The string is made in MS sql and i need it to not loke like this because he has three qaulifications nametable Qualifytable 1 Mike A1 2 Mike B2 3 Mike C3 But to be visual in...
  3. cm1234

    number converted to time format

    Hi Sorry that it toke me so long to answar you, but in a little org. you must put many different caps on. Im sorry but it doesnt work. best regards cm1234
  4. cm1234

    number converted to time format

    Hi acessn No im sorry it dont work, but thankyou for your quick reply on this matter. It is 597 minuts stored as number and that gives 9 hours and 57 min., i just need to get it converted. best regards cm1234
  5. cm1234

    number converted to time format

    I am running CR 9.0 and have a issue in getting a number tabel converted to time format. The string is made in MS sql and i need it to be visual in CR as a time. now it shows like 597 (a number) and it schould be like 9:57(hh:mm) Hope somebody can help me best regards cm1234
  6. cm1234

    Convert String to Date

    Hi AngelB thanks for your qiuck response the format of the string is 2006-10-30 09.20.00 and i only need the date from this, not the time best regards Cm1234
  7. cm1234

    Convert String to Date

    Hi out there I am running CR 9.0 and have a issue in getting a string converted to date format. The string is made in MS sql and i need it to be visual in CR as a date. Hope somebody can help me Best regards Cm1234
  8. cm1234

    Maintain culom with

    Hello synapsevampire By saying maintain column width, i mean that if column A is 8 width and column B is 21 witdh i want to keep that width in excel as well!!!!!! I hope this makes sense to you. regards cm1234
  9. cm1234

    Maintain culom with

    Hello out there Im running CR 9,0 and my problem is that when making a report in CR and exporting it to excel(2003), i cannot get it to maintain column width as in the CR report. I choose the "column width based on objects in the Details" and also have tried the "Maintain column alignment", but...
  10. cm1234

    setting first week off year

    Hello out there Im running CR 9,0 and my problem is that when making a report with week parameter in it starts with week 2 (03-01-05 to 09-01-05/ monday to Sunday) but its actually week 1 according to our calendar. How to solve this???? Hope some one out here can help Bet Regards cm1234
  11. cm1234

    last7days

    Thank you both But the hint from Breed35 just did the job best regards cm1234
  12. cm1234

    last7days

    Hi Hilfy Normaly i would give you absolute right but this does not work for me, when i put my >>{table.date} = currentdate-3<< i get only the date three daysago and not what is inbetween??????? Is there another way to do this date thing? best regards cm1234
  13. cm1234

    last7days

    Hello out there Im running CR 9,0 and the data in this question comes from oracle 9,0 Here comes my question: How can i show last3days in CR 9,0 Date comes from an odinary datetime field and looks like this >> 12-09-2004 12:22:45 << and so on There is a function called last7days this would...
  14. cm1234

    convert a oracle number field to a time field

    Hi out there I have just run a check on the data output and its defantly 00,01-00,02 and so on To synapsevampire thanks for the tip,i'll try to work it that way round(havent much experience in working on the database)and the code gives, that there are no errors but when i try to set the formula...
  15. cm1234

    convert a oracle number field to a time field

    Hi Bdreed35 Im sorry but your absolute right it's shown just like you put it 10,91 ,im quit sure off Im not in the office any more today but will post some data output straight away tomorrow morning. thanks once again regards Cm1234

Part and Inventory Search

Back
Top