You are not logged in.
I am getting error on pivot preview while creating pivot mode report:
At least one aggregate function must be selected.
But I have an aggregate function in my sql query.
Any solution on this?
Offline
Hi anirudha.k,
you have to select the aggregate function in the dynamic list field configuration. More information here: https://reportserver.net/en/guides/user … amic-List/
Regards,
Eduardo
Offline
Hi anirudha.k,
in the documentation I sent you you can see this screenshot: https://reportserver.net/g/doc/en_pivot_config.png
Please check the "Aggregate" column.
Regards,
Eduardo
Offline
Yes,
I have found that.
Thanks
Offline