I have an object data source that looks a bit like
ThingData
Location
ThingName
ThingId
SummaryData (List)
SummaryA
Field
Field
SummaryB
Field
etc.
I have grouped by 'ThingId' and I have added List to the detail section of the of the Report. The List DataSource is set to SummaryData.
In the List I can use SummaryA and SummaryB fields, everything is fine.
In Print Preview (and Export) however, there is always a page break before each List, even though it could fit on the preceding page. It works fine in the standard view.
I searched this forum and found references to this being a bug due to be fixed, that post was in 2013. Looking at other options:
- Grouping: I don't think I can group unless I flatten my data
- SubReport: This would mean a SQL call for each SummaryData row, which I want to avoid
Anyone have any suggestions? Thanks.
ThingData
Location
ThingName
ThingId
SummaryData (List)
SummaryA
Field
Field
SummaryB
Field
etc.
I have grouped by 'ThingId' and I have added List to the detail section of the of the Report. The List DataSource is set to SummaryData.
In the List I can use SummaryA and SummaryB fields, everything is fine.
In Print Preview (and Export) however, there is always a page break before each List, even though it could fit on the preceding page. It works fine in the standard view.
I searched this forum and found references to this being a bug due to be fixed, that post was in 2013. Looking at other options:
- Grouping: I don't think I can group unless I flatten my data
- SubReport: This would mean a SQL call for each SummaryData row, which I want to avoid
Anyone have any suggestions? Thanks.