Good day all,
Can anyone tell me why I can retrieve data from standard CRM tables in SQL but Filtered Tables (Views) do not return anything.
ie. I can see the data in ServiceAppointment Table but not FilteredServiceAppointment Table
Regards
Tom
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Tom,
I'm sure that depends on how the views are constructed and what permissions you have in SQL server. We have used Microsoft CRM in the past, and we had our permissions set so that normal users could ONLY retrieve data through the filtered views and not through the tables directly. So I know the filtered views can be used in Jet because I've done it before, so possibly you are not able to use them because of a permissions issue or something similar.
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes, I will see what my CRM dept can come up with
Please sign in to leave a comment.