Alias in dataset "property binding" query - problem

dzish

Hi,

can you help me with problem of dataset property binding?
I have SQL query in property binding and there doesn't work keyword "AS". Because of error:
Column binding "CUSTOMERNAME" has referred to a data set column "CUSTOMERNAME" which does not exist.

I attached design report with datasource to classicalModels example. The are 2 tables:
1.table with classical dataset
2.table with dataset with query in "property binding"

thank you
Jan

dzish

I found workaround. For example for string column in sql query in property binding, you can use string function CONCAT(****,'').
Than there are no problems with data binding in table.