All geek questions in one place

Get table row counts outside the table in SSRS 2008

I can count the rows in the data set that the table consumes, but this does not return the correct value, since the data in the table is grouped.

I need to know the size of the table in order to dynamically change the chart that is displayed along the table.

CountRows is clearly not suitable, since you must be in the table area, but it is not.

Any ideas?

+3
source share
3 answers

, : [# ] + CountRows ( "[DataSetName]" ) + CountDistinct (! [group1groupby].Value, "[DataSetName]" ) + CountDistinct (! [group2groupby].Value, "[DataSetName]" )... ..

+2

tablix, - "= CountRows()". , , . ( Textbox10) "= ReportItems! Textbox10.Value". ( ) , , . , "Insert Row" → "Outside Group - ".

+3
  • tablix, .
  • (= CountRows ( "Tablix1" )). (Textbox20).
  • Tablix. (Name is Textbox50).
  • .. like (= ReportItems! Textbox20.value)
  • .
0
source

Source: https://habr.com/ru/post/1740327/

More articles:


All Articles