Field alias in Crystal report

[nidy]

Hello,

I am trying to how to create field name alias in crystal report. I have two instances of same table in my report and I need to display same field of each instance in the report. Can somebody please tell how to create field name alias in crystal reports during design time.

Thanks,

Nidhi

 

[synapsevampire]

Please remember to post your software version.

When you place the table into the report a second time, the table will be automatically aliased.

As for fields being aliased, that's generally a function of the database, and were you to take the time to post your Crystal version and the database being used, we might be able to use that sort of functionality using a SQL Expression.

No matter what version you have, you can ALWAYS create a formula in Crystal and put the field in the formula to emulate an alias.

-k

 

[nidy]

Hello,

I am using Crystal Reports that come with MS Visual studio 2003 and database is SQL Server 2005. I looked into formulas also but not sure how to create field alias using formula.

Thanks,

Nidhi

 

[synapsevampire]

It isn't a field alias, create formula and name it whatever you want, then place the field in the formula, now you can refer to the field by the new name.

Another option would be to create a SQL Expression and place something like:

table.field MyAlias

in there.

-k

 

[IdoMillet]

Why do you need a field alias? Crystal already has an alias for the 2nd instance of the same table, so the field name is already "qualified" within Crystal.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com