We created a SQL User called CrystalUser which has read only access to the table. Then in each report we set the credentials to this CrystalUser account.