cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bdirkx
Engaged Sweeper
I have made a report for export functions and when i wan't to save the report i get the error of. Collum Name of Caption must be unique.

This is a sample of my report.

Select Top 100 Percent tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, tblDiskPartition.DeviceID,
tblDiskPartition.Size, tblCDROMDrive.Caption,
tblDisplayControllerConfiguration.Caption,
tblPhysicalMemoryArray.MemoryDevices, tblPhysicalMemory.Capacity,
tblPROCESSOR.Name, tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion
From tblComputersystem Inner Join
tblComputerSystemProduct On tblComputersystem.Computername =
tblComputerSystemProduct.Computername Inner Join
tblDiskPartition On tblComputersystem.Computername =
tblDiskPartition.Computername Inner Join
tblCDROMDrive On tblComputersystem.Computername = tblCDROMDrive.Computername
Inner Join
tblDisplayControllerConfiguration On tblComputersystem.Computername =
tblDisplayControllerConfiguration.Computername Inner Join
tblPhysicalMemoryArray On tblComputersystem.Computername =
tblPhysicalMemoryArray.Computername Inner Join
tblPhysicalMemory On tblComputersystem.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputersystem.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputersystem.Computername =
tblOperatingsystem.Computername

Can annybody tell me whats going wrong.

Greetings

Bart Dirkx
4 REPLIES 4
bdirkx
Engaged Sweeper
thanks it works fine now
Hemoco
Lansweeper Alumni
In the report builder you have a column "alias"

Select Top 100 Percent tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, tblDiskPartition.DeviceID,
tblDiskPartition.Size, tblCDROMDrive.Caption As caption1,
tblDisplayControllerConfiguration.Caption As caption2,
tblPhysicalMemoryArray.MemoryDevices, tblPhysicalMemory.Capacity,
tblPROCESSOR.Name, tblOperatingsystem.Caption As caption3,
tblOperatingsystem.ServicePackMajorVersion
From tblComputersystem Inner Join
tblComputerSystemProduct On tblComputersystem.Computername =
tblComputerSystemProduct.Computername Inner Join
tblDiskPartition On tblComputersystem.Computername =
tblDiskPartition.Computername Inner Join
tblCDROMDrive On tblComputersystem.Computername = tblCDROMDrive.Computername
Inner Join
tblDisplayControllerConfiguration On tblComputersystem.Computername =
tblDisplayControllerConfiguration.Computername Inner Join
tblPhysicalMemoryArray On tblComputersystem.Computername =
tblPhysicalMemoryArray.Computername Inner Join
tblPhysicalMemory On tblComputersystem.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputersystem.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputersystem.Computername =
tblOperatingsystem.Computername
bdirkx
Engaged Sweeper
ok But how do i change the colum names
Hemoco
Lansweeper Alumni
You can several fields with the same name (caption).
You need to give them another name

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now