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
Hello
I'm trying to use names with capital letters and spaces in calculated columns in dynamic list
Syntax of select
select 'sometext' as "Field with space", 'sometext' as "Capitals"
When i'm trying to add calculated field using this fields I'm getting message:
concat(Field with space, Capitals) I'm getting error message 'Syntax error'
Using quotations " or parentheses [] or () does not help
Could you, please advice, how to solve that
source database is postgresql
Last edited by asmirnov (2019-06-27 16:11:38)
Offline
Hi asmirnov,
I see the problem. It seems to be a bug. I created ticket RS-3535 for this.
Until then, please use lower case for the column names in you want to use in computed columns.
Regards,
Eduardo
Offline
Hi asmirnov,
I see the problem. It seems to be a bug. I created ticket RS-3535 for this.
Until then, please use lower case for the column names in you want to use in computed columns.Regards,
Eduardo
Thank you, Eduardo
Will it cover also spaces in column names?
Do you have plan to fix in it terms of dates?
Last edited by asmirnov (2019-07-03 10:45:59)
Offline
Hi asmirnov,
we will take a look at this, and then we will have more information on dates / release time. But there is a workaround so please use the workaround until then. I will update here when we have looked into this.
Regards,
Eduardo
Offline