Recent content by CR4Reid

Hi LB, Yes I do want to show consecutive numbers even if there's no corresponding value refs. This way I'll know which invoices that were not assigned to a job (due to voided invoice, lost/destroyed invoice, etc). I think I'm going to try your subreport suggestion by having the counter in the...

Thanks for your reply LB. I should've clarified the following: FR Ref is a check formula: if {@MyCounter}={@value ref} then {@value ref} else 0 MyCounter formula: Whileprintingrecords; numbervar Counter:=Counter+1; value ref formula: (This formula is to convert the Reference field to value)...

Hello, Using CR2008 and I can't figure out why my records are acting the way they are. I need to show invoice references to a job. Each invoice book has invoice numbers which are their respective references. Each job will then be associated to a reference. Some invoices are voided or lost...

I answered my own question with your help: SELECT SUBSTR("FIELD_A",1,[highlight #FCE94F]instr("FIELD_A",'#',1,1)-1)[/highlight] AS OBJECT FROM "DATABASE" Thanks andymc!

Thanks for your prompt reply andymc. I neglected to mention that I'm creating a Command object and require the SQL code in the SELECT statement. The current SQL command I have is: SELECT SUBSTR("FIELD_A",1,4) AS OBJECT FROM "DATABASE" The problem with this statement is it does not show any...

Hello all, Using Crystal XI and Oracle ODBC. I'm trying to extract the first 4 or 5 digits from a field and declare it as the field "OBJECT" in the SELECT statement. The contents of "FIELD_A" is as followed: S510#CCBB S1313#BTCC 14444#SQQQ 7980#TUVV The result that I'm looking for: S510...

Hello, I'm using Crystal 11.0.0.1282 and I'm having trouble with Crosstabs. I have 2 fields in the crosstab: count of occurrences and sum of dollar values of these occurrences. The report is grouped by date (monthly) and it's spread across 8 branches. When I put the crosstab into GH1, it...

Hi there, I've got a unique problem calculating data based on an operational day. I've got buses that comes in at 4 am and required to be fueled starting at 6 am. The operational day is from 4 am today til tomorrow 3:59:59. For example: today is Thursday and the time is 7:00 am. Bus 3359 is...

Awesome! Thanks Peter!

Thanks Charliy. I'm going to have to mess with it some more.

Hello, I need to count distinct vehicle numbers within a 2 week time frame of how much fueling was done. Fueling is done at 8 am and continues through the night until 7:59 am the next morning. This counts as the same day. So if on Feb 11 8:30 am, car 1234 was fueled, that counts as one...

Aha! I think you hit that one on the head! The field is indeed a currency field. And yes, the "sum(totalhoursinvoiced) field is a grand total. Thank you so much Howard!

The formula will be on GF1. There are 2 running totals, and 1 summed field: total hours invoiced. The formula = sum(totalhoursinvoiced)/rtTechHours At this point, it won't let me out of the editor and complains that "rtTechHours" is not a number.

Hello all, Been at this for a while and can't seem to get it to work. I have a report with 3 groups: By technician, by job, then by invoice. 1 technician can have multiple jobs, and each job can have multiple invoices. Each job will have hours posted to it by the technician as well as an...

Thanks LB for your time and expertise. The report is grouped by job#; on my sample data, I wanted to show that job 5554 have 2 invoices & 1 CR note. It's really difficult to illustrate without screen shots. I'm going to experiment using queries to sum the invoice and expense data. Will...