Rave Report for Delphi

I am having a problem with a subtotal band in Rave Reports 6.0.1. I am using it with Delphi 2005 and MSSQL.

The problem:

My stored procedure totals amounts and creates a report for shortcodes such as: 11A, 11B, 11C, 12A, 12B, 12C, etc.

What I need to do is create a subtotal band for shortcodes 11, 12, etc.:

11A totals
11B totals
11C totals
-----------
11 group subtotals

12A totals
12B totals
-----------
12 group subtotals

I have tried setting the band GroupKey to Copy(shortcode, 1, 2) but that doesn't seem to work. I can't find any other function or command that appears to provide the GroupKey information that I need for this report. What is the correct function or syntax for the GroupKey that I need to use here?

Thank you for your assistance.

mandl

I have the same problem.

No one could help us ?

Thanks

Instead of trying to do this in Rave,
add a column to your result dataset that does this and group on the new column.

Clive

Yes. That got it. Thank you.