Display data in columns

[JiTS]

Hi,

Problemsituation (see attachment):
Within a contract are many numbers (afleveringsbonnummers).

These numbers will not display in more than one column, see figure 1.

Own solution until so far:
The data in the green shape is in the header of the group 'Contractnummer'. I put the text field 'afleveringsbonnummers in the Details section but that didn't work

Next I created a sub report. I changed the page settings to more than one column and that worked good, see figure 2.

But when I put the sub report in my main report then the numbers will be displayed still in one column.

Problem:
What do I have to do to show te numbers in more than one column. I will not change the page settings of the main report because then my other data (green shape) will not displayed correctly.

Please help...

JiTS

 

[spacepro]

Without looking at the report properly, I am assuming you want to duplicate the value in figure 1 and put it into figure 2 or wherever.

If this is the case just add a unbound textbox and put this as it's controlsource

=[NameofFieldonReport]

If not then please explain a little bit more or attach the report.

Sorry if I have misunderstood.

Hope this helps

Andy

 

[JiTS]

First of all thanks for your reply.

I found the solution for my problem at MSDN:

http://msdn.microsoft.com/library/d...f2000/html/mysubreportprintsonlyonecolumn.asp

I am busy now to try it out... hopefully it helps.


*SMiLE*
JiTS