filter selecting all values

[Former Member]

how can you select all values for a filter without clicking on every checkbox or specifying a range??

i.e. you try to filter on sales order and it brings up 150 possible entries. obviously you don't want to click on every checkbox to select them all but you cannot use a range due to later drilldowns.

is there a cmd filter="all" that you could code behind a button or something??

[Former Member]

Red, I could tell you how to do this in BEx Analyzer, either using Report/Report Interface plus some of the BEx API, or how to do it directly with Visual Basic. But, I don't have enough experience with Web reports to be able to help you with this. Sorry ...

- Pete

[Former Member]

Ehh, could You explain why You need a filter that does not filter out anything ?

[Former Member]

yup. filter everything by an initial filter (in this case a date). then expand a column so that all sales order for that date are showing in the table. now create a filter which will hold all the sales orders for that date. then take off the original filter so that any sales order items that may have been changed on a different date can be seen.

if we don't hold/filter the sales orders returned by the original filter then when we remove it we get every sales order for every date.

[Former Member]

Red, are you referring to Web reports or Excel reports? The answer depends.

- Pete

[Former Member]

web reports