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

    Nevermind, I figured it out.
  5. 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
  6. 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.
  7. 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...
  8. 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...
  9. bpxmas

    Getting the Percent for each Facility Per Month

    LB, It worked perfectly, thanks so much for your patience and help. Brenda
  10. bpxmas

    Getting the Percent for each Facility Per Month

    LB, So I shouldn't use Running Totals to get Patient Counts for each month? When I use the formula above for each month I get 0.00. Maybe I'm not understanding where I should place each monthly formula. I appreciate your help. Thanks again.
  11. bpxmas

    Getting the Percent for each Facility Per Month

    ...IN Date (2010, 01, 01) to Date (2010, 01, 31)) THEN Count ({cus.Facility}, {cus_resenc;1.Facility}) / Count ({cus_resenc;1.PatVisitCount}) * 100.0; I've tried everything I can think of to get the percent. Any help would be greatly appreciated. Thanks in advance for your help.
  12. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    I exported to Access 2007
  13. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    These are the options for exporting in CR: Acrobat Crystal Reports HTML 3.2 HTML 4.0 MS Excel 97-2000 Ms Excel 97-200- (data Only) MS Word ODBC Record Style (columns no spaces) Record Style (columns with spaces) Report Definition Rich Text Format Separated Values (CSV) Tab Separated-Text Text XML
  14. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    When I do an 'Export' from Crystal Reports v10 all my data is in two columns - it's continuous. What I'm trying to accomplish is after the last field for the first Patient I want to be able to use a formula to cut the field names & detail for Patient2 to Column C & D. Does this make sense...
  15. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    I'm in Sheet 2 and when I put the formula in A2.....it says FALSE I need my field (table) names to go down not across A1 Company A2 Patient Name A3 First Name etc Thanks.......
  16. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    Okay, thanks for your time and expertise.
  17. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    I'm still having problems. Let me tell you exactly what are in the columns. Column A has all fields Column B detail of Patient Company Name Houston Patient Jones, Tom First Name Tom Middle Name Last Name...
  18. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    I'm sorry I have a question do you want me to name the the first column 'allname' and the second 'alldata'? That's what I did see below. 3) I put the formula above in C2 A B C allnames alldata Company Name Houston formula(C2)...
  19. bpxmas

    Move Excel Informtion to Columns Side by Side by Patient

    Hope the formatting below describes what I want to accomplish. Horizontal side by side. I want each new 'Patient' instead of appending to the same Col A & Col B input of each new Patient goes to the next to columns. Patient 2 Col C & Col D, Patient 3 Col E & F, etc. There are about 50...

Part and Inventory Search

Back
Top