
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2010 01:39 PM
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
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
Labels:
- Labels:
-
Archive
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2010 01:40 AM
with Alias, it works great.
Thanx
Thanx

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2010 12:53 PM
Can you post the sql of your not working query please.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2010 11:05 PM
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
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2010 04:11 PM
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.
You can use the "alias" field to rename one of the fields so you don't have duplicates.
