The client distributes to each salesperson a spreadsheet summarizing sales attributable to that salesperson for the prior month. I created a GridView called "Monthly Commission - Slpn Summary" with multiple filters, one for each salesperson (e.g. filter "Slpn200"). I also created Adagio users for each salesperson (e.g. User ID 200, password 200).

The following couple lines are part of a batch file that uses command line parameters to successively launch the view and output the results to Excel in a folder \XDVIEWS\{User ID}. The end result is a series of identically named files in many different folders.

N:\Softrak\GVWIN\GVWin.exe /c /d"O:\ADAGIO DATA" /eDAT /u200 /p200 /xdp:"N:\STEVE\Monthly Commission - Slpn Summary.gvs" /xdf:"Monthly Commission - Slpn Summary:Slpn200"

N:\Softrak\GVWIN\GVWin.exe /c /d"O:\ADAGIO DATA" /eDAT /u206 /p206 /xdp:"N:\STEVE\Monthly Commission - Slpn Summary.gvs" /xdf:"Monthly Commission - Slpn Summary:Slpn206"

(etc)

Now the client is asking if the output can contain both the summary report and the underlying detail in a second sheet. The underlying detail is actually the same view and same filter but with the Summarize box unchecked.

What's the best way to do this?

I'm sorry for such a long and detailed explanation.

Steve

I think you may have to create a workspace for each salesperson? I'm not sure if you can specify two filters in two views in the same command, but that might let you get around the problem.

Hi Warren

Specifying two filters in two views in the same command is exactly what I want to do. Can I? I would be happy to use the same set of filter names if that would help.

Creating a workspace for each salesperson would be awful to maintain, but I guess it would work.

The reason I'm not certain is because I haven't had much experience with the XDF parameter. I initially assumed it wouldn't accept multiple /xdf entries, however the help definition does mention that "You may use multiple filternames on the command line" but I'm not sure if it means multiple filternames for the same sheetname or multiple filternames for multiple sheetnames.

Multiple filter names for multiple sheet names.