Dynamic Filter?? 1

[DugzDMan]

Is there a way to filter data differently depending on the value of the section break it is in?

Here's an example of what I have:

Non Meetpoint
      Type 1
      Type 2
      Type 3
Meetpoint
      Type 1
      Type 2
      Type 3

Even though data exists for Type 3 in both areas, I want to not display it when it is in the Meetpoint section. Is there some way to put a formula in that says if Section = Meetpoint, then Filter out Type 3?

Thanks,
Doug

 

[Sridharan]

Hi,

Create a flag variable using IF THEN ELSE and have it return either 1 or 0 and filter the report based on the flag variable. You are on your way.

Sri

 

[DugzDMan]

Great idea! I must have been tired last night

Anyway, I've created the variable "Hide Meetpoint miscellaneous", but when I try to use that in a filter it doesn't show up in the list of variables. Did I do something wrong? I can see it in the list of variables.

Thanks!

 

[DugzDMan]

Sweet! I got it. I had to add it to the table with the data, filter it, then hide that column. OK, this works, but is it the right way to do something like this??

Thanks Sri!

 

[Sridharan]

Hi,

Great Ideas doesn't always need to work at the first instance, but it has to work inorder give that tag ;-) .

Now to the topic:-

What is the object type of Type1,Type2 or Type3 or simply what type of object you have created the variable "Hide Meetpoint miscellaneous". Is that a Dimension??? Hope it is so. In that case you can right click on the column and choose Insert Filter.

Sri

 

[Sridharan]

Hi DugzDMan,

There are lot of ways to accomplish things and there is no right or wrong way. All the matters in the end is its gotta work for us in the way we intended.

Hey thanks for the Vote mate . Its a long time since someone has voted for me.

Thanks
Sri

 

[DugzDMan]

Ok, one more for ya Sri. Is there a way to populate a drop down box (versus the text box or values button) with the items for the prompt?

(Gotta love end-users, gotta love end-users, repeat until I believe it

 

[DugzDMan]

Doh! I put this in the wrong post. I meant to put it in the Force LOV Selection one.