Subreport Details Not Relaying to Report Preview

[brizaybrizoke]

I am using CR 8.5 with an ODBC SQL datasource.

I have two identical subreports in the Details section of my report that when run separately display all details/line items.
When viewing the preview and when printing not all of the details/line items show up.

I have each subreport formulated to list eight line items per page and start a new page thereafter.

For example, if the query contains 24 lines items, the results should return,
Page 1, line items 1-8
Page 2, line items 9-16
Page 3, line items 17-24

Currently, the results are returning,
Page 1, line items 1-8
Page 2, line items 11-16
Page 3, line items 21-24

My subreport Details sections are formatted as follows,
Suppress (No Drill-Down) (unchecked) // {#OrdLine}<={?Pm-@PrtPage}
New Page After (checked) // if
(ToNumber ({LINE.LINE_ID})/8 = 1) or
(ToNumber ({LINE.LINE_ID})/8 = 2) or
(ToNumber ({LINE.LINE_ID})/8 = 3) or
(ToNumber ({LINE.LINE_ID})/8 = 4) or
(ToNumber ({LINE.LINE_ID})/8 = 5) or
(ToNumber ({LINE.LINE_ID})/8 = 6) or
(ToNumber ({LINE.LINE_ID})/8 = 7) or
(ToNumber ({LINE.LINE_ID})/8 = 8) or
(ToNumber ({LINE.LINE_ID})/8 = 9) or
(ToNumber ({LINE.LINE_ID})/8 = 10)
then true
Keep Together (checked)

{#OrdLine} // Running Total
{?Pm-@PrtPage} // Parameter

My main report Details are formatted as follows,
Suppress (No Drill-Down) (unchecked) // not(onlastrecord)
New Page After (unchecked) // if (remainder ( ToNumber ({ORDDET.ORDDET_LINE_ID}), 8) = 0)
then true else not(onlastrecord)

Please let me know if more information would be helpful! Thank you in advance!

 

[Madawc]

I'm not clear what you're doing. But if you use Suppress, it's not surprising that details do get suppressed.

If I were doing it, I'd put the [New Page] in the subreport, if subreports allow. If not, I'd have an extra detail section within the subreport that would be suppressed unless this is the 8th instance, etc. and made large enough to force a page change.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP