Category

 

I want to select a date range but I only want a particular schema and category name to always be shown.

 

So, for an example, I want to select 12/5/10 to 12/6/10, I always want to see the schema name of "AcmeB" and "AcmeC," and Category names of "1," "2," "5," and "6."

 

I have created a startdate and enddate parameter and set

{datefield}>={startdate} and {datefield}<={enddate}, which works well.

 

Can somebody assist me? I think there should be a pretty simple answer to this that I'm overlooking.

 

Thank you.  

 

({Schema}="AcmeB" or {Schema}="AcmeC") and 
({Category}="1" or
{Category}="2" or
{Category}="5" or
{Category}="6")
and ({date}>={?StartDate}
and {date}<={?EndDate})

 

I hope this helps someone.