Print Page | Close Window

Self Restricting Join

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2168
Printed Date: 05 May 2024 at 3:39pm


Topic: Self Restricting Join
Posted By: vijayk
Subject: Self Restricting Join
Date Posted: 29 Jan 2008 at 6:56am
Can we do self restricting join on a table.? Like my table contains data for all countries but when I only want USA data. When ever i use anything from country table, It needs to restrict data for USA. Like in Business Objects, we can edit the join. Can we do it in Crystal.?
 
Thanks
Vijay


Replies:
Posted By: hilfy
Date Posted: 29 Jan 2008 at 8:10am
This won't be an edit on the join, it will be part of your record selection criteria for the report.
 
In a BO Universe, a self restricting join just adds a line to the Where clause in the SQL.  In Crystal you have to add it to the selection criteria to get the same result unless you're using the universe to provide data for your report.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: vijayk
Date Posted: 29 Jan 2008 at 1:02pm
Thanks..

Posted By: vijayk
Date Posted: 01 Feb 2008 at 7:07am
Can we do this in Business Views..? How can i force a self restricting join whenever a user picks a column from that table in Business Views.?
 
Thanks
Vijay

Posted By: hilfy
Date Posted: 01 Feb 2008 at 7:33am
The easiest way would be to have them use a universe as a data source.  Another option would be to create views in your database and have them use that.  Business Views might work, but I've not used them and I seem to recall hearing that they're going to be deprecated in favor of universes (I may be wrong about that, but I think I remember hearing something about it....)
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: vijayk
Date Posted: 01 Feb 2008 at 7:46am
Thanks..! I was trying to mimic the functionality in designer with Business Views. I am looking how Bussiness views  design is different than universe design. Only advantage so far i have seen is we can change the data sources dynamically.
 
Vijay


Print Page | Close Window