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 Rhinorhino 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 tttggg

  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
See more

Part and Inventory Search

Back
Top