Greetings!

We are working on a VB.NET system that prints out a report (Crystal Reports 8.5) containing a long list of columns. This report, when all columns are shown, will take up more than a page's width to display.

The problem we have is that sometimes, the user only needs certain columns from the report, or sometimes even choose which columns are to be printed out.

We have seen tips about setting the column as hidden, but it doesn't adjust the width to avoid blank columns.


Say we have a report that can print out the columns:

[ A B C D E F G H I J K L M N ]

sometimes, the user only chooses specific columns, like so:

[ A E F G H I J N ]

The solution we found in another site displays:

[ A       E F G H I J       N ]

Is it possible to hide columns and have visible columns take the place of the hidden ones?

Or is there a way to actually create the report at runtime, adding the fields needed then?


Thanks very much!