Article ID: 157947 - View products that this article applies to.
This article was previously published under Q157947
It is possible to create a report based on a query by placing the SELECT-SQL statement in the Init method of the DataEnvironment.
Use the following steps to create a report based on a query:
For another method of doing this based on a view, please see the following articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/130122/EN-US/ )How To Add SQL SELECT to the Data Environment of a Report
Article ID: 157947 - Last Review: February 12, 2007 - Revision: 5.4