Hi Experts,
Could you please shed some light on the following issues I've encountered with my interactive grid report? I have a grid where data is sourced from an SQL query. It's essentially employee certificate details, including their expiry dates.
The issue I'm facing is with the Serial No. column in the grid, which gets its values from the ROWNUM of the query.
My first problem is that if I filter the report using any given criteria, the serial numbers display as original ROWNUM values (e.g., 18, 25, 32). For instance, if there are only three records after filtering, I want the serial numbers to be displayed as 1, 2, 3, rather than 18, 25, 32.
The same issue occurs when a user sorts the grid by fields such as idno or designation; the serial numbers also get mixed up and go out of order. Is there a way to exclude the Serial No. column from sorting, so that the serial numbers remain sequential (1, 2, 3, etc.), regardless of the sorting applied?
I hope I haven't confused you. Thanking you in anticipation.
Best Regards,
AR
@InoL