Create Reports

[LANuser99]

Hi.

I´m trying to create a report there I would get the information like this.
tblDisplayConfiguration ( Caption )
and also
tblSoundDevice ( Caption )

But it only complaince about Duplicate Caption 😞
Is it possible to create a report where it displays both these fields.

// Thanx

[LANuser99]

with Alias, it works great.

Thanx

[Hemoco]

Can you post the sql of your not working query please.

[LANuser99]

Column names in each view or function must be unique. Column name "Caption" in view or function "web40repSystemconfigs" is specified more than once.


In this case ... I use the " Caption Nvarchar(450) " in tblSoundDevice and "Caption Nvarchar(450)" in tblDisplayConfiguration

I want the result to show me... What SoundCard AND VideoCard that the Computer has.

// Thanx

[Hemoco]

Can you post the SQL or error that you get please.
You can use the "alias" field to rename one of the fields so you don't have duplicates.