Page 1 of 1
Summary Report - Extended Filter without showing the field
Posted: Tue Mar 19, 2024 7:51 am
by yinsw
I created a summary report with these fields:
TXTYPE
TXDATE
TOTALSUCCESS
TOTALFAILED
TOTALAMOUNT
I set TXTYPE as the Grouping Level. I want to add Extended Filter for TXDATE but I don't want to show the field in my report. How to achieve this?
Below is the query result I'm expecting from the report:
SELECT TXTYPE
,SUM(TXSUCCESS)
,SUM(TXFAILED)
,SUM(AMOUNT)
,SUM(TOTALAMOUNT)
FROM VIEW_RPT_DAILY_SUMMARY
WHERE TXDATE BETWEEN '2024-01-01' AND '2024-03-19'
GROUP BY TXTYPE
Re: Summary Report - Extended Filter without showing the field
Posted: Tue Mar 19, 2024 9:35 am
by mobhar
You may simply put this following code in Page_DataRendering server event:
$this->TXDATE->Visible = false;
Re: Summary Report - Extended Filter without showing the field
Posted: Tue Mar 19, 2024 10:41 am
by yinsw
This will only hide the column, and it still did not group by TXTYPE and sum all the other fields
Re: Summary Report - Extended Filter without showing the field
Posted: Tue Mar 19, 2024 10:59 am
by mobhar
Then make sure you have already setup the TXTYPE field from Grouping Levels of your Summary Report.
Since you wanted to setup the Grouping from the Report side, then you should remove GROUP BY from your SQL above.
Re: Summary Report - Extended Filter without showing the field
Posted: Fri Mar 22, 2024 12:30 am
by yinsw
The query is just an example of the output that I am expected from my tables above. (ignore the SUM(AMOUNT)
as that was wrong).
Meaning, I want to group my data by TXTYPE, and SUM for the TXSUCCESS, TXFAILED, and TOTALAMOUNT.
I already set TXTYPE as the Grouping Level.
If I didn't add TXDATE as my field, I can't use it as my Extended Search.
If I add TXDATE, I can use as Extended Search, but I can't group the TXTYPE only as it still show individual records due to the TXDATE.
Re: Summary Report - Extended Filter without showing the field
Posted: Sat Mar 23, 2024 11:52 am
by mobhar
Then, that means you cannot hide the TXDATE field for such case.