www.hkvforums.com

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

You may simply put this following code in Page_DataRendering server event:

$this->TXDATE->Visible = false;

This will only hide the column, and it still did not group by TXTYPE and sum all the other fields

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.

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.

Then, that means you cannot hide the TXDATE field for such case.