#1 2020-03-27 04:47:44

anirudha.k
Member
Registered: 2020-03-26

select aggregate function error in pivot report

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

#2 2020-03-27 08:50:59

eduardo
Administrator
Registered: 2016-11-01
Website

Re: select aggregate function error in pivot report

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

#3 2020-03-27 12:31:44

eduardo
Administrator
Registered: 2016-11-01
Website

Re: select aggregate function error in pivot report

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

#4 2020-03-27 13:02:10

anirudha.k
Member
Registered: 2020-03-26

Re: select aggregate function error in pivot report

Yes,
I have found that.
Thanks

Offline

Board footer

Powered by FluxBB