I want to query the view that is used for the Aged AR report using SSMS. I find a select statement displays no data unless I first preview the report with Crystal. Yet, views I have created populate with data on the action of executing a select statement. What is the proper way to get an existing Dynamics SL view to display data with a SQL query, without first using Crystal to preview (and populate) the view layout?
Thanks for any advice