Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. djieon

    Excel CountBlank 2 Cells at once

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

    Excel CountBlank 2 Cells at once

    @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?
  3. djieon

    Excel CountBlank 2 Cells at once

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

    pass values between groups

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

    pass values between groups

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

    Pass values from different details sections to a field

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

    Pass values from different details sections to a field

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

    Pass values from different details sections to a field

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

    Pass values from different details sections to a field

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

    Pass values from different details sections to a field

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

    Pass values from different details sections to a field

    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","...
  12. djieon

    Pass values from different details sections to a field

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

    Insert Number of Excel rows based on a column

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

    Scheduled Task - Object 91 Error

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

    Windows Scheduler - Object 91 Error

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

    Caller ID on digital phones

    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?
  17. djieon

    Join two fields and one time

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

    Caller ID on digital phones

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

    Caller ID on digital phones

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

    One lamppost from each street

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

Part and Inventory Search

Back
Top