Search results for query: *

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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