1,262
Hello Community,
I was wondering if there was a way to get the Number of rows inside a footer.
I tried the RowNumber function but it is giving an error as it is not allowed to use it inside a footer or header
thank s a lot for your help,
Kind Regards,
Jihane
*This post is locked for comments
Since RowNumber() function can only be used in the report body to retrieve the number of rows in the specified scope, we could not use it in either the Header or Footer area.
We could use other counting function such as CountRows() or Count() to retrieve the number of rows returned for the dataset.
=CountRows("MyDataset")
OR
=COUNT(Fields!Name.Value)
Hi Jihane,
The header and footer sections are used to display the single row data such page number, invoice date, invoice number etc which is common for the whole report and does not have different values based on each record. This is the reason, you can't put table control inside header and footer section. I hope you understand my point.
Considering the above, if you can let me know what are you trying to achieve, may be I would be able to suggest you better solution.
Thanks,
Baber.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (