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 rosemaryl

  1. rosemaryl

    Change military time to standard time

    Dear Frontsj, Try: Numbervar T := ToNumber({CONTHIST.ONTIME}); Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports. You will get answers more quickly if you read this before posting: faq149-3762
  2. rosemaryl

    CR XI - Is it possible to do Venn Diagrams in Crystal

    Dear lbass, There is nothing wrong with your concept at all. However, Table is a keyword in sql server and in Oracle and cannot be declared that way. Select 'A' as Table should be Select 'A' as 'Table'. I don't know what backend you use - so it may be valid in that. But the main point I...
  3. rosemaryl

    CR XI - Is it possible to do Venn Diagrams in Crystal

    Dear ReportDr00, Lbass solution is truly better. But, when writing Union All statements it is important to know that the number of fields (and field type at each position) must match as only one column is returned for each of the two columns from the table. I would also suggest adding a text...
  4. rosemaryl

    CR XI - Is it possible to do Venn Diagrams in Crystal

    Dear ReportDr00, I would think that you would need a full outer join and that you only need to join on SSN as it would be unique. A full outer join pulls all combinatio of the data and you shouldn't need to create table c. Regards, ro Rosemary Lieberman rosemary-at-microflo.com...
  5. rosemaryl

    CR XI - Is it possible to do Venn Diagrams in Crystal

    Dear Lbass, You are right. Great solution! As, in a traditional Venn Diagram the overlapped records are not presented twice. It would be nice if Crystal could show this relationship ... I did a search at the CR KB and not one item came up. Best, ro Rosemary Lieberman...
  6. rosemaryl

    CR XI - Is it possible to do Venn Diagrams in Crystal

    Dear ReportDr00, You could easily represent this data in one pie chart. You would create 3 separate formulas to test the data (the formulas below are for example sake only as I don't know how the data is stored, that indicates Both Counties. Create 3 formulas: If {Table.Count} = 'County A'...
  7. rosemaryl

    Returning values not pulled by the Query in a report

    Dear Saran26, One way you could solve this is with a manual crosstab, where you create the columns yourself. You would create a formula for each possible state. With your example data, you would create 4 formulas. //Example formula If {Table.State} = 'Open' then 1 else 0 //end example Place...
  8. rosemaryl

    Change military time to standard time

    Dear Cutpen, Here is a new and much simpler formula. The problem I was having (besides driving down the rosy path) was that when the number was transformed to text it wasn't keeping the padded 0s. Now it does. Now this formula works as follows: If any number is entered that is less than a 4...
  9. rosemaryl

    Change military time to standard time

    Dear Cutpen, Ok. That can happen if the field is blank or null. Give me a few minutes to further tinker with the formula. Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports. You will get answers more...
  10. rosemaryl

    How the change the negative time to 00:00:00

    Dear Vega83; This will work: whileprintingrecords; numberVar dur := datediff("s",minimum({@Print WMS},{@Date}),minimum({Command.EDI_CRT_TS},{@Date}));dur := if dur < 0 then 0 else dur; numberVar hrs; numberVar min; numberVar sec; stringVar hhmmss; hrs := Truncate(Truncate(dur/60)/60); min :=...
  11. rosemaryl

    How the change the negative time to 00:00:00

    Dear Vega83, Can you please show your current formula? Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports. You will get answers more quickly if you read this before posting: faq149-3762
  12. rosemaryl

    Change military time to standard time

    Dear Cutpen, Just so that you have the entire formula correct, copy this: NumberVar T := {HMN_UNSHDDAY.S_START}; numbervar l := len(totext(tonumber(t))); numbervar c := select(l) case 0 : 0 case 1 : 0 case 2 : 0 case 3 : 1...
  13. rosemaryl

    Change military time to standard time

    Dear Lbass, Oh you are right! I am testing in 10 and it had slipped my mind about the issue in 8.5. You have a good memory as it was me that told you. Put the extra semicolon in cutepen and it will be fixed. Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo...
  14. rosemaryl

    Change military time to standard time

    Dear Cutpen, Yes this is all crystal syntax. Did you copy my formula? Or did you type it? Can you paste in exactly what you have in the formula? Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports...
  15. rosemaryl

    Change military time to standard time

    Dear Cutpen, Thankyou! My mistake was only testing 4 digit numbers. I believe that the following corrected formula will work for you. NumberVar T := {HMN_UNSHDDAY.S_START}; numbervar l := len(totext(tonumber(t))); numbervar c := select(l) case 0 : 0 case...
See more

Part and Inventory Search

Back
Top