Hey everyone,
as I am pretty new to this stuff, please excuse, if this topic has been covered in any other post.
I am designing a report right now, which work quiet well. Yet I am having the problem, that I have so many columns, that the reports exceeds the page size in landscape mode. Now that the number of my rows is limited to 12 (yes - months) I am asking myself, if it is possible to transpose the table I am using to build the report.
Is there any easy way to transpose tables, used in reports?
Thanks in advance!
Hello Timmy,
Thank you for your post!
I have been looking into it. What I can suggest is to create one table and delete the columns that are not visible. Then create the same table again, place it under the first table and delete the columns that are already present in the first table. Between the two tables you can place a page break(you can find it in the toolbox). Setting a page break between the pages would print then in separate pages when the report is printed.
I have created a small sample application for you to show you the above mentioned approach.
Please find the attached sample application and feel free to let me know if you have any further questions on this matter.
I am just checking if you have any further questions on this matter. Please do not hesitate to let me know if you do.
Hey,
I had no time to check yet, sorry. But I will take a look this evening.
Many thanks!
Regards,
Timmy
Thank you for the feedback. Please do not hesitate to let me know if you have any further questions on this matter.