Grouping with Calculation

building reports crystal reports
1

Hi,

I am trying to eliminate subreporting or supress value on the same Building in a group, ex.

I have a building that falls under two seperate groupings in my report. The building group ** subreports to retreive unit information **.

Since this building can be found in multi sections in the report the unit information doubles.

example:
----------------------------------------Unit
Section 1
----Building 2--------------------------1
Section 2
----Building 2--------------------------1

Any suggestions is greatly appreciated.

Thanks.

dame (BOB member since 2007-07-30)

2

Why does the building appear in more that one section
Is this what you want.

If so, why do you not want to report on all units in the building as they would all be relevant to the section.

E.g. If section 1 is dealing with power and Section 2 is dealing with Staff, then the fact that the building and the unit appears under both IS relevant.

Do you need to restructure your report so that you report by building -> Unit -> section ??

If you only want the unit information to appear once, you may need to revisit the SELECT statement in the database to group data and select unit only on the MIN(section)

obiron (BOB member since 2008-01-10)

3

Hi,

Yes the building will appear in more than one section.

The units are recorded in a work file. The units are assigned ledger types as follows

AU - Actual Units
BU - Budget Units
FR - Forecast Units

I am using a subreport to retreive this information by building. The work file contains a subset of the buildings printing.

Thanks

dame (BOB member since 2007-07-30)