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 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: *

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

    Crystal Reports v10 - Have multiple facilities in my Control & if 0 doesn't pull errors out

    Crystal v10 I have a report & I need to be able to select multiple facilities. I created a Control Type 'Select Facility' Name 'Facility' and checked 'Allow Multiple Selection' as well as 'Enabled' When I chose multiple facilities it says 'No data for report' if there is one facility...
  2. bpxmas

    Crystal v10 I have a report & I

    Crystal v10 I have a report & I need to be able to select multiple facilities. I created a Control Type 'Select Facility' Name 'Facility' and checked 'Allow Multiple Selection' as well as 'Enabled' When I chose multiple facilities it says 'No data for report' if there is one facility...
  3. bpxmas

    Control Type Select Multiple Facilities & won't pull multiple is I select more than one

    Crystal v10 I have a report & I need to be able to select multiple facilities. I created a Control Type 'Select Facility' Name 'Facility' and checked 'Allow Multiple Selection' as well as 'Enabled' When I chose multiple facilities it says 'No data for report'. If I select one facility at a...
  4. bpxmas

    Centricity v10 I need to create

    Centricity v10 I need to create a formula in a Crystal Report to find the current age from two date fields: Today BirthDate 10/19/2012 10/04/1993 Age 19 Can anyone help me, thanks in advance
  5. bpxmas

    Formula in Crystal to find age

    Centricity v10 I need to create a formula in a Crystal Report to find the current age from two date fields: Today BirthDate 10/19/2012 10/04/1993 Age 19 Can anyone help me, thanks in advance.
  6. bpxmas

    Excel - Change number in a column

    I want to be able to change the 'Unit Price' 2200 to '123' if it's a Sedan for the entire column. Example: Col Col Col A B C Sales Person Car Type Unit Price Smith Sedan 2200 Jones...
  7. bpxmas

    Multiple Records In One Group

    Crystal 9 I'm creating a Crystal report grouped by TicketNumber. So all the codes below are in the same TicketNumber. I've tried grouping by Code as well. There can be multiple records for one code (see below) 21857 21857 21342 63427 I want to add the $ for both records that have the same...
  8. bpxmas

    Getting the Percent for each Facility Per Month

    I'm working with Crystal X, I'm fairly experienced with the program itself. I have a monthly report grouped by Doctor & Facility for Patient Visits for each Doctor. The total visits for each month are calculated in 'Running Totals' in the Facility Group Footer which works perfectly. I have...
  9. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    I have a report I exported from Crystal v10 into Excel. There are two columns A and B in Excel with ongoing data. I need to separate the data by Patient and place them in the next two columns C and D, etc. As you can see below the column names are 'Patient' and 'Patient Detail' Col A...
  10. bpxmas

    IF and or Function

    I'm trying to write a function to do the following: if total hours are >=40 then only total = 40 but if there are 38 then total = 38 =IF(SUM(J338:J365)>=40,40),(SUM(J338:J365)) Hours 10 10 10 10 Total 40 Hours 5 5 5 5 Total 20 I can get it to work for one or the...

Part and Inventory Search

Back
Top