I know that I can use a union query to add blank rows to a report to fill a printed a page.
This method works as far as there is no grouping and sorting in query.
As soon as I add a group to the report, the blank lines are printed on a separate page.
Obviously, because the rows that union query reads from a temporary table and adds to the record source of the report are blank.
And they are counted as a new group, hence a new page.
As a simple example, let's assume I have the following:
This works until there's no grouping in the report.
Now my question:
How can I add blank rows to a report that is grouped by one or two fields. (In my situation CustomerFK)
Any kind of advice is appreciated.
This method works as far as there is no grouping and sorting in query.
As soon as I add a group to the report, the blank lines are printed on a separate page.
Obviously, because the rows that union query reads from a temporary table and adds to the record source of the report are blank.
And they are counted as a new group, hence a new page.
As a simple example, let's assume I have the following:
SQL:
SELECT 0 As Expr1,OrderedPartsPK, RecID, Ordered_Part, Quantity, CustomerFK
FROM tblOrders WHERE Delivered=0
Union All SELECT Top 2 Expr1 AS OrderedPartsPK,
'', '', '', '' FROM tblReportDummy Order By 1, 2
This works until there's no grouping in the report.
Now my question:
How can I add blank rows to a report that is grouped by one or two fields. (In my situation CustomerFK)
Any kind of advice is appreciated.