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..

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....)

Edited by hilfy - 01 Feb 2008 at 7:33am