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 derfloh 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: *

  • Users: tttggg
  • Order by date
  1. tttggg

    formula help for row suppress

    I have a summary report with 2 groups, City and customer. Canadian cities have only one row for each itemid and US Cities has 2 rows for each itemid. I need to suppress rows for the following conditions: 1.when the 2 discount values are zero (Canadian cities) 2.In US Cities both rows has to be...
  2. tttggg

    Problems with Number formatting

    I just add the numbers 1,2,3 to sequence the field results The table field is 5,138 I understand where i was wrong Thank you LB
  3. tttggg

    Problems with Number formatting

    I’m using the following formula hoping to get the last 4 digits of a number Right (totext({tablefield}),4) But it gives me only the last digit. Table field result 1.5,138 8.00 2.14,008 8.00 3.129 9.00 If my formula is wrong, can...
  4. tttggg

    formula with string

    Thanks PatriciaObreja It works.thanks a lot....
  5. tttggg

    formula with string

    Hi Lb Thanks for the concern I tried it and there were "No Errors" but when i add it to the report it shrows a Error, "Bad date format String" Am i Missing anything here?
  6. tttggg

    formula with string

    Hi Brain I tried totext({table,field},"yyyy/MM/dd hh:mm:ss") But i throws the following error: "Too many arguments have been given to this function
  7. tttggg

    formula with string

    currently the fields displays SALESDT : 20080208 SALESTM : 024559 i wanted it to be like 2008/02/08 02:45:59
  8. tttggg

    formula with string

    I have 2 string fields SALESDT & SALESTM which represents the date and time. I need to display these two fields as a string as following yyyy/mm/dd hh:mm:ss I’m trying to do this but I’m not successful. Any help with this is much appreciated. Working with CR 8.5 & DB2
  9. tttggg

    Earlier version of Crystal Reports -Error

    We have a vb application to run reports and recently there are some issues where the reports are not running. I’m getting an error saying “-2147191159 Not a 4.x or earlier version of Crystal Reports” anybody have any idea what this error is. Any help with this is much appreciated CR 8.5 and...
  10. tttggg

    Help with DateTime Calculation

    Thanks for the concern LB i figured it out I just Add the "+" sign to the resulting string in the above formula. Ddhhmmss:=totext(days,0,"")+":"totext(hrs,00,"")+":"...... + "+" I don't know this is good way of doing it , but its works. If there is any better way of doing it please...
  11. tttggg

    Help with DateTime Calculation

    Thanks LB i got it to work. I have an issue with alignment. I know this has to in a different thread but i'm posting here since i might easy to follow me. In order to make the "Duration" different where the clearDT is Null i'm added a + sign with value. Eg: ####+ (when ClearDT is...
  12. tttggg

    Help with DateTime Calculation

    I’m trying to get a time duration from two dates. But the results set is not correct. Can any one tell me what i/m missing here. My formula , If isnull ({T_ObjectStatusLogs.ClearDT}) then datediff ("h",{T_ObjectStatusLogs.SetDT},currentdatetime) Else numberVar dur :=...
  13. tttggg

    Help with date function

    Thanks lbass
  14. tttggg

    Help with date function

    Your point makes sense. Days/Hr/Min/Sec make more sense. If you can help me with a formula it will be much Appreciated Thanks
  15. tttggg

    Help with date function

    I want to be in the following format yyyy/mm/dd h:m:s Say the result is 1562 Sec then It should be 00/00/00 0:26:02 Thanks
  16. tttggg

    Help with date function

    Is it possible to convert the return value to Datetime?
  17. tttggg

    Help with date function

    I have a start date and an end date . I need to find out the date difference ( the duration ) I’m used the datediff function and got the difference in sec. Can anyone tell how can I convert total number of sec onto “mm/dd/yyyy” format. I used Date (sec) but it gives me wrong date. I’m using CR...
  18. tttggg

    How to check a database field whether its numeric?

    Can anyone tell ne how to check whether a field is numeric or not. Basically I need to check a field whether its numeric or not and if its numeric then I have to convert it into number. I’m little confused how to check a database field whether its numeric? I’m using CR 8.5 and DB2.
  19. tttggg

    report with 2 pages wide

    I'm using CR8.5 ,db2 database. I have to create a report which has many columns. Is it possible to make a report with 2 pages wide? If so can any one please tell me how. Thanks in advance
  20. tttggg

    Exporting to Word format

    Can any one tell me what is the export format code for the latest ms word. When i export a report to ms word and tried to open it, its not opening. I thing it's exporting in ms word 97.I'm facing this issue after the recent update from Microsoft. I believe that there is a code for each export...

Part and Inventory Search

Back
Top