How to fetch records based on Sql Query.
For example I have a table Bill with fields of – Supplier Name, Paymode, Bill no, bill date, blll amount. Pay mode means cash or cheque payment. I have created a Report grouped under supplierName (CR1). When I use Selection formula to fetch record of cash payment is not working that is

CR1.selectionformula = “{bill.paymode} = ‘Cash’ “

The above code is not working if I have a report grouped under Supplier Name. But the same is working when I use the report without any grouping that if is is a List Report.

1. So what I want to know is how to fetch particular records when a report is grouped under any field.
2. How to use Sql Query instead of selection formula.

Please suggest with examples