Using An Expression To Set The Position Of A Subreport.

Dear all,

I feel I am almost there with my current project but I am just trying to solve the last few problems here.

I was not able to have a columnized sub report within my main non columnized report as all sub reports inherit the layout of the main page (a known limitation).

However, I need to get some data into columns on my main page so I have had to hack around the issue to get the desired results.

Instead of creating one columnized subreport (which wont work in the main page) I have added two non-columnized sub reports to the main page listing the first half of the data in one subreport and the 2nd half of the data in the other subreport.

The problem is this. I need to put a total at the end of the data. And it depends how much data there is as to where the total should be (left column or right column) If there are only 10 lines of data then the first left hand sub report will display those results and the right hand sub report wont display anything. However, if there are 100 lines returned then both sub reports will display data and the total will need to be at the bottom of the right sub report.

Can I achieve this with an IIF statement? Any suggestions would be most helpful.

Trevor Keast