Hi,
I'm trying to add a data selection rule to a table in Jet Data Manager Data Sources. The field seems to contain boolean values (they show as 0/1 in SQL Server queries and True/False in Jet Table Preview). I've tried "Current Status = 1" and "Current Status = True". Using "True" causes the Deploy and Execute to fail and using "1" has no effect i.e. Deploying and Executing and then previewing table shows no impact.
I've also tried applying a filter to a numeric field in the same source and this also has no effect.
We have a filter working on another data source which works as expected.
Has anyone got any ideas? I must be missing something.
Thanks in advance
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Greetings!
There's a KB article on how to setup data selection rules (http://kb.jetreports.com/article/AA-00268).
If you hover your mouse over a table's fields in the Jet Data Manager, a pop-up will display the data type of the field. This will get you in the right direction of whether the field is text, numeric, or boolean.
Additionally, are you previewing at the source, or in the staging tables? If you have your data selection rules on the source, and are previewing at the source after doing a D&E, then make sure you're pushing the "apply rules" button to see your data selection rule(s) in effect.
Please sign in to leave a comment.