Search results for query: *

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

It crashes with left outer -> enforce both. You had the same idea I did. Its that left outer I need. For the past few days I've been scowering the web and some say the issue can be due to printer drivers. My drivers are fine though :( I think I'm kinda stuck.

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

I know that Crystal XI is not compatible with Dot Net 3.0. I assume 11.5 fixes this issue. Can anyone confirm this for me?

LBass and CoSpringsGuy, That's actually exactly what I did. Just odd that there isn't a function for that in a formula. I feel alright doing it now though, knowing that others used the duplicate field version to get around it. There should be a better way but this is definitely functional...

It could be in either. If you know a way for it to work in either one or both, I'd be ecstatic.

Just for a little more insight into how that works, if you are interested, here is the function format: totext(variable,x,y) x = The number of decimal places to carry over when converting to text (1=.0 and 5=.00000) y = Character to be used to separate tens, hundreds, thousands (like the...

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

Oops, yeah, I reread and figured it out but never updated my post. Sorry guys. Thanks again.

Hmmm, I'm getting an odd return using that function. I'm running it on a field called "Sequence" which is a Number field. This is a number representing the order something happends such as 1,2,3,4,etc... The formula I'm using is simple. towords({Sequence}) These are the results I'm getting...

Perfect guys. Just didn't know the function existed. Thank you both and, Elsenorjose, thanks for the in depth description.

Let us know how they work for you.

In Design, the report structure would be something like this: ------------------- Person Group Header ------------------- Year Group Header ------------------- Detail Band ------------------- Year Group Footer ------------------- Person Group Footer ------------------- You'll need, at most...

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

UPDATE: I think I actually almost had it but hit a road block. I'm doing the school stuff in it's own sub report and I have a selection formula that for the sub that looks like this: global stringvar school1; global stringvar school2; global stringvar school3; global stringvar school4; global...

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

That was it. Thank you very much, LB.

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