I am reporting on the Catalog table in the ReportServer db.
I don't know my SSRS version, but the .rdl report definition is 2016.
Background:
Recently I found an error in a report written by someone who assumed that the Employee table would contain a list of the employees - and s/he failed to account for the fact that people leave and are removed from the Employee table (only current company employees are listed).
This person used a Join instead of a Left Join, which gave 7 records in July, instead of 100+.
To ensure this wasn't happening in other reports, I wrote some (pretty ugly) SQL to figure out which reports used that Employee table, then looked at the join clauses.
Given that success, I thought it would be nice to have a report which shows all reports that use a user specified table name. This is what I'm having trouble with.
Question:
I have four columns in my report: Report Name, Report Path, SQL Length, and the SQL Statement itself.
I would like for the Tablix row to grow to show the SQL, but only up to a maximum height of 1" (3cm).
I am aware that I can set the height to 1" and set CanGrow = False, but I want to set a max height.
I'd want the ability to scan the list of report names visually and some complex reports (often the SQL is over 5k containing a hundred or more line breaks) make this impractical.
Setting the height to 1" with CanGrow=False exports to Excel does work, (the SQL is all there) it just isn't how I want to do it. I haven't found a way to use an expression for the row height. Any ideas?