Search results for query: *

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

I used a sample data and was able to come up with a Crosstab solution. I'm not sure if that's what you're looking for. I can't seem to copy/paste images but here's what I have: Delta y/day rest/year TOTAL 0.15 105 13,208 SOFTWARE -0.04 27 3,923 STATUS...

Right! Ideally, that's what I'd like to see. However, right now, it's showing: Job# Inv# InvoiceTotal Labour$ Material$ 5554 1234 $500.00 300.00 20.00 5554 1235 ($500.00) CR 0 0 5554 1236 $675.00 300.00 20.00 TOTAL $675.00 600.00 40.00...

Ok - I tried the rt route, but it didn't work. I neglected to mention my reports structure. The invoice data is on one table and the expense data is on a separate table. On the detail section, I list all invoices with its total. Then I sum all totals grouped by JobId. On GF1, the invoice...

Thanks LB - I never thought of using rt's but will experiment and advise of results. I can't work on it until later in the week. Thanks again CR4

Thanks lbass. I thought of that, but when an invoice is credited, then corrected with additional expenses, that's when it gets trickier. The hang-up is using the same job#. I'm trying to use a subreport to total all expenses for all invoices and then showing that on the main report. Lots of...