Rank: Newbie
Groups: Registered
Joined: 5/29/2019(UTC)
Posts: 2
|
Hello
i have a quick question regarding Seal report
i have a special requirement to show 2 Sums columns in the same report's view but with different where clause filter
example
col1 : Sum (field) where condition =... condition1
col2 : Sum (field) where condition =... condition2
is this possible ?, i see one sql query is possible per report
can be possible to overwrite a special where clause per field ?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
I think it is more a SQL question,
for col1, you can always overwrite the SQL by using the Advanced/Custom SQL property.
you can then use a CASE WHEN statement to change your SUM, like SUM(CASE when condition = condition1 then field else 0 end)
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/29/2019(UTC)
Posts: 2
|
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
