Search results for query: *

OK Thanks Pete-that seems to make sense of what I'm seeing. Excel it is!

Thanks kray4660, I tried that but it;s looking for a numeric value for the else clause. I want it to either return the numeric value if it is only numeric and the alphanumeric if it is alphanumeric.

I'm having a strange sort of day and my mind is jumbled. I haven't posted here in years but always got the help I needed when I have posted. I'm hoping for some help again. I'm sure on any other day the solution would come to me but it's just one of those. I have a field which is stored as...

COSpringsGuy Thank you! That actually makes a lot of sense. I tried it out and so far so good!

Thanks Charily. I have not used shared variables yet but do remember coming across a section on them in my CR Reference Guide. This is something I'll have to brush up on. The basic idea is to have sub reports pass their results to the main report right?

Agreed

Thank you SkipVought! I do have access via ODBC to the Oracle DB. I like this solution a lot.At the same time, I would love to hear how someone would go about doing this in CR. I think your solution is great for an immediate result. At the same time I want to be able to learn new CR skills...

Hi SkipVought, we are on Oracle 11g

Any CR Gurus out there who can explain how to do this?

Okay Thanks SkipVought, So what I hear you saying is that this cannot be done in Crystal Reports? Or that you think it will be easier to simply export data only and run a Pivot in Excel? If there is a way to do this in CR it would be helpful to learn it so I can gain those skills when needed in...

Thanks SkipVought, That is similar to what I'm doing now but to get this by truck for 678 trucks is quite a chore in excel since I need to also subtotal the total hours for each truck. I am hoping to be able to use Crystal to do most of the work.

Right, as I said, we're working on that part of it. It appears to be a glitch in the app on the tablets which is double time stamping the status updates. In the meantime I still need to figure this out.

I'm needing to calculate the amount of time that our company trucks are being actively used based off of the driver's actual login times from the dispatch software on their tablets. The problem is the database seems to have multiple records for each time status. I'm not sure why but in the...

I have a report in which I am currently grabbing data in excel and creating a pivot table. I want to be able to skip the pivot table step by using a CR crosstab report. In my rows I have employee IDs . My column is a referencing a formula showing how many of their tickets they have resolved...

I have a report in which I need to round timestamps to the half hour so that anything between 00 minutes and 29 minutes round to the hour and anything between 30 and 59 minutes round to the half hour. So, for instance, 12:00 - 12:29 are in the 12:00 time slot, and 12:30-12:59 are in the 12:30...

I tried: len({field}) = 10 and not numerictext(left({field},1}) and numerictext(mid({field},2,2)) But it resturned an error about having too many arguments. However, when I tried again it seems to have worked. So i think I've got it. Just need to validate that it is working as desired now.

one more quick question, I'm getting conflicting reports about whether the text is case sensitive. so in your example above, if chacter 1 must be a letter but case is not important, how do you validate that it is indeed a letter(case agnostic) and not a number?

Thank you both (Madawc & Charliy)- I had completely forgotten about numerictext!

Good Lord please tell me I can edit my poor typing in this thread! I don't see an edit button.

How would I go about validating data in a field? For example, I have a field which stores an alpha-numeric value entered by a technician that must match a given format (10 digits long, letters & numbers in certain places within the field, etc.). So an example would be x56kBy67G0. This data...