Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kristen
Test
22859 Posts |
 Posted - 2013-12-02 : 13:06:35
|
| If I add two tables into query builder any Foreign Keys automatically show up as Joins. Yipee!If I add two tables, instead, then there are no such joins automatically provided. Obviously there are no Foreign Keys on VIEWs (or are there??!!)Any way around this so that naive users can just drop two VIEWs onto a query and have them automatically join?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-02 : 23:25:20
|
| Nope..you cantFor those cases you've to explicilty do the joins------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2013-12-03 : 10:56:41
|
| Thanks Visakh ... its not looking any better is it?!!How come MS didn't implement all this stuff so that any unskilled end-user could knock together reports - SAFELY?We had this in SQL-based report writers that clients were using back in the 90's ... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-04 : 00:21:14
|
quote:
Originally posted by Kristen
Thanks Visakh ... its not looking any better is it?!!How come MS didn't implement all this stuff so that any unskilled end-user could knock together reports - SAFELY?We had this in SQL-based report writers that clients were using back in the 90's ...
SSRS is not a tool intended for unskilled end users. For end users you have self service BI tools like powerpivot,powerview addins for Excel.SSRS requires good knowledge on SQL as well as on VBScript functions for writing expressions inside atleast and a fair knoledge on VB.NET for custom codes.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2013-12-04 : 03:17:08
|
| Thanks Visakh, I'll take a look at the BI tools. |
|
|
|
|
|
|
JOINs between VIEWs in SSRS