Skip to Content
author's profile photo Former Member
Former Member

XLR - how many records?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 08:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.