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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering on values that don't (yet) exist

Status
Not open for further replies.

smooveb

IS-IT--Management
Jul 20, 2001
161
0
0
US
Hi,

I need to created a canned report that will anticipate values that don't exist yet for sorting purposes. Is there a way to do this?

Thanks!
B
 
Hi,

You cannot do that in BusinessObjects. In the filter, you cannot select values that don't exist in the document.

If you want to select values using a logical choice and if you are able to transform you choice in to a formula, you can define a complex filter.

For example:
you go to Format>>Filters in the menu
then you add the objects you want to filter and click on "Define"
then you have to define a condition
e.g =SubStr(<Team> ,1 , 2) =&quot;GR&quot; to select only the team beginning by &quot;GR&quot;

Hope it will help

GKar



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top