I have a question about the report generator. Is there a way to ask the report generator to move some elements (columns) into a new table and create a new one based on a set limitation on the number of columns there can be in a table?
Here is a little information on what I am trying to do. I read in a series of txt data files from a folder. The number of files can change from 6 to anywhere between 15-20, and the number of files is unknown before runtime (note this is a deployed application). Now when I create a report, when the number of files is between 6-10 there is no problem, but as the number increases, the columns get smaller and the headers get skewed; it affects the look of the report. So I was wondering if there is a way to move some of the data into another table (automatically) based on the number of columns.
Thank you in advance for taking the time to read this message and I would greatly appreciate any response or help.