Search results for query: *

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

Hi, yes have set the password to 1234 in the portable extensions settings... When would be good for you to get on? or just want me to send the dsys file to you?

Hi all, I am trying to create the following in Crystal Reports xi JOINS between tables RM_COMMON_ATTRIBUTES.EASTING >= CFG_MAP_REGISTER.EASTING_BLC RM_COMMON_ATTRIBUTES.EASTING <= CFG_MAP_REGISTER.EASTING_TRC RM_COMMON_ATTRIBUTES.NORTHING >= CFG_MAP_REGISTER.NORTHING_BLC...

Hi OBT Systems! Thanks for the response. Just what I needed as was trying everything for a few hours last night but without any joy. Don't suppose you are around tonight? Do you remember you logged onto my exchange via teamviewer three years ago now because the clock chip was not working, well...

Hi all thanks for looking at this post. I have a KX-TDA15 which has a CLI card in it. our incoming lines are analogue which go into a BRI card I believe (though I could be wrong) one line is named 'admin' and one is named 'box office' When people dial in from outside the building it comes up...

Hi all, I have a report that has the following:- Group header 1 - @random (based on the random formula) Group header 2 - Street name Details - Lamppost what I want to achieve is 40 random lamp posts but only 1 lamppost from each street, however currently I am getting 40 random lampposts but...