2 Page Column Report (1 Viewer)

[mfallon]

Hi...

I am have create a report with 3 columns. When the information in the columns spills over to the 2nd page I would like the data to stay in the same column. For example:

PAGE 1
Column 1___Column 2__Column 3
Apple______Car_______Red
Banana____ Bus_______Blue
Orange______________Yellow
____________________Green
____________________Pink
-----------------------------------
PAGE 2
____________________Column 3
____________________Black
____________________Brown
____________________Purple

Currently, my page 2 looks like this

PAGE 2
Column 3
Black
Brown
Purple

For formatting purposes, __ was used for spaces.

Any ideas? Thanks so much!

 

[mfallon]

Am I not explaining it clearly? Please let me know.

 

[pravin3032]

Are you sure the second page which you shown is from the same the report.
its really hard to beleive what you shown here.

 

[mfallon]

The first second page is what I want to see from my report. The second second page is what I'm getting. Does that help?

 

[pravin3032]

mfallon,
Now i got why 2nd page comming so.
in second page values for column1 and column2 are comming null
but column3 returning with some value.
you have used "_" to concanate three column but not handeled it for null values. when u concanate null with "_" it will return null (no space)
you should right pad each column with "_" ( or with single space " " ) with some fixed size say 30.
if still have doubt reply.