Hi
I'm lost with a count-formula for my report. Below u see the details of my report so far:
Basic-Statement:
SELECT
FES.HIST_ANZEIT,
FES.FET_FETID,
FES.FELDID,
FES.REGAL,
FES.LAGID
FROM emmi2.FES
WHERE FES.FELDID NOT IN
(SELECT TEK.POS_FELDID
FROM emmi2.TEK )
including the following date-selection:
{Basis-Statement.LAGID} = 'K1'
and
( {Basis-Statement.FET_FETID} = 'EP130'
or {Basis-Statement.FET_FETID} = 'EP175'
or {Basis-Statement.FET_FETID} = 'EP210')
count-formula 1:
if {Basis-Statement.FET_FETID} = 'EP130'
and
{Basis-Statement.REGAL} = 1
then
count( {Basis-Statement.FELDID} )
count-formula 2 G1R1EP130_2:
{Basis-Statement.FET_FETID} = 'EP130'
and
{Basis-Statement.REGAL} = 1
=> created a sum with following details
- typ of sum: count
- field to sum: G1R1EP130_2
Problem:
with both formuals, the result is always the total of free storageplaces for
{Basis-Statement.REGAL} = 1. so it seems like its not excluding the or {Basis-Statement.FET_FETID} = 'EP175'
or {Basis-Statement.FET_FETID} = 'EP210')
desired result:
- for every storageplace EP130, EP175, EP210 the total count of free storageplace in:
- {Basis-Statement.REGAL} = 1
- {Basis-Statement.REGAL} = 2
- {Basis-Statement.REGAL} = 3
- {Basis-Statement.REGAL} = 4
- {Basis-Statement.REGAL} = 5
- {Basis-Statement.REGAL} = 6
- {Basis-Statement.REGAL} = 7
- {Basis-Statement.REGAL} = 8
the report should look like the following:
gang 1 gang 2 gang 3 gang 4
regal1 regal 2 regal3 regal 4 regal5 regal 6 regal7 regal8
ep130 count count count count count count count count
ep175 count count count count count count count count
ep210 count count count count count count count count
i already tried with grouping n most other stuff as well as sub-reports, but nothing worked out... any help will be much appreciated.
thx
pad
Edited by PatrickMayer - 11 Oct 2010 at 10:33pm
IP Logged
