
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2010 02:33 PM
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
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
Labels:
- Labels:
-
Report Center
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2010 04:29 PM
thanks it works fine now

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2010 03:54 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2010 02:43 PM
ok But how do i change the colum names

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2010 02:39 PM
You can several fields with the same name (caption).
You need to give them another name
You need to give them another name
