logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
aanaya  
#1 Posted : Thursday, May 30, 2019 11:59:39 AM(UTC)
aanaya

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 ?
epf  
#2 Posted : Friday, May 31, 2019 5:55:29 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 693
Switzerland

Thanks: 12 times
Was thanked: 125 time(s) in 122 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)
aanaya  
#3 Posted : Friday, May 31, 2019 8:07:01 AM(UTC)
aanaya

Rank: Newbie

Groups: Registered
Joined: 5/29/2019(UTC)
Posts: 2

great hints
Many thanks
Users browsing this topic
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.