Crystal Reports - row headers for mutli-column data
Please, help!
I need to create a Crystal report with multiple columns of data, but also need to show the row headers.
eg.
(Fieldname) (DataColumn1) (DataColumn2) (DataColumn3)
Animalname Elephant Dog Mouse
Animalsize Large Medium Small
I successfully got the columns of data to display using the Multi Column Format option in the details section, but is there a way to display the headers (Animalname / Animalsize)?
(I am using Crystal Reports 2008 inside Visual Studio 2008)
a source to share
If the table columns are name and size, you are vertically ordering the data fields, like ...
name {name_field}
size {size_field}
but I think the problem is that when you "format with multiple columns" it turns into this ...
name {name_field} name {name_field} name {name_field}
size {size_field} size {size_field} size {size_field}
name {name_field} name {name_field} name {name_field}
size {size_field} size {size_field} size {size_field}
name {name_field} name {name_field} name {name_field}
size {size_field} size {size_field} size {size_field}
is that the problem? How to display only the row header in the first column? Because I'm not sure if this is possible. And even if you could do it, is this what you really want?
name {name_field} {name_field} {name_field}
size {size_field} {size_field} {size_field}
name {name_field} {name_field} {name_field}
size {size_field} {size_field} {size_field}
name {name_field} {name_field} {name_field}
size {size_field} {size_field} {size_field}
It would be easier to just go the standard way ...
name size name size name size
{name_field} {size_field} {name_field} {size_field} {name_field} {size_field}
{name_field} {size_field} {name_field} {size_field} {name_field} {size_field}
{name_field} {size_field} {name_field} {size_field} {name_field} {size_field}
{name_field} {size_field} {name_field} {size_field} {name_field} {size_field}
{name_field} {size_field} {name_field} {size_field} {name_field} {size_field}
Did I miss something?
EDIT
Create a formula for each field, for example ...
if remainder(recordnumber, 3) = 1 then
"Field Name " + {some_field}
else
{some_field}
might want to include a condition in the function if you want to display more than three columns.
a source to share