Search results for query: *

Our system for handling jobs has various tables associated with live jobs. When a job is invoiced it is moved to history and the job is now stored in identically structured tables but with different names. When reporting I have to write 2 reports to get information i.e current & history. Is...

I am attempting to work out whether we have attended a job when we said we would attend a job and calculate %'s from it. I have 2 tables order_line and demand. Order_line contains details of the job and Demand contains the activities carried out on the job (1 to many) The attend by date is in...

I have created a report to produce an invoice to customers. A Subreport produces the Invoice Address. Due to human error etc people have entered the customer name into the 1st line of the invoice address which results in the customer name appearing twice in the address. I have come up with...

I have created a report to produce an invoice to cusotmers. A Subreport produces the Invoice Address. Due to human error etc people have entered the customer name into the 1st line of the invoice address which results in the customer name appearing twice in the address. I have come up with...

I have created a query with returns 2,000 records approx from one table. I have created a subreport for each record which is linked to the main report and returns a SURVEY activity and a date. I now want to pass the date value back to the main report using StoreDateVar and FetchDateVar. I...

I am attempting to evaluate date fields and enter "----" is blank or the actual date if not. if year({insurance_details.mtrl_choice_rec}) = 1899 then "----" else if isnull({insurance_details.mtrl_choice_rec}) then "----" else if {insurance_details.mtrl_choice_rec} = Date(0,0,0) then "----"...

numberVar Conversion_Year := tonumber(Mid (totext({insurance_details.complete_by_dt}),7,4)); numberVar Conversion_Month := tonumber(Mid (totext({insurance_details.complete_by_dt}),4,2)); numberVar Conversion_Day := tonumber(Mid (totext({insurance_details.complete_by_dt}),1,2)); numberVar...

I am attempting to retrieve an address from our new database which is stored at address.address_1. All of the address lines are stored in this one field and need to be extracted and entered onto my report so I can suppress blank sections. I have successfully located the separator...