Problems with alias and column name

Stimulsoft Reports.NET discussion
Post Reply
JeffB
Posts: 17
Joined: Fri Dec 18, 2009 9:24 am
Location: Toulouse (France)

Problems with alias and column name

Post by JeffB »

Hi,

I have a data source which have some columns.

One column is named "Description" and have as alias "Désignation" (I use alias for the translated name).
One other column is named "LongDescription" and have as alias "Description" (this "Description is the translation of LongDescription).

- When I put a text component into the report with "Description" as expression, "LongDescription" (Description) is used but not "Description" (Désignation).
I have tried to modify the wrong name by the other, but without success.

- If I create a report in which only the "Description" with his alias exists into the data source, I put a text with this column as expression in it then save it, I add the "LongDescription" into the data source and reopen the report, then the "LongDescription" doesn't appear. But if I create a new report with the two columns into the data source, these columns appear.

- If I change the alias of a column and try to use a previous existing report, the alias is not changed into the data source.

- I have seen the different columns of the data source written into the report file, is there a mean to update it ?

Thanks.

Best regards,
Jean-François
Mike Simpkins
Posts: 21
Joined: Tue Nov 30, 2010 1:06 pm
Location: South Dakota

Problems with alias and column name

Post by Mike Simpkins »

I assume you have already edited the DataSource in question and changed the column alias to something completely different, i.e. "MyDescription." When you do that, you will have to change the references to reflect the new alias in fields in the report. Using my example, you will find expressions for text fields in your report that will read {MyDataSource.Description}. These will need to be changed to {MyDataSource.MyDescription}. I would try this with a simple report first and see if you can get your aliasing working better.

I myself have struggled though this issue recently, give it a try and see if you can move forward.


Good Luck.


Mike Simpkins

Clueless in South Dakota
Jan
Posts: 1265
Joined: Thu Feb 19, 2009 8:19 am

Problems with alias and column name

Post by Jan »

Hello Jean-François,
JeffB wrote:Hi,
I have a data source which have some columns.
Can you send report with this problem to support@stimulsoft.com for examination. Please add reference to this forum topic.

Thank you.
Post Reply