You are not logged in.
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
Pages: 1
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.
Offline
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
Offline
Pages: 1