Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Paginated Report

Good Morning!

I am trying to create a paginated report of orders to replace a Crystal Report.  There are two input tables but both tables are being selected in one query.  One Oracle table has good orders and another Oracle table has errors.

The user wants to see the order data on one line and the error data on the line following it and with fill of grey.

I can't figure out how to insert the error line.  I have tried inserting a second table after the first table but that just displays the second table after the first table.

I tried adding an error column to the right of the good order column but it makes the report too wide.

The attachment shows the Crystal Report with the error on the grey shaded line.

Any advice would be greatly appreciated.  Or links.