Rename DataSource Items

saidin · Post by **saidin** » Thu May 28, 2009 10:46 pm

Hi
Suppose that we have some tables in database and one of them is Table1 and we want to send table1's data to Stimulsoft report
when I do that in dictionary segment I can see DataSource >>Table1 and the columns of Table1(Col1,Col2) but I want to Rename The Table and column Titles in dictionary segment for example instead of Table1 see CustomerTable and instead of Col1 see CustCol1
thanks:grinder:

Post by **Edward** » Fri May 29, 2009 6:06 pm

Hi,

There is an Alias property in the DataSource and Columns as well. Just click in the 'Use Aliases' check box in the Dictionary panel in the designer and you will see aliases instead of the real names.

Thank you.

saidin · Post by **saidin** » Tue Jun 02, 2009 8:44 am

Hi Edward
No! No!:brick:
I mean that programmer(by source code) change the main names for exp column1 to colName that when user opens a report designer see the colName instead of column1
thanks

Post by **Jan** » Wed Jun 03, 2009 1:00 am

Hello,

You can change Name property of datasource and datacolumn. For example:

NameInSource: Table1
Name: CustomerTable

Thank you.

saidin · Post by **saidin** » Thu Jun 04, 2009 2:20 am

Hi Jan

My question is how we can do that? but you said you can do
please say how rename items by code(help , code or sample)

thanks

Post by **Edward** » Thu Jun 04, 2009 7:21 pm

Hi.

Here you are:

Code: Select all

report.Dictionary.DataSources["MyDataSourceName"].Alias = "NewAliasforDataSourceName";
report.Dictionary.DataSources["MyDataSourceName"].Columns["MyDataColumnName"].Alias = "MyNewAliasForColumn";

Thank you.

saidin · Post by **saidin** » Mon Jun 08, 2009 2:09 am

Hi Edward
I cant use the code
there is one DataSet:DsGlobal
there is one Table:table1
there is some columns of Table1

the following code has error: Object reference not set to an instance of an object.

Report.RegData(DsGlobal)
Report.Dictionary.DataSources("DsGlobal").Alias = "aaa" '<<Error Line

thank you

Post by **Edward** » Mon Jun 08, 2009 6:03 am

Hi,

Please modify your code as follows:

Code: Select all

Report.RegData(DsGlobal)
Report.Dictionary.Synchronize()
Report.Dictionary.DataSources.Item("MyDataSourceName").Alias = "NewAliasforDataSourceName"
Report.Dictionary.DataSources.Item("MyDataSourceName").Columns.Item("MyDataColumnName").Alias = "MyNewAliasForColumn"

Thank you.

saidin · Post by **saidin** » Tue Jun 09, 2009 8:52 am

Hi,

There is a problem.

1- when we use following code:
Report.Dictionary.DataSources.Item("Personal").Alias = "NewPersonalName"
Report.Dictionary.DataSources.Item("Personal").Columns.Item("Code").Alias = "NewPersonalCode"
In Report Design we have:
Personal[NewPersonalName]
Code[NewPersonalCode]

2- when we use following code:
Report.Dictionary.DataSources.Item("Personal").Name = "NewPersonalName"
In Report Design we have:
NewPersonalName[Personal]

but I want user see just :
NewPersonalName

Thank you very much

Post by **Jan** » Tue Jun 09, 2009 9:12 am

Hello,

Use following code:

Report.Dictionary.DataSources.Item("Personal").Name = "NewPersonalName"
Report.Dictionary.DataSources.Item("NewPersonalName").NameInSource = "Personal"

Thank you.