R – Crystal Reports table lookup based on SP parameter

If the table columns are name and size, you vertically arrange the details fields like...

name  {name_field}
size  {size_field}

but i think the problem with that is when you "format with multiple columns" it would turn 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 only display the "row header" in the first column? Because I'm not sure if that's 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}

Wouldn't it be easier to just go the standard way of...

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}

Am I missing something?

EDIT

Create a formula for each field like so...

if remainder(recordnumber, 3) = 1 then
"Field Name    " + {some_field}
else
{some_field}

might want to put the conditional into a function, in case you ever want to display more than 3 columns.

This is really late to the party, but I'm researching the same problem (I think) and have found a solution. In the main report, right-clck on the sub report and "Change Subreport Links".

In the top section, choose your parameter in the main report and click the right arrow to add to the "Field(s) to link to". In the bottom, sub-report section of the window, change the left side "Subreport parameter field to use" drop-down. It defaults to creating a new parameter in the sub report and you don't want to do that. You want to use an existing paramter (that was automatically added by using the stored procedure). In the drop-down choose that parameter that was auto created by the stored procedure.

Doing this means that you can have a parameter in the main report that you can automatically pass to the subreport which means you don't have to enter the same value for two separate parameters.

I hope this helps. It works great for me.