Topic: Parameter Question Posted: 13 May 2019 at 5:09am
I have a report with {comment} fields. I want to create an optional parameter that excludes line items that have a comment field that include the word "Screen". I have played around with a NOT LIKE "*Screen*" in the Select statement and that works fine but i am not sure how to make this work based on a optional parameter entry. Suggestions????
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 13 May 2019 at 5:24am
are you always using the same word?
If so make it a required filter and set it to a true false and use that in your select criteria
(filter=FALSE or (filter=TRUE And table.field NOT LIKE "*Screen*"))
you can set the select filter as something like "include Screen" and "Exclude screen" instead of true/false
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 13 May 2019 at 7:22am
sorry yes the filter would be the runtime parameter you create like "Has Screen Included".
{?HasScreenIncluded}=False
after crystal xi i think optional parameters were available and you can use the HasValue() function to see if a param was being used by the person running the report.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum