Joining fields from several tables onto one SSRS report
-
Does anyone know the best way to join fields from several tables onto a single SSRS report for SSRS 2005 and SSRS 2008? :doh:
Just guessing as it has been a while sine I did any SSRS, either concatenate the fields in the cell definition if you are in a matrix or create an expression and use that for the textbox content. There is also the option of creating a formula and using that but I can remember the entry point for the code editor. [edit] Reread you question - several tables. I always use a stored proc and return 1 table as a result set [/edit]
Never underestimate the power of human stupidity RAH
-
Just guessing as it has been a while sine I did any SSRS, either concatenate the fields in the cell definition if you are in a matrix or create an expression and use that for the textbox content. There is also the option of creating a formula and using that but I can remember the entry point for the code editor. [edit] Reread you question - several tables. I always use a stored proc and return 1 table as a result set [/edit]
Never underestimate the power of human stupidity RAH
-
Will this work if you need to join several tables from different databases which would mean different data sources?
It is possible especially if the DBs are on the same server, if they are not then the hassle of linked servers is irritating. Investigate doing the join in code in the report. You can throw the values into variables an manipulte the vars.
Never underestimate the power of human stupidity RAH