The following works nicely with an access database, so I am thinking if you create with access, and create an odbc to the access database to let access read sotamas, it may work for you, or possibly you can do the same with your sql setup.
ChaZ
----------------------------------------
This is probably the most accessed information on the BestTalk forum and I thought I'd put it on here as well so we can have another place for it.
Thanks BigLouie for your contribution
Creating a pass through query in Access is really easy.
1. Open Crystal and start a new report
2. Base report on ONE MAS200 table
3. Pull into the detail section all fields you want
4. Go to Database on the menu
5. Go to Show SQL Statement
6. Highlight and copy the entire SQL statement.
7. Open your Access application
8. Go to Queries
9. Create New Query
10. Close tables box that opens.
11. Change Query type to SQL specific
12. When edit window opens paste in SQL statement from Crystal
13. Go to View on menu
14. Go to Properties
15. Click just to the right of the ODBC Connect St. box
16. Follow wizard to MAS200 and log in.
17. Select Save Password.
18. Edit the resulting ODBC connection string so that it looks like this: