| :: Help needed with flitering :: (2) | Post a New Message | Post a Reply |
 Help needed with flitering | Post a Reply |
from: MIdlands. UK
I hope you can help me with this problem.
I am working on an enquiry via the Wizard, accessing a view in an SQL server database. The enquiry has a composite of 3 filter boxes shown on the first screen. The first 2 field filter boxes use “contains” filters for the fields in question – no issue here.
However, I want the third filter box to either allow the user to enter a value which can be used as a “contains” field value for the third field, or to be ignored if the user does not want to enter a selection in the third filter box.
So the resulting query could either be:-
Field 1 contains “xx” and Field 2 contains “yy” and Field 3 contains “ZZ” or Field 1 contains “xx” and Field 2 contains “yy”.
I would like to achieve this in a single enquiry. I have had a look around the Forum postings and can see nothing that immediately addresses my problem. Can you please advise me how I can achieve this? I am using program version 2.0.0.615.
Many thanks.
| Re: Help needed with flitering | Post a Reply |
from: Washington, DC
The demo for the report wizard .net version should go live by the end of this month (without the ReportBuilder component). We anticipate a beta release sometime next month.
Below you can see the image of the [Filter Screen] of the report builder - showing how to set multi-level filters. Notice that it includes separate groups of conditions. i.e. If (A and B) OR (A and D) etc.
Thanks for you patience.
Coming soon!
-------------------------
Ghost