Can Report Studio warn user if JOIN between tables does not exist?

[sln007]

Can Report Studio warn a user, if they select one-or-more fields from 2 tables, prior to trying to run the report?

That is:
In your Package you have tables A, B, C.
You create a join strategy (simple Equi-Join) between A and B.
User selects field A1, A2, B1, then runs report....it's OK.
User selects field A1, A2, C1...But no JOIN exists between A and C, then can Report Studio pre-empt the RUN function to warn user of invalid join??

Steve N.
State of Ohio, MIS

 

[sln007]

Nevermind. "HELP" and good old "Look Until You Find It" method works sometimes. lol

The "Cross Join" property for the query controls this option. Default is "DENY".

It works if the additional table is a true orphan.

Post closed.



Steve N.
State of Ohio, MIS