Subject Re: Report problem
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Sun, 21 Aug 2022 02:10:26 +0530
Newsgroups dbase.getting-started

Good Morning Charlie,

> I wrote this report some time ago when I was first learning so that may be the problem.
 >
> But I have a table which has 26 rows.  The first page of the report shows  23 rows.  I was expecting the other 3 rows would appear on the second page.  But they don\\\'t.  Only the summary shows on the second page.
 >
> The detail (pink) shows 23 rows in the form designer and under that it appears to be the streamfraime which is yellowish.  I see no way to pull the detail band down over the streamframe to increase the rows on the first page which would solve my current problem.
 >
> I was wondering if there might be somewhere I can go in designer to increase the number of rows on the first page.
 >
> Any ideas?  I will attach the program code that this involves.
 >
> Thanks much for any suggestions.
 >
> BTW I have been running this report for years, but this may be the most rows I am trying to print so far.
This is a very strange issue. I have faced issues (first row being
printed a number of times) but that occurred for just 1 particular set
of data. If I changed the filtering the issue would disappear. So never
posted it. Just changed the sql.

I would love to run the report and check but I do not have your table.
Can you post a empty table (A table with junk data would be much more
helpful).

I am viewing the code (I have rarely examined my own reports so just
blind shots) and have found certain possible scenarios

1. Size of paper being used is shorter than the size fed into the
report. To check this place page numbers at the bottom of the page and
see if they are being printed or not.

2.Line numbers 149-154 There are 2 groups being declared but only 1 is
being used.
this.STREAMSOURCE1 = new STREAMSOURCE(this)
    this.STREAMSOURCE1.GROUP1 = new GROUP(this.STREAMSOURCE1)
    this.STREAMSOURCE1.GROUP2 = new GROUP(this.STREAMSOURCE1)
    with (this.STREAMSOURCE1.GROUP2)
       headerEveryFrame = true
    endwith

The line most crucial is missing. Group by clause.

3. Please delete Line number 731,732,740,748,749 or other similar lines.
Control will never reach those lines.

4. If you have doubts on altbandcolor then comment out lines 237-243
(Please take a backup beforehand you try this). It should not be causing
errors. But since commenting and uncommenting will not take much time
hence worth a try. I never saw this before (like lots of code in duflp)
so I have never used it. I print horizontal lines after 3 rows.

Other than that I do not have anything else to say at the moment.

For debugging I would start with say 10 rows in the report, print it to
  a pdf (Why waste paper when you get the same result) and view the results.

Add 1 row and repeat the process. Always check for the last line of the
footer.

Once report requires 2 pages add 4-5 rows at one go and check how many
are disappearing.

Hope something helps.

Regards
Akshat