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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ReportGuy

  1. ReportGuy

    This field cannot be summarized

    Crystal Report 9.0, against an DB2 database. I'm working on an SLA compliance report, where I need to sum the amount of time a person owned a ticket. I'm using two tables, one table identifies the ticket as belonging to a group, and another table keeps tracked of the duration of time each...
  2. ReportGuy

    Exporting Report and the Destination Drop Down

    That was it. Her file was only 28k, I replace it with my at 48k - and all is well!! Thank you. I've also made a note of the Runtime.chm. I've been looking for a Crystal dll reference.
  3. ReportGuy

    Exporting Report and the Destination Drop Down

    I have a user running CR9, and when she tries to export a report her Destination called Disk File is missing. I've reinstalled Crystal (with the Re-install option) and that didn't replace the option. I've checked out http://support.businessobjects.com, but wasn't able to find a solution. I think...
  4. ReportGuy

    If then Else Statement

    Both of these worked. Thank you so much!!!
  5. ReportGuy

    If then Else Statement

    Crystal Designer 9 Database: Xtreme Sample Database 9 I'm having an issue with an "if then else statement" in one of my reports. The problem is when the YearHired doesn't equal 1991, it doesn't get evaluated. I recreated the formula using the Xtreme database, and I'm still having the problem...
  6. ReportGuy

    Displaying Blob Fields in an Informix dbase.

    Database: Informix Report Version: Crystal Reports 9.2.2.693 ODBC: CR Informix 9 Issue: I'm unable to display a blob field on a report. I can add it to the details section, but all the records come back empty. Is there a sql expression that will allow me to get around this issue?
  7. ReportGuy

    SQL -255 E

    I'm running Crystal Reports 9. I have 5 description fields that I need to string together. From a performance stand point, I thought using a SQL Expression would be best. I have two work arounds: 1. Build a formula, and CONCAT the 5 fields together. 2. Drop the fields into a text object...
  8. ReportGuy

    SQL -255 E

    Software: CR9 Database: Informix Driver CR Informix 9 I'm using the Remedy database (version 4.5), and in order to get around a blob field issue, we broke a memo field into 5 text fields. When I try to "CONCAT" the fields together using a SQL Expression, I receive the following...
  9. ReportGuy

    Formula Bold function, and subscripts

    Hey all,I have two questions. 1.I'm running CR8.5, and I built a formula and I would to bold certain words and letters within the formula. I know I can build multiple formulas, and place them on the report within Design View and bold them, but I would like to do it within a single formula. I...

Part and Inventory Search

Back
Top