0

I am trying to write an expression of Count Division based on price as shown in figure

table

I am doing group column on Division but how can I get exact no. of count in Count Division Column those having price in their division.

I wrote this expression for Count Division column =count(fields!Price.Value) but it's not working.

Can anybody help me?

ekad
  • 14,436
  • 26
  • 44
  • 46
mike juies
  • 15
  • 4
  • It is working fine for me. What are the values you are getting and what are you expecting it to be? – Anup Agrawal Oct 25 '13 at 14:35
  • possible duplicate of [IIF condition SSRS column grouping](http://stackoverflow.com/questions/19579468/iif-condition-ssrs-column-grouping) – Anup Agrawal Oct 25 '13 at 16:45
  • http://i42.tinypic.com/21d39fb.png This is the result I am getting when I select Division1,2,3 from Parameter. Actually it should count only those price values that are in Division and not all regardless parameter. I hope I am able to explain it – mike juies Oct 25 '13 at 18:29
  • What your report structure like in your report . if you use the matrix , As far as I know ,seems it is not possible to achieve your requirements via the built-in feature , you could try to use the custom code (vb) in report to do it. You could get detailed information about how to use the list collection in vb code bind with the ssrs report item . See: [SSRS - Pass Field Value List To Custom Function Assembly And Display Result](https://social.msdn.microsoft.com/Forums/sqlserver/en-US/686e9b74-4922-4298-9543-24432d51fedb) – Mitarai Queen Jan 01 '19 at 08:34
  • Seems a thread with the same requirement in msdn , you could check this [DYNAMIC month/year HEADER and REPEAT value](https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a8fc790d-3979-473a-8c3a-228234857fb6) – Mitarai Queen Jan 02 '19 at 02:09

0 Answers0