Not directly. You can, however, create a T-SQL View and a DAC on top of it and you will then be able to use this just like any other table in the Report Designer and Generic Inquiries.
Thanks @Gabriel Michaud , @Naveen B , I’m already using this solution but i wanna know also if it’s possible to add a field in the report that is a sql query ?
i have an issue right now, like you said i have created a view and im using it in report designer so in Sql i have the right informations but in report designer is displaying only the first line N times.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.