Count rows of a report

[churchy]

Hi,
I am trying to count the rows of a report. I am creating a calculation item within FM with this expression:
count(DISTINCT [Business View].[Sales].[Sale_ID]  for report)

the problem is that this calculation shows the TOTAL number of records without taking into account that if my report has any filter its value is wrong... i mean, this value is static ,if i apply any filter this value is not refreshed.
How can i show the number of the rows in the report creating fhis formula in Framework Manager (not whithin the report)?.

I have also use "Count(Rows for report)" but it still doesnt work.

[COGNOiSe administrator]

This type of count has to be done on the report itself. Create a second query which uses the first one as reference and count the rows there.

Sample report specification based GOSAR 8.2 attached.

[churchy]

Thanks for yor solution!

[platinne]

Hello,

Have you tried the 'prefilter' option in your statement?

count(DISTINCT [Business View].[Sales].[Sale_ID]  for report prefilter)



Patrice