If you are unable to create a new account, please email support@bspsoftware.com

 

How to create a distinct count and row count on the top of the report

Started by Falcon, 10 Jul 2024 02:47:16 PM

Previous topic - Next topic

Falcon

Total novice here....I have a report that is a simple list of work orders and by design one work order can be in multiple rows in the list. On the top of the report, I want to add 2 simple totals:

Distinct Count of Work Orders
Row Count

On the top of the report, I was able to insert a text item for the a label, but I cannot get anything to sit beside it. What is the trick to adding these type of calcs to the top?

When I try to insert a query calculation, it ends up looking like multiple rows and it is beneath the text item that I created.

What is the trick for doing this?

Thanks!


dougp

QuoteWhen I try to insert a query calculation, it ends up looking like multiple rows

I'm guessing you dropped the query calculation on the page?  ...and a list was created?

Try using a singleton.

Falcon

Thank you.  I created a block and then inserted two singletons.