Report to loop through Sales People that have Sales in the selected period (and ignore those that don't).

[canoebi99]

Hi all, 

I am trying to create a report using the application automation to be emailed to all the Sales People that have sales in a given month. 

I have tried to do this by creating a report, then adding the sheets required and then adding a selection to the report for the current year and month (using the get variable block to collect the current year and month from the app). 

The challenge I am having is how to only loop through the Sales People that have sales for that period. 

If I use the "List values of Field" block or the Get Straight table block these both seem to ignore the selections I have placed on the report so I can only get a list of all the Sales People rather than just those with Sales for the period selected. 

Am I right in thinking that the add selection to report does not affect those blocks? If so is there a way to return a list of only the sales people with sales in the current year and month so that I can then use that list to loop through and select each sales person for sending out the emails? Essentially I want to return a list of the possible values from the Sales Person field once the year and month selections are in place?

Thanks in advance. 

[canoebi99]

Update: I managed to acheive this by adding a straight table into the app that had the required filtering (sales year and month) and Sales Person name so that I could use that and the get straight table block for my list. 

I suspect there is a better way so I would still appreciate further comments because I don't really want to clutter the app up with straight tables which I will have to doing things this way. 

[MBardy]

i all,

I am facing the same problem, how can we use "List values of field" based on previous selection in the report.

For the moment, "List values of field" output all possible value for a field, no matter if a selection was made before.

Example  : 

i want to generate a report with a first page "Region" and loop after on town of this region.

Even if i set a selection to the report on the "Region" field, "List value of field" on Town field will ouput all possible Town in the app.

Thank's