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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.