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 Mike Lewis 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. JulieWard

    Problem with Headers.

    Also, the reports I am using were created in 8.5, and are being refreshed in 10. Maybe that has something to do with it??
  2. JulieWard

    Problem with Headers.

    I recently upgraded to Crystal reports 10 and I am having this same problem. I never had this problem with 8.5, when it exported, my column headers expanded. But now, with 10, for example if the column header is called "Full Name" but in the report it is narrowed where only "Full" shows up...
  3. JulieWard

    SHOW Blank records

    That seems like it might work. . . if I can identify the most recent record and supress the others.
  4. JulieWard

    SHOW Blank records

    The purpose of the report is to show all the providers in our database who have blank or expired insurance so that we can obtain updated insurance. The provider can have only archived records in the insurance table and still be active in the provider table. There is only one record per...
  5. JulieWard

    SHOW Blank records

    Sorry, I forgot: The archived tables are not separate.
  6. JulieWard

    SHOW Blank records

    We have a field in both tables (the provider table AND the insurance table) that indicates Active or Archived.
  7. JulieWard

    SHOW Blank records

    For Example: Dr. A has 2 insurance's in his record. One is archived, one is active. Dr. B has 1 insurance in his record, and it is archived. If I supress archived records, I'll supress Dr. B's record completely. If I am able to mark the archived records then Dr. B's record would show as...
  8. JulieWard

    SHOW Blank records

    Yes, sorry, the malpractice is the insurance table. I'm using the "record number" field to link the tables, and I'm using a "left join". I had a record selection to remove all the archived records and I removed that and my blank records show up in my report. However, I still need be able to...
  9. JulieWard

    SHOW Blank records

    I've done that, and it works if only one field in the table is blank. If that particular records entire malpractice table is blank, he will not show up in my report.
  10. JulieWard

    SHOW Blank records

    I want to create a report in Crystal that pulls blank or expired insurance information from our database. The insurance information is held in another table from the "main" provider information. The problem is, when I pull the insurance table into the report, if the insurance information is...

Part and Inventory Search

Back
Top