script module with if condition of a data loading field

[geogou1973]

Hello.

I have a script module in a trigger on post reload action that exports an excel file from a chart.

The script is :

Sub ExportFiles

pathcorp="c:\sales\"

set corp = ActiveDocument.GetSheetObject("CH01")

corp.ExportBiff pathcorp & "Sales.xls"

End Sub

The dimension of the chart is the field "store" and the expression is

sum ( { <date_id = { '$(=vdate)' } > } sales )

The date_id and sales are fields and vdate is a variable that returns the current date.

My issue is how can i export from a script module the data for all the stores i have .

What changes have to do in the script and the expression of the chart.

Thank you in advance

[alexandros17]

if you need to see all the rows (and export from the chart) add as dimension the date_id field ...

[geogou1973]

I don't understand what you tell me.

I want from this one chart to export data that concern each store, by store with the script module.

Let's say Store_101.xls ,Store_102.xls