BorlandTalk.com

Ricky Lie · Guest

Hi,

I'm new with Rave Report and have some experience with Qreport, can anybody
help me or refer me to an example on how to generate a report from a single
query
e.g the contents of table query
ID Collumn1 Collunm2
1 Item1 Equipment234
2 Item1 Equipment565
3 Item2 Equipment867
4 Item2 Equipment999
5 Item3 Equipment403

I use to work with Qreport generating the following report;

Group Item: Item1
Detail: Equipment234
Detail: Equipment565
Gruop Item: Item2
Detail: Equipment867
Detail: Equipment999
Group Item: Item3
Detail: Equipment403

How can I generate such report using Rave Report?, I've try to follow the
"Introduction to Rave Reports Part III and IV, by Leonel Togniolli" and can
go as far as displaying the query just like DBGrid.

How should I arrange the BAND and DATABAND for the above report?, I'm using
D2005 enterprise and Rave Report BE version 6.0.1 and currently I've to
convert all reports created with Qreport.

Thank you and appreciate for all tips or comments

Regards,
Ricky Lie

Brad Prendergast · Guest

There are a few ways to do this. Did you try the report wizard?

One quick and simple report of your example:
- Place TRVProject on your from
- Place a TRVDataSetConnection on the form
- Assign your query as the DataSet on the TRVDataSetConnection
- Double click on the TRVProject to open the Report Designer
- In the report select New Data Object
- Choose DirectDataView and click next
- Select your DataSetConnection
- Place a TRegion on the Report
- Place a BandComponent on the Report (Bandstyle GroupHeader)
- Place a DataBandComponent on the Report (BandStyle Detail)
- Place a BandComponent on the Report (Bandstyle GroupFooter)
- Set Controllerband of your 'Header' and 'Footer' band to the DataBand and
set the GroupDataView to your Dataview connection. Also set the GroupKey to
the field you want to group by (the query must be sorted by this field)
- Place DataText components where you like setting the DataField and
DataView as appropriate

From your app call RvProject1.ExecuteReport('Report1'); (If you kept the
default names. Also, you can store the reports in the apps.

Hopefully this gets you started.

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brad Prendergast

"There's a fine line between genius and insanity. I have erased this
line." -- Oscar Levant (1906 - 1972)

"Ricky Lie" <nusatrindo (AT) cbn (DOT) net.id> wrote

Ricky Lie · Guest

Hi Brad,

Appreciate your response, thank you.

I've tried using the report wizard and also follow your step by step report
setup (very detail and helpfull), in both cases I've got the report result
as:
Group Item: Item1
Detail: Equipment234
Group Item: Item1
Detail: Equipment565
Group Item: Item2
Detail: Equipment867
Group Item: Item2
Detail: Equipment999
Group Item: Item3
Detail: Equipment403

instead of:

Group Item: Item1
Detail: Equipment234
Detail: Equipment565
Group Item: Item2
Detail: Equipment867
Detail: Equipment999
Group Item: Item3
Detail: Equipment403

Is it possible to have one databand that hold the Item group and follow by
the another databand hold all detail of the item group in rave report?. I
may have report which have more than one step grouping created previously by
qreport such as;

Group Item: Item1
Sub Group of Item1
Detail: Equipment234
Detail: Equipment565

Thank you,
Regards,
Ricky Lie

"Brad Prendergast" <format('bradp%sbpsoftware.com',['@'])> wrote

Brad Prendergast · Guest

You shouldn't need to. I've completed dozens of reports that do numerous
levels of grouping with one data band. Is your data source sorted (first)
by the group field? From your results and sample data it looks like you
have a grouping of ID rather than COLLUMN1.

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brad Prendergast

"There's a fine line between genius and insanity. I have erased this
line." -- Oscar Levant (1906 - 1972)

"Ricky Lie" <nusatrindo (AT) cbn (DOT) net.id> wrote

Ricky Lie · Guest

Hi Brad,

Okay, it's my mistake I didn't put the field (sorted collumn field) in the
group header.

Now I've got what I want, thank you and appreciate very much for your help.

Regards
Ricky Lie

"Brad Prendergast" <format('bradp%sbpsoftware.com',['@'])> wrote