SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 JOINs between VIEWs in SSRS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kristen
Test

United Kingdom
22403 Posts

Posted - 12/02/2013 :  13:06:35  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 12/02/2013 :  23:25:20  Show Profile  Reply with Quote
Nope..you cant
For those cases you've to explicilty do the joins

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 12/03/2013 :  10:56:41  Show Profile  Reply with Quote
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 ...
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 12/04/2013 :  00:21:14  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 12/04/2013 :  03:17:08  Show Profile  Reply with Quote
Thanks Visakh, I'll take a look at the BI tools.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000