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