Gem Reports Guide - Apply Filter
Question:
It appears that there is no way to use a system variable in the
SQL for Gem Reports? It means we cannot make SQL reports like this. I had
thought that there were special variables that we can use as parameters. Can
you confirm if we are using the wrong variable names? Could you provide us with
Gem Reports documentation?
Answer:
Solution:
SELECT zoneGroup, zoneGroupDescr
FROM BAS_ZONEGROUP
WHERE organizationId = ':organizationId'
AND warehouseId = ':warehouseId'
AND activeFlag = 'Y'
Answer:
Solution:
Given step by step solution on how to do filter in the GEM Reports.
Dynamic filtering based on warehouse is not available but user can use below as workaround:
To achieve similar result, user can set default value under Arg Page (based on the warehouse). Example as below:
DataImage98.png
How to apply filter in Gem Report.docx
| Files | ||
|---|---|---|
|
|
DataImage98.png
16 KB
|
|
|
|