ReportServer Forum

mactuan12

Member

Registered: 2020-01-11

computes colums in dynamic lists

I'm struggling a bit with computed columns for dynamic list reports. The documentation is somewhat limited wink and so far I've not been very successful. For example I'd like to create a computed column from an existing date column so I can group records by month or year. I've tried to use Postgres' date_part function:

but get a "Could not tokenize" error.

So I guess I'm wondering what kind of expressions can be used when creating computed columns. A few examples would probably go a long way.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: computes colums in dynamic lists

Hi mactuan12,

You have to put in the whitelist the expressions you want to be able to tokenize.
https://reportserver.net/en/guides/conf … mic-Lists/
https://reportserver.net/en/guides/conf … dcolumncf/

E.g.: Add:
<function>date_part</function>
to the configuration file dynamiclists/computedcolumn.cf

Then you have to restart reportserver to load the configuration or write "config reload" in the terminal (if you have EE)

Please note: be careful to not to add "too much" to the whitelist in order to avoid sql injection. The whitelist is there in order to prevent sql injection and give you the control of which functions are allowed.

Regards,
Eduardo