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 TouchToneTommy 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: TiggerMom
  • Content: Threads
  • Order by date
  1. TiggerMom

    Sum using multiple conditions

    I need to create a formula that adds up all the DosageAmounts for a PatientID by DrugName. My report is grouped by DrugName. I want the report to look like: GROUP: DrugName GROUP: DailyDosageGrouping (0 mg - 10 mg, >20 mg) DETAIL: PatientID#43 DosageAmount 10 mg (supressed)...
  2. TiggerMom

    Nested if-then-else formula won't display everything

    When I use the following formula, only the first "if" is displayed in my report while the remaining 3 if pieces are not displaying anything. I am using this formula to create a grouping level in my report. When I change the order of the 4 if sections, only the first if section displays...
  3. TiggerMom

    Sorting Groups

    I have a report that has two groups in it. The data is grouped by Agency then by StaffLastName. My problem is that the order of the staff is coming out wrong when I have two or more staff with the same last name. For example the group output comes in the order of: Smith, Sandra L...
  4. TiggerMom

    Using an existing report as a base for a new report

    What are the quirks when I copy an existing report and name it as a different report so that I don't have to start from scratch? For example, I copied an existing report then added some tables to it but when I look at the report's SQL statement only the new tables are being recognized. I've...
  5. TiggerMom

    Crystal 7: Verify Database

    I am running Crystal 7 with Service Pack 1. I use SQL 7 tables for my backend. I have a report with subreports in it. The primary report and the subreports use stored procedures to access the table data. After I have created the subreport, if I make changes to its stored procedure and then...

Part and Inventory Search

Back
Top