Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Relationship filter ignoring VLDB setting

Status
Not open for further replies.

JaC74

MIS
Oct 8, 2003
56
US
VLDB was set at report level to use look up table as the where clause driving tables. However, my relationship filters ignore this setting. For example: Report filters on Location and Time. All passes without relationship filter has where clause such as "WHERE LU.Location = 5 and LU.PeriodID = '2004-02-25'

The pass with relationship filter has "WHERE FACT.Location = 5 and FACT.PeriodID = '2004-02-25'.

Is this a defect or am I missing a setting somewhere?

 
You may have found a bug. See if you can work around the isssue with a report filter, or a straight filter code with "applycomparison" .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top