New to RB - Help with Grouping report

rbuser

I am new to using RB and now have the need to understand how it works with a
GROUP BY clause.

I have a stored procedure that is returning a dataset correctly. The SQL is
returning Orders and Order Items for a specific sales rep. The SQL uses a
GROUP BY clause and groups the order item records by Order_ID.

I am creating a report but am not getting the results I would like. I have
a Group Header with the fields that are in the Order table, and have placed
the Order Item fields on a detail region.

The data is showing but the report is only showing the first order.

I tried using the "Groups" menu option and defined Group[0] as one that uses
the Order_ID field which should be correct.

One complaint I thought I would mention is that the Groups dialog is not
wide enough which makes it real tough to see the field name you are trying
to pick, the entries get truncated with no way to size the form. (Crystal
Reports used to do that all the time, drove me crazy.)

Can someone please offer some insight?

Any help would be greatly appreciated.

Thanks,

--
Reid Roman
Future Generation Software
http://www.fgsoft.com

digitalmetaphors

To create a grouped report, you simply need to order the data by the field
you want to create a report group on. Then in the group's dialog, select the
field that you want to group.

True, it does clip some text in the group dialog's default size. Drag the
right side of the group dialog to be wider. The components in the dialog are
anchored, so the combobox with the field names should stretch when you
resize the dialog so you can see the full field names:)


Cheers,

Jim Bennett
Digital Metaphors

rbuser

"Jim Bennett (Digital Metaphors)" wrote in

digitalmetaphors

Yes, use the header band:) If this isn't what you can use, then create a
group on a static custom field, such as a label in the title band. Then the
group header should reprint on subsequent pages. Set the group footer band
to not be visible or resize its height to zero.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

"Jim Bennett (Digital Metaphors)" wrote in

digitalmetaphors

Here is an example of what I'm describing:

http://www.digital-metaphors.com/tips/UseGroupHeaderForHeader.zip


Cheers,

Jim Bennett
Digital Metaphors

rbuser

"Jim Bennett (Digital Metaphors)" wrote in