XLR - how many records?

[Former Member]

Hi all,

My cust is running a sales report by sales person.

In the report there is a parameter that allows him to select a range of sales people, a range of items, and a range of BPs.

I have a requirement where our client wants to summarize a report and in the summary he would like to see how many BPs he has selected and is reporting on.

Can anyone suggest how I could get that number displayed?

The number of sales people, the number of items etc.

I hope this is clear,

Thanks,

John

[Former Member · Accepted solution]

Hi John

You could have a field with a value of 1 in the expanding rows which you can simply total as normal. You can hide the column if you do not want it displayed.

A value of 1 next to each BP will give you the total no of BP's selected. This will only work, however if

'Do not display blank records' is unticked.

Regards