Hi,

Brand new to the world of reporting objects, please bear with me! I'd like to take the value of a filter that the user has selected at run time and use that value to dynamically populate values in the where drop-down list?

i.e, If using the car file, my user only wants to see data for cars that have 2 seats and has selected the filter for 2 seats. Now, I'd like to present them with a drop-down list of countries on the parameter selection page, but only include those countries that have cars with 2 seats.

In the reporting object where statements component I'd like to reference the value of the filter and then pull the correct values from a dynamic list. Just not sure how to tie the filter value to the where statement, if it's even possible.

thanks for any help in advance.. much appreciated!

This message has been edited. Last edited by: FP Mod Chuck,

If I understand your need : you want to filter the Countries based on Seats selection and both from the same Reporting Object (RO) ?

A RO cannot filter itself based on its own filter selection. You can have multiple selection, but not related one to the other.

What you are asking for is a "chained control" and this is available from HTML not RO. As far as I know...

You need to create an XML file with possible value then create two controls in HTML where both refer to the same XML fex file then have them chained.
It is possible that TechSupport will become you better option to help on how to accomplish the above since it may be a little difficult to explain all the steps here.

Sample of XML fex file wich display Countries according to number of Seats :

TABLE FILE CAR
BY SEATS
BY COUNTRY
ON TABLE PCHOLD FORMAT XML
END

yes, you're right Martin. I was trying to use the filter selection and then populate the where statement based on the filter. I couldn't see any way to do it using the tool but wasn't sure if anyone had a way around that.

The reporting object functionality seems to have very little documentation and I can't find any samples so it's just been a bit of a struggle to put all the pieces together.

thanks for your help with this Martin.

There seems to be plenty of doc here:

https://webfocusinfocenter.inf...eb_based_tools51.htm

As I mentioned, this is not something that you can perform using RO.

You must create chained controls and use HTML Composer.

If you are referring to Filter Group to have pre-defined WHERE condition, refer to Babak link to documentation under "Filters"

This message has been edited. Last edited by: MartinY,