Reports

[bucrepus]

I am trying to design a simple report with MS SQL reporting. I create a SQL DB with one table having 4 fields. Field A(10chars), B (10chars), C(10chars), and fieldD(125 chars). I have 25 rows of testdata in the table.

I put them in the body (details) section, but I need 2 rows. One for fields A,B,C and the next row entirely for field D since it is so large.

I would like the outout like this:

fieldA fieldB fieldC (fieldD on next line)

Smith John 12/12/2009
John Smith is a computer programmer. He is 30 years old.

Flintstone Fred 09/11/2009
Fred Flintstone is a rock breaker. He has 3 cars.

and so forth...
I drop a table on the details and plug in the field names.

I cant figure this out, if I add a new row for fieldD the column is only as big as fieldA's. So it comes out like this

Smith John 12/12/2009
John Smi
th is a c
omputer
program
mer. He i
s 30 yea
rs old.
(or looks close to this)

How can I expand fieldD's column width seperately without affecting FieldA's above. I think I might have to display this not using a table in the body, but don't know any other way. I tried putting textboxs manually but I can't do the repeating data (or at least dont know how).. I would think it would be simple to display 4 varying size fields on 2 lines in the detail body section.
Any Ideas..
Thanks
BUC

[roycebacon]

Use the field merge function. Select all of the fields on line two and then I think you can right click and merge them. If it isn't exactly that look for field merge in help.