Search results for query: *

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...

Thanks lbass. I'll try to clarify a bit better: Table 'work' contains 4 fields : 'labour1',labour2,labour3,labour4, which are based on table 'Labour'; that is, all fields looks into this table to select a record from it. Also means that for each 'job' record entered into the 'work' table, the...

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...

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...

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...

BINGO!!! THANKS lbass , YOU NAIL IT CHEERS FROM AUSSIE LAND

This is what I've got.... formula:@budget(string) select GroupName ({@gls}) case "55210BLK700" : " $21,000.00" case "51820BLK700" : " $46,500.00" group running total:Sum ({poline.linecost}, {@gls})(number) What I need to do is this @budget(string) - Sum ({poline.linecost}, {@gls})(number)...

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...

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...

The problem was that every time that I have an "hour" figure, eg: 120 minutes, then the field displayed eg "2:0" or if I've got single minutes, eg: 5 minutes, the display was "0:5". I come up with this solution and works wonders, for me anyway. This is my solution...

Thanks guys!! specially dgillz, not exactly what I was looking for, but it did help me up for a proper solution, as your one miss out some xx: 00 when the hours didn't have any minutes. Is there any other easy way to convert this?? Thanks in advance

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...