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

Part and Inventory Search

Back
Top