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!

Register Log in
  • Congratulations derfloh 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. Laurelin

    DateDiff seperated by Months

    Oh wow, that looks great. Why is telling me that a Boolean is Required Here? //{@July days}: datevar st := {table.startdate}; datevar end; numbervar jul; if st < date(2011,7,1) then st := date(2011,7,1) else if st >= date(2011,8,1) then st := date(0,0,0) else st := st; if...
  2. Laurelin

    DateDiff seperated by Months

    I am trying to calculate the number of days between two date and show how many days in each month are between the two dates. Example: Start Date: 7/13/2010 End Date: 2/7/2011 I want the report to show me the number of days that are used between those two days by month. Number of days in...
  3. Laurelin

    Setting fixed length to a variable

    I found that you can only use <VBFixedString(18)> only Public variables so that is the route that I used and it is working great. Interesting method you have Andy, I am going to give it a shot as well just to see how well it works. Thanks for sharing that. Appreciate the help!
  4. Laurelin

    Setting fixed length to a variable

    I've looked everywhere to find out to set a variable to a fixed length but I am having no luck. I am using VB 2008. Dim variable as string * 18 - this is the method that most sources say is the correct method to define the fixed length of a variable but this gives me errors when tying this in...
  5. Laurelin

    Editing Text File Output

    Thanks for the help! I've got it working thanks to both of you.
  6. Laurelin

    Editing Text File Output

    I have been tasked with taking a text file and creating a new text file output that has slightly different data based on what is in the original file. I fully understand how to read a text file and write that data to a new text file. What I cannot fully understand is how to read a field in the...
  7. Laurelin

    Calculate mileage between minimum and maximum dates

    It works great. Thank you again Lbass! [thumbsup2]
  8. Laurelin

    Calculate mileage between minimum and maximum dates

    Going to give that a shot, thank you Lbass. I know you are a master at Crystal Reports. I hope someone pays you well for it. :-)
  9. Laurelin

    Calculate mileage between minimum and maximum dates

    A bad entry would be one where way too much mileage was entered. Such as the forth one in this example of the data. If I do a formula using the maximum of that field then I end up pulling the value in the bad data record. UNIT MILEAGE DATE KN5644 34,560 3/4/2008 1:20:56 PM...
  10. Laurelin

    Calculate mileage between minimum and maximum dates

    I wish I had the ability to fix the data issue with this application but we do not own it and all the vendor tells us is "we are considering our options". That has been going on for too long. :/ Is there any method in which I can compare the first and last mileage entries for a unit? If...
  11. Laurelin

    Calculate mileage between minimum and maximum dates

    Oh, I should have mentioned. For some of the units there are some bad mileage entries. I did exactly what you suggested at first but then I realized that there are some bad data entries involved. However the first and the last entry always seem to be correct. It might look like this: UNIT...
  12. Laurelin

    Calculate mileage between minimum and maximum dates

    I am trying to calculate the mileage of a vehicle that has a number of meter entries in a table. What I need to do is pull out the first and last entry in that table and calculate the mileage driven of the unit by subtracting the first mileage from the last. My data looks like this: UNIT...
  13. Laurelin

    String Between Characters

    I have a string of data such as: DOCUMENT 3212 (9) All I want to pull out of the string is the 9. The number will always be surrounded by ( ) There used to be a function called StringBetweenCharacters2 in order to do this. How I would I go about pulling the data out of a string such as this...
  14. Laurelin

    Selecting data based on time

    I have had an issue come up with this report that I have created based off this thread. The report is working great when there is only two transactions per day for a single unit. But if there is three or more transactions for a unit the group selection process is not working as needed. If I...
  15. Laurelin

    Selecting data based on time

    I got it working after a little tweaking but I would have never made it work without your help. Thanks again.
  16. Laurelin

    Selecting data based on time

    I am going to give this a shot. I was wondering if it was even possible! Thank you so much for your help. I will let you know how it turns out. :-)
  17. Laurelin

    Selecting data based on time

    Anything over 8 hours apart I do not want to see on my report.
  18. Laurelin

    Selecting data based on time

    What we are trying to determine is if someone makes multiple purchases of fuel within any 8 hour time period during a day. This keeps them from being able to purchase a large amount of fuel on a given day without it going unnoticed. I could think of a few ways for them to get this information...
  19. Laurelin

    Selecting data based on time

    I am trying to select records from a table based on a couple of time criteria and I have no idea how to go about this using Crystal Reports XI. I need to create a report that shows all the units that have purchases(date/time) within an 8 hour period but not the purchases that occurred within 30...
  20. Laurelin

    Editing a text file?

    Thank you jebenson. You are exactly right, I am getting the right amount of records into my new file now. Much appreciated. :-)

Part and Inventory Search

Back
Top