Report Column Headers from Database table

Please is it possible to get the reports column names from database table via stored proc or a select query.

Because reports needs to be localized between spanish and english users, so if a spanish user is logged into the system, it must bring all spanish column names from DB table and show in the headers, same with english users.

Thank you very much for the information.

I am using SQL 2K Reporting services.

Are the column names from a different dataset than the rest of the data in the report? If so, you have the following options:

1. Modify the query to return them in the same dataset (since you can't use two datasets in the same table).

2. Modify the report to include two tables, one only has the table header for the column names, the other (without header) displays the detail data, and align them appropriately.

3. Use subreport embedded in the table to display the detail data.

sql

Report Builder localized in spanish

I work with an English SQL Server 2005 license , but would like that the Report Builder tool presents itself in spanish in the client computers .

I can localize the Report Manager to spanish without problems (configuring the spanish language in IE) , but the Report Builder still presents its interface in english .

How can this be achieved ? With Regards ,

George

You must have a Spanish version of the operating system, or a multi-language pack that allows you to change the operating system UI to Spanish. IE language settings do not affect Report Builder.