Last post Apr 16, 2012 05:53 AM by mezzanine74
Apr 16, 2012 03:22 AM|mezzanine74|LINK
Is there any way to get matrix sql query from report ? We provide table query as input, but SSRS doing some amazing job and we can get complex matrix queries. Can we get this intelligency from report, so that we can run same query on Gridview control etc.
Apr 16, 2012 05:26 AM|Gayomard Mehta|LINK
What the SSRS matrix does is nothing great... It just groups our data based on the rows and columns both and renders it accordingly.
The output of SSRS is actually a XML file so I do not think it builds any query so that we can use it for the gridview. If you want to use it in a gridview I think there would be complex logic involved...
Apr 16, 2012 05:53 AM|mezzanine74|LINK
What i am seraching is actually a kind of SQL Query generator which will produce PIVOT and UNPIVOT SQL query for dynamically changing columns. SSRS is very smart tool to achive this but i dont have as much control on Report as Gridview like changing columns
witdh, conditional formatting on cells etc. As you mentioned, i think this intelligency is somwhat embedded to Report Server and we cannot get it.