Can I use the SQL store procedure or view to retrieve data for the data grid? If yes, how to do it?
IIRC the only way to do this is to hack the database aftepublishing in 7.6. Not something I would recommend, however.
In version 9 it is supported and easy.