Is there a way to check if a given time is within a time range? Furthermore, is there a way to check if one time range, at any point, overlaps another time range? I don't need to extract when it overlaps. I'm just looking to track conflicts for work being done.
Example:
10:00am - 1:00pm
check...
I really don't know what section to post this in but it's been bothering me for quite a long time.
I'm the closest thing to a Crystal specialist in my office and I've got about 10 licenses of Crystal XI installed on different boxes. They're all installed with the same version and are all on XP...
Is this possible? I was looking through functions and scowering the internet looking for this and no luck. To give you a better idea of what I'm looking for, here's an example.
Say I want to print field_1 going left to right when field_2 = "L2R" and top to bottom (270 degrees) when field_2 =...
Can a number variable such as 1 and 42 be converted into "One" and "Forty-Two"?
I place this question in the Formula section because I can't go into "Format Editor" --> "Number" Tab and set the field to some sort of number-to-text variant. The "totext" function in the formula editor, as you all...
So, I have a field in a table that is a number of values concatenated together, delimited with "!"'s. These values are actually school ids. At the beginning of my report, I have a formula that takes that field and pulls out the individual ids and drops them in their own shared variables.
At...
I'm trying to create a truely dynamic parameter field but CRXI doesn't seem to want to let me.
What I want the parameter field to do is pull values from a given field to populate the values in the parameter but it needs to change dynamicly. If I choose static and pick a value field, it will...
Some of our standard reports come up with this message when I open them in CRXI.
"This report uses an invalid printer. The default printer will be used instead."
I can't see any differences between how these errored reports are set up compaired to the ones not getting the error. Also, all I...
Working with a report and added a few new tables to it. One of the fields I'm pulling in is a Date/Time field in my database but, when I look in crystal, it only sees it as a Date field. If I create a new report just to test with only that table and I look at that field, it's correctly a...
Our app uses Crystal Reports 11 and a few of our customers are getting "Logon failed" errors when executing reports. We've found that these customers seem to be users who have another app that uses Crystal Reports 8.5. In particular, it's an app called Sis Fin. Doubt anyone has had troubles with...
Customer is printing out labels using a special labeler. The card is not part of a full page for printing. It's just 3.8 x 2.63. How do you print to odd sizes like this with CR 11?
Finished report creation from scratch and one of my fields is now suppressed that shouldn't be (report foot). I right click to unsuppress and it says it isn't suppressed. Preview shows it suppressed though. If I add a second footer, it's created with the same problem. There is no suppression...
So, I've written a formula to determine age of a person. The only piece I'm missing is the current date to run against the date of persons birth. I know how to pull the printdate field into a report by it's self but does anyone know how I would pull that into a formula? Thank you for your help.
Is there a function to pull in a value from the last record of a detail band?
Here's a little background incase I'm approaching this wrong.
I'm pulling a number of odometer readings into a report in the detail band under a grouping by vehicle. I'm trying to pull in the difference between the...
A user of mine has CR11 installed with our app and CR9 installed for another reporting program. When we try and run a report now, they get a "Log in" error along with other random errors. These two ver. obviously don't play well together yet I know CR7 and CR11 do. Is there a fix for this that...
Does anyone know of a dumbed-down CR editing app? Web based would be preferred, something just for moving or resizing fields and/or adding simple tables. There would be nothing formulaic about it. Does anyone know if such a thing would even be possible?
My customers are far from savvy enough to...
This question I promise I can't find the answer to. Say I have a grouping by Driver name. We have info pulled into Group Header, Details, and then Group Footer. If the page ends in the middle of a group, the group will be broken up between the two pages. Is there a way to keep the group together...
Having trouble with the output for one field. The table field {Trip.School} stores a number of school codes, usually one or two. The output for this field is odd though. Say there is only one school associated with this trip, the output for that school, say it was "RHS", would be "RHS!". If...
If I have a formulaic count like the one listed below,:
count({student.name})
how would I formulaicly say only count these students when @totaltime>=45? Any ideas?
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.