S
stabilo
I have created a report based on a query (rqt1) and a table (tbl1) that shows
in the detail section a chart representing the data coming from tbl1. The
source data of the report is the query rqt1 that is in fact a query SELECT
DISTINCT of a field (Field1) in tbl1.
The chart is based on the tbl1 data, and the fields that link the document
and the chart are Field1 (Report field) and Field1 (Chart field).
In other word, for each value in the query, I get a chart on each page
representing the underlying data coming from the table tbl1 based on the
field Field1. This works perfectly well.
My question is : I would like to make additional calculation and count the
rows that is in the underlying data on the table (the same data used in the
charts) and put it together with chart. How do I do this ? Do I have to
create additional fields in the query and use these field in my report ?
in the detail section a chart representing the data coming from tbl1. The
source data of the report is the query rqt1 that is in fact a query SELECT
DISTINCT of a field (Field1) in tbl1.
The chart is based on the tbl1 data, and the fields that link the document
and the chart are Field1 (Report field) and Field1 (Chart field).
In other word, for each value in the query, I get a chart on each page
representing the underlying data coming from the table tbl1 based on the
field Field1. This works perfectly well.
My question is : I would like to make additional calculation and count the
rows that is in the underlying data on the table (the same data used in the
charts) and put it together with chart. How do I do this ? Do I have to
create additional fields in the query and use these field in my report ?