Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error in exporting report to sql server

Status
Not open for further replies.

thminer

Technical User
Oct 11, 2005
16
US
i am having more problems exporting reprots to sql server. my report has a group header for the records it pulls from the source tables. when i try to export the report, the error message is "column names in each table must be unique. column GH2_employee in table CREXPORT is specified more than once." the column GH_2 employee is the group header for returned records, therefore, it is next to every record returned. how can i get around this?

thanx
 
Exporting to a database means that you MUST have columnar data, and that each column must have a unique name.

The notion of having groups doesn't make sense when exporting to a table.

A little resading on what tables are, and posting technical information here would serve you well:

Crystal version
Example data
Expected output (what you expect to find in the exported table in SQL Server)

-k


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top