The sequence no option is not available in my custom view report (I generated a report from a custom view table) How do infix this pls
Add Sequence No to Report (Custom View)
-
- User
- Posts: 412
I just discovered that when i filter the report , my serial number fails. Intead of 1, 2, 3... i get the number on the serial number row. . e.g 200,201...
SELECT * FROM reportuserstbl
WHERE MDA_id
= 103 is the query phpmaker runs when i filter with MDA_id for instance.
it means row_NUMBER() only works when i select show all. when i filter roW_NUMBER() is ignored.
When I the view loads the the row number () column is serial I.e 1 2 3 4 ....
But when I search I get 12 30 35 70...
The numbers are not serial
How can i fix this pls