Yes, this is definitely possible.
Create a filter for each desired CustID (suggest naming the first filter "1" for example), then use the File -> Export wizard and specify you want to Export All Filters.
You will then be given the option of creating one single Excel file with multiple worksheets (each worksheet can be named based on the filter name), or a series of individual Excel files within one folder (each file can be named based on the filter name).
Thanks Mike. The only issue I see from our side is that the report is huge & there are a lot of CustIds; which means that we will have to create those many filters manually; and every time we have a new Customer, we will have to make sure to create a new filter.
Is there a way to create the filters dynamically, based on the data in the report?
Have at look at [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000371#000001"]this thread[/url].
I haven't needed to try Nick's solution myself as yet, but it sounds like this is what you need.
Let us know if this approach works for you.
[size="1"][ May 01, 2006, 05:31 PM: Message edited by: Todd Niemi ][/size]
Both of these solutions, IMO, would require a two pass approach. 1st Pass would be to get a unique list of all the CustIDs from the report and then use that report and pass the IDs to the /set option[/b] or the SetRuntimeParameter()[/b] function.