Seal Report Forum
»
Report Edition
»
Reports
»
CommonRestriction_ OR CommonValue_ in cell's CustomSQL
Rank: Advanced Member
Groups: Registered
Joined: 8/9/2019(UTC) Posts: 45  Thanks: 13 times
|
Hi Eric, I'm trying to impact a cell using a prompt restriction "FROMDATE" in the Model. Basically, I need to show Amount for "SELECTED_DATE - 1 DAY" . I've tried employing {CommonRestriction_FROMDATE} and {CommonValue_FROMDATE} for this; but I'm getting nowhere. This is what I have employed in the CustomSQL for Amount field: Code:case when to_char(business_date-1,'dd-mm-yy') in ({CommonRestriction_FROMDATE}) then Sum(BALANCE) end
And this is what's showing in the ReportSQL : Code:case when to_char(business_date-1,'dd-mm-yy') in (1=1) then Sum(BALANCE) end
I have also tried creating Report Init Value: FROMDATE But again, no luck. Please help! Edited by user Thursday, November 21, 2019 11:05:22 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Yes, it appears that Elements SQL (and custom SQL as well) are not handled to determine the Common Restrictions and Values...
This will be enhanced in the 5.1
In your case it will be a {CommonValue_FROMDATE} as {CommonRestriction_FROMDATE} will also inject the column name in the SQL...
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/9/2019(UTC) Posts: 45 Thanks: 13 times
|
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
CommonRestriction_ OR CommonValue_ in cell's CustomSQL
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.
