Recent content by djieon

thanks for the replies...im happy to make it a date time cell if that makes it work?

@RobertPhillips Thanks for looking at this for me....yes the end date could be in the next day...that was going to be my next thread! :-) Any ideas?

Hi All, I have an excel sheet where I want to have a time from cell and a time too cell and want to automatically work out the duration. IE Time From 08:20 Time To 09:50 Duration 01:30:00 I have worked out how to do the duration using the formula:- TEXT(F5-C5,"h:mm:ss") However I want...

Hi LB, The main job and sub job number is a different field...does that make a difference?

Hi all, I have four pieces of data Main Job Number Sub Job Number Estimated Value Invoiced Value So the main job number always ends in '0' (EG 123456/0) and on the main job the estimated value is stored However all invoices are raised on the sub jobs... (EG 123456/1, 123456/2 etc...) I am...

Cheers Pete, now getting some values coming through...however is there a way I can make it work if I put the values in the page/report header? Thanks in advance...

Hi Pete, have attached the file... I have tried to create the formula invoice number but as you will see im not getting a result from the formula. Cheers David. http://files.engineering.com/getfile.aspx?folder=b64efdde-4395-4186-8895-86a2cf00e561&file=dji_vixen_invoice_v102.rpt

So the database is called 'command' but when I try using {command.printLine} as the field name it goes through but on the preview the field is blank, is that because of the time it is processing the formula at? Even adding in WhileReadingRecords; its still showing with no values inside the...

Hi Pete, sadly its not working for me. I am using the following:- if RecordNumber = 21 then mid({PORTRAITINvixtest_csv.printLine},23,6) I am getting 'this field name is not know' Does it matter we are changing the .csv for a _csv

Hi Pete, 1. No the csv is always 1 invoice only. 2. its creating a details record for each line of that csv file, so there will always be 57 details records to one invoice. 3. I am led to believe that that it will always be in the same place, so will always be the same number of characters into...

Hi Pete, here is one invoice from my csv file lineType,boldType,printLine,companyNo "LARGE","BOLDOFF","","01" "LARGE","BOLDOFF","","01" "LARGE","BOLDOFF","","01" "LARGE","BOLDOFF","","01" "LARGE","BOLDOFF","","01" "LARGE","BOLDOFF","","01" "LARGE","BOLDOFF","","01" "LARGE","BOLDON","...

Hi All, thanks for looking at this thread. I have a report that uses a csv file as its database, unfortunately the csv is already formatted which is rubbish, but I cant get that changed. With that in mind is there a way that I can create a formula/field to show me the value for something along...

Hi all, I have an excel sheet that looks like the following:- Acacia Avenue2 Beech Street6 High Street10 What I want to be able to do is create a worksheet that creates 2 rows for Acacia Avenue, 6 rows for Beech Street, and 10 for High Street Is this easy to do? If so how!?!? Thanks in...

Hi all, I am trying to trigger a batch file from a scheduled task. The batch is on the root of C drive and the file contains:- "C:\Program Files (X86)\Ganieda\Ganieda.exe" dial When I double click the batch files on the screen in command prompt comes up c:\>"C:\Program Files...

Hi all, I am trying to trigger a batch file from a scheduled task. The batch is on the root of C drive and the file contains:- "C:\Program Files (X86)\Ganieda\Ganieda.exe" dial When I double click the batch files on the screen in command prompt comes up c:\>"C:\Program Files...