Changing column headers.

[mike55]

Hi all

 

Simple questions, have a column name in my database called tempCallRef. Now I am doing a select * on the particular table and I and inserting the results into a dataset which is later binded to a third party reporting tool. When I view the report in the reporting tool the column name for tempCallRef is tempCallRef, and I would like to change this to something more appropriated as if anybody else looks at it, it looks un-professional. I am trying to do the following statement but am running into problems when I do a project build: Select tempCallRef as Call, column2, etc. however I am getting an error that tells me there is a problem near the word Call.

 

Any suggestions??

 

Mike55.

[Nerseus]

Couple of things to try:

1. To alias the columns, make sure you surround the name in brackets:

SELECT tempCallRef as [Call], column2

 

2. If using Crystal reports, I believe you can manually change the column headers after you've done your "binding". The column headers are only defaults.

 

3. If using a DataSet for binding, most binding grids and maybe reports can read the DataColumn's Caption. The Caption defaults to the FieldName (or maybe Name?) in the DataSet but you can change the Caption.

 

-ner