How to Group Data Band Columns

[tims]

Is it possible to group data when using columns in a databand?
I have the following


I would like to group all the Front Toe Kick and Back Toe Kicks onto one line, ignore the Index # for now.

I don't see a columns option in the group header properties. How can I do this? Where do i place the group header, and how can i arrange the fields on it to display in this way.
http://screencast.com/t/aKXy9N4T
http://screencast.com/t/1I0wXjrGq

Thanks,
Tim S.

[Alex K.]

Hello,

As a way, please try to set the Columns property for the Page instead ColumnHeader and use GroupHeader band.

Thank you.

[tims]

I need to only have part of the page with multiple columns. I need the headers and the data above to run the fill width of the page, so setting up the Page with columns doesn't seem to work for me.

Thanks,
Tim S.

[Alex K.]

Hello,

Can you please send us your report with test data for analysis.

Thank you.

[tims]

Here's the sample report and data.

https://dl.dropboxusercontent.com/u/2491635/Cutlist.zip

Thanks,
Tim S.

[Alex K.]

Hello,

Please describe your issue in more details. The report on the screenshot and in the sent files is different.

Thank you.

[tims]

Sorry for the confusion.

This was a different report with the same issue.

Here's a screenshot of the one i sent the data for.
http://screencast.com/t/83jvfFbi4Wj

I need the data to form 2 columns to fill the white space in each group.

[Alex K.]

Hello,

Please check the sent data and sent report.

Thank you.

[tims]

Group Name is a calculated column in the report.

The String Value is
IIF((Parts.Name.ToLower.Contains("side") OrElse Parts.Name.ToLower.Contains("division") OrElse Parts.Name.ToLower.Contains("corner")) AndAlso Not (Parts.Name.ToLower.Contains("drawer side") OrElse Parts.Name.ToLower.Contains("back")),"Machined Parts",
IIF((Parts.Name.ToLower.Contains("bottom") OrElse Parts.Name.ToLower.Contains("adj shelf") OrElse Parts.Name.ToLower.Contains("shelf adjustable") OrElse Parts.Name.ToLower.Contains("top") OrElse Parts.Name.ToLower.Contains("fixed shelf")) AndAlso Not (Parts.Name.ToLower.Contains("corner") OrElse Parts.Name.ToLower.Contains("rail") OrElse Parts.Name.ToLower.Contains("stile") OrElse Parts.Name.ToLower.Contains("drawer")), "Bottoms/Tops/Shelves: ",
IIF(Parts.Name.ToLower.Contains("back") AndAlso Not(Parts.Name.ToLower.Contains("drawer") OrElse Parts.Name.ToLower.Contains("toe") OrElse Parts.MaterialType = 4), "Backs: ",
IIF((Parts.Name.ToLower.Contains("rail") OrElse Parts.Name.ToLower.Contains("stile") OrElse Parts.Name.ToLower.Contains("stretcher") OrElse Parts.Name.ToLower.Contains("nailer") OrElse Parts.Name.ToLower.Contains("toe") OrElse Parts.Name.ToLower.Contains("sleeper") OrElse Parts.Name.ToLower.Contains("sub front") OrElse Parts.Name.ToLower.Contains("cleat")), "Rails and Nailers: ",
IIF(Parts.Name.ToLower.Contains("drawer sub front") OrElse Parts.Name.ToLower.Contains("drawer bottom") OrElse Parts.Name.ToLower.Contains("drawer side") OrElse Parts.Name.ToLower.Contains("drawer back"), "Drawer Parts: ",
IIF(Parts.Name.ToLower.Contains("fridge"), "Panels: ", "Custom Sizes: "))))))

Process Type is also a calculated column
The String Value is
IIF((Parts.Name.ToLower.Contains("side") OrElse Parts.Name.ToLower.Contains("division") OrElse Parts.Name.ToLower.Contains("corner")) AndAlso Not (Parts.Name.ToLower.Contains("drawer side") OrElse Parts.Name.ToLower.Contains("back")),"CNC","Beam Saw")

[HighAley]

Hello.

Sorry, but we do not able to recreate your report.
Could you send us a report template with data or a sample project that will help us to reproduce your issue without any changes?

Thank you.