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

    Time Range check

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

    Join Type: "Left Outer Join" + Enforce Join: "Enforce From"

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

    Join Type: "Left Outer Join" + Enforce Join: "Enforce From"

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

    CR 11.5 and Dot Net 3.0 ?

    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?
  5. ImArchimedes

    Formulaic text rotation?

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

    Formulaic text rotation?

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

    Remove Decimal

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

    Formulaic text rotation?

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

    Number Formatting: "1" = "One" and "12" = "Tw

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

    Number Formatting: "1" = "One" and "12" = "Tw

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

    Number Formatting: "1" = "One" and "12" = "Tw

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

    Ignore previous years Value

    Let us know how they work for you.
  13. ImArchimedes

    Ignore previous years Value

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

    Number Formatting: "1" = "One" and "12" = "Tw

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

    Linking a table to a shared variable. Possible?

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

    Linking a table to a shared variable. Possible?

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

    Dynamic Parameters values?

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

    "This report uses an invalid printer. The default printer..."

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

    CRXI Getting wrong data type

    That was it. Thank you very much, LB.
  20. ImArchimedes

    CRXI Getting wrong data type

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

Part and Inventory Search

Back
Top