Hi

I have the data stored in the table sorted on a field. But while printing on the data report it skips this sort order. Say for example if there is some 1000 rows that has to be printed then it prints perfectly for few rows say from 1-35 then it starts printing say from 106 to 350, then it again prints from 36-105 and then it prints 351-1000. and every time i generate this report these figures keep changing , some how it breaks in between . Please suggest me a solution for this immediatly.

Shakuntala  

Hi,
How you view data in the table is just that - a "View". It is applied to the table when you want to view it, but the table still stores the data in its original order.
It is possible with most reporting tools to set an OrderBy Property, but without knowing which reporting tool you are using I think the best solution would be to set the data source for your report to a Query, then you can include an OrderBy statement to get it in the order you desire:
SELECT TableName.* FROM TableName ORDER BY Fieldname


____________________________
multi-tasking - the ability to hang more than one app. at the same time.