Grouping blocks of data with text 1

[IanWaterman]

I am trying to recreate a Crystal report in Reporting services, which I have only just started to use.

Existing report has groups for ancillary insurance products, in Crystal I simply group the data by ancillary and then add summaries to group section.

Ancillary 1 Group header
Premium PremAmount
Tax Tax Amount

Commission CommAmount
Net Earned PremAmount - CommissionAmount

Where the amounts are simple sum formula. Crystal then repeats section autmatically for each ancillary.

Can this be done in RS?

Ian

 

[RiverGuy]

Yes. I usually use a Table for things like this, although I know some may recommend a List. It looks you have five detail rows within each group (one of them a blank row). You can highlight your details row and right-click to insert another row. You can do this multiple times to end up with the five rows.

 

[IanWaterman]

Worked perfectly with a table.

Thank you

Ian