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 Wanet Telecoms Ltd 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: pancho13
  • Content: Threads
  • Order by date
  1. pancho13

    Partial data matching for grouping

    I need to group data from a field by partial matching its content... eg: 050512....needs to group by "05*"...or 160523 needs grouping by "16*"....any idea on how to group by this partial match??? Also....how can "alias" this matching statement so that I can display on the report with a text tag...
  2. pancho13

    Paradox table links in Crystal Reports

    Hello Paradox / Crystal Gurus Could you please help me with this little problem: I've got 2 paradox tables: "work" - "labour" The "work" table contains 4 fields based on the 'labour' table, that is, each field looks into the same 'labour' table and can select any record from it. I can run a...
  3. pancho13

    Paradox db report

    Hello Crystal Gurus Could you please help me with this little problem: I've got 2 paradox tables: "work" - "labour" The "work" table contains 4 fields based on the 'labour' table, that is, each field looks into the same 'labour' table and can select any record from it. I can run a report from...
  4. pancho13

    Summary field ???

    Hello There Crystal gurus: I've got a little tricky problem that i can't get an answer for. How can I create a formula field from a group summary so that I could reduce it from the grand total eg: Sum all cost from a 'group field' where that group 'gl' field start with "22", then reduce this...
  5. pancho13

    Converting a formula field into numerical format field

    Hello there Gurus of the Crystal World I've got this challenge for you people: I've created a formula field based on another field; the formula field is a "Select/case formula" where I lookup onto a gl field and I've assigned a $value according with the gl field. What I would like to do is...
  6. pancho13

    Converting a number into hours....How???

    Hello there Could you please help me to convert back a number into hours.... As you know, Crystal report cannot add hours, eg: 13hrs + 1:30 hrs = 14:30 hrs....or in number terms...14.5 hrs What I've done, I;ve converted the hours into a number... eg: 1:45 = 1.75...so that give me the chance...
  7. pancho13

    How to display "90 Minutes" as "1:30" hrs???

    Hello there I've managed to change the format "1:30" into "90 minutes", so that allows me to add time with time. eg: 90 + 30 = 120 minutes... but, How to change those "120 minutes into 2:00 hrs????? how do I format "120 minutes" back to "2:00 hrs&quot...

Part and Inventory Search

Back
Top