Cross Product Joins

[vsudaya]

Hi all,

Allowing cross product joins in report studio or frame work manger is going to degrade performance of reports.?
i need date(max) dispalyed at top of report which is coming from different table, the report page is set to different query(coming from stored procedure), so i need to do cross product join in order to display the max date.


can anybody tell me the alternative or we can work on with cross product joins also in reports. where can i set this option in frame work manager or particular report query options? which one is better?

thanks in advance
vsud

[Boris-A]

I often use a whole different query to have the information I need in my header (like max dates, sources, ect.).

As for the setup in FM, you have to highlight the "project" you are working on.  Assuming you kept the default layout, in the Project Tasks (bottom right of screen), you click on "Edit Governors..."

This is where you will find the "allow Cross-Product Joins"

You then have to republish your package.

But I truly don't believe that if your only problem is displaying a max date in the header that you should do this.  Use a different query.

Cheers