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!

  • Congratulations strongm 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"

    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...
  3. 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?
  4. 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 =...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. ImArchimedes

    Conflicting versions of Crystal Runtime

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

    Odd page size

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

    Supression help needed. Desperate!

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

    Double Sided printing.

    Anyone successfully printed out a report that printed to both sides of the paper? Can you even do that with Crystal
  14. ImArchimedes

    Formulaic print date

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

    Last record formula

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

    CR9 and CR11

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

    Web based CR editor

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

    Keeping a group together.

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

    Replacement formula

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

    Count trouble

    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?

Part and Inventory Search

Back
Top