[RESOLVED] Printing fields in Table order
I've got a report with the details based on a table in my database. The field prints all the records fine, but they are always sorted alphabetically. I want them to simply print in the order they were placed in the table.
I've gone through the Record Sort Expert and removed the sort criteria so the field is not even listed there (yet it still sorts and the database field is not)
This should be a really simple thing but I'm stuck.
Thanks
Ken
Re: Printing fields in Table order
Please say :
Crystal Reports version
Data Source (Access, SQL,etc.)
Method You set to retrieve the records ( DAO, ADO, ODBC, etc.)
Re: Printing fields in Table order
simply sort(ASC) on the autonumber field....
BTW you never know where exactly a new row is inserted. what you get while viewing records in a datasheet view (MS Access) is simply sorted result based on autonumber field.
few days back a post (databse development) was there on the issue of where records are actually inserted, I'll post the link...
Re: Printing fields in Table order
Re: Printing fields in Table order
Quote:
Originally Posted by jggtz
Please say :
Crystal Reports version
Data Source (Access, SQL,etc.)
Method You set to retrieve the records ( DAO, ADO, ODBC, etc.)
Sorry ... it's CRXI, mdb and I guess it's ADO (CRXI doesn't tell me specifically)
Re: Printing fields in Table order
Quote:
Originally Posted by VBFnewcomer
simply sort(ASC) on the autonumber field....
BTW you never know where exactly a new row is inserted. what you get while viewing records in a datasheet view (MS Access) is simply sorted result based on autonumber field.
few days back a post (databse development) was there on the issue of where records are actually inserted, I'll post the link...
Thanks VBFNewcomer. Duh ... did the trick. :)
Thanks again.
Ken