Create a data item display the same total value in each row

[andershedin]

Hi guys, im trying to create a data item that will display a count distinct [Account Numbers] for the table, and have it repeated on each row with the same value without incrementing.

I tried Count (Distinct [accountnumber]) but it only displays '1' for each row. Thanks for any help

[MFGF]

Hi guys, im trying to create a data item that will display a count distinct [Account Numbers] for the table, and have it repeated on each row with the same value without incrementing.

I tried Count (Distinct [accountnumber]) but it only displays '1' for each row. Thanks for any help

Have you tried count(distinct [accountnumber] for report)

Cheers!

MF.