olyncircle Posted April 20, 2023 Share Posted April 20, 2023 I have a table in the first half of the page and I want to print the same table in the second half of the page.I tried adding two detail bands but I can't put a separator between the two bands. Link to comment Share on other sites More sharing options...
Solution jgust Posted April 22, 2023 Solution Share Posted April 22, 2023 You cannot display data twice unless it exists twice.What you can do is update your dataset and UNION the results to itself. During that process, you may want to add a hardcoded column like REC_TYPE to help you identify where the data should print.select 'top' as REC_TYPE, field1, field2 from My_Tableunionselect 'bottom', field1, field2 from My_Table [/code] Link to comment Share on other sites More sharing options...
olyncircle Posted April 24, 2023 Author Share Posted April 24, 2023 Is this possible for multiple pages? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now