Hi, can anyone help me with this problem I have with Crystal Reports (using as part of Visual Studio 8)?
I have to create a report which consists of a set of data that is displayed in either 3 column format (down then across) or 4 column format, depending on the number of records in each group.
I have figured out that you can change the width of the detail section so for the 3 column version I can set the columns to 9 and the gap to 0.3 and for the 4 column version I set the columns to 6 and the gap to 3. This works fine if you want either 3 OR 4 columns but I need both to be displayed dynamically in the same report. So, if the current group of records has < 50 rows, then the page should show only 3 columns and if it has > 50 rows it should show 4.
I tried creating a main report with all the page header stuff in it and two sub reports in the details sections of the main report (I added two details sections) but I found a problem with this because I had to set the width of the detail section of the main report to fit the largest size (4 columns) which seemed to override the individual sub reports sizes and displayed the 3 column sections squashed up as if there were extra columns that just weren't displayed!
It may help to explain that the purpose of this report is to allow the person reading it to fold it over into three most of the time (to make it easier to read) but sometimes there is too much data to fit into 3 columns so they use 4 and fold it smaller. In case our customer decides this is a must have I need to know once and for all if it's possible.
Thanks in advance!