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 Wanet Telecoms Ltd 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: *

  • Users: mrshardee2
  • Content: Threads
  • Order by date
  1. mrshardee2

    Printing Selection Criteria on a report.

    I have a report in Crystal 8.5 that shows Anesthesia Types selected by Anesthesiologist, OR Suite, Patient Type, etc. I would like to show in the footer of the report the criteria that the user selects to print the report. The only parameter that I can get to print on the report is the...
  2. mrshardee2

    Migrating Btrieve data to SQL 2000

    I have been assigned to migrate an old btrieve database to SQL 2000 and I have no idea where to start. I do know that there are programs on the market that will do this for me, but they are not cheap. Does anyone have any experience in this? Would I be better off purchasing a package product or...
  3. mrshardee2

    Pulling first occurence from Database

    I have a field entitled "UOM" that I am pulling into Crystal 8.5 from an SQL2000 database. This UOM could be Box, Each, Case, etc. How do I tell Crystal to only choose the first instance for each item number? For example, if the first UOM for Item 37495 is Box, select only that instance. Any...
  4. mrshardee2

    Choosing unit of measure

    I have a field that I am pulling into Crystal 8.5 from an SQL2000 database entitled "UOM". This UOM could be Box, Each, Case, etc. How do I tell Crystal to only choose the first instance for each item number? For example, if the first UOM for Item 37495 is Box, select only that instance. Any...
  5. mrshardee2

    TRIM Function

    I have the following field that I am pulling into a report (Crystal 8.5): /O=srmc/OU=SRMCNTNET/cn=Recipients/cn=Hunt36 I want to trim the field to only show what is after the 4th "=" sign. Seems like it should be fairly straightforward. Any help would be appreciated. Thanks! Amber [peace]
  6. mrshardee2

    Combining AD and AS400 data

    I am trying to pull data from our payroll system (AS400) and from our Active Directory on our Windows 2000 Server into a Crystal Report that lists all employees with their department and phone number. I have the users updating Active Directory with Galmod32. Has anyone linked these types of...
  7. mrshardee2

    Converting a number to a date

    I have a number field that I am pulling into a report from an AS400 database. The field is 3-4 digits for the month and day (Jan 14 = 114, Nov 23 = 1123). How can I convert this to a date field in CR 8.5 for reporting purposes. It seems like it should be so easy... Probably will be for you...
  8. mrshardee2

    Blank page printing before data

    I have a report in Crystal 8.5.3.975 that is printing a blank page before any data starts showing. I cannot figure out why! I have two group headers, both formatted with 'Free-Form Placement', 'Keep Together', and 'Suppress Blank Section' checked. All data is showing correctly, I would just...

Part and Inventory Search

Back
Top