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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sjjcat

  1. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Ok, last question. The first formulas created a value of 1 for each record. But now I have the number of days a patient stayed in hospital. How would this get created in the sub report? This doesn't work - it generates a value of 1. //@Mth01 whileprintingrecords; shared datevar Mth01start...
  2. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Ok, I got it! I created another formula //@resetoct to be placed in the subreport header: whileprintingrecords; numbervar sumoct := 0; And it all works. LB - thank-you so much for all your help - it is very much appreciated! Sue :)
  3. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Thanks again. I got that working for the footer but now I want to add a group, and of course if I use that same formula then it does not work as it displays a running total up to the group. Should be Group 1 10 10 Group 2 15 5 Group 3 20 5...
  4. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Oh, I see why it can't be summed, because it is not a value available in the sub report - it is only in the main report.
  5. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Thank-you. I got the values of 1 to appear on the report, and now I can see why my summary won't work. It wont let me sum the detail values. I tried to create a new formula: //@OctSum sum(@10Oct) but it says the field cannot be summarized. How would I add up the 1's now they are in the...
  6. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Hi, thanks again. I am also attempting to summarize my field. But when I place it on my report in the details section it does not appear as 1. I started a new report and did the following: Main Report //@SetDates beforereadingrecords; global DateVar OctStart ; OctStart := Date(2004,10,01)...
  7. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Hi LB, thanks for the reply. I changed the formula in the main report to: //@SetDates whileprintingrecords; shared DateVar JanStart ; JanStart := Date(2004,01,01); But I still receive the same message in the sub report: A summary has been specified on a non-recurring field. Details: @01Jan...
  8. sjjcat

    Sub Report shows month by month, Main report stores DateVar

    Hi Crystal XI, SQL DB I have 10 sub reports for a set of reports to show monthly patient data (Scary I know) Jan Feb Mar Apr etc SR1-Admissions SR2-Discharges SR3-PatientDays SR4-Newborns etc I use sub reports because the data qualification in each may be 'slightly'...
See more

Part and Inventory Search

Back
Top