Show data from one data set but subsitute its data from other data sets

ianlufc

Hey Guys i have a problem and not sure how to sort it out<br />
<br />
Kinda hard to explain iv attached a .rptdesign file which may make reading this easier if you have it open.<br />
<br />
I want to display all the data for "License info" data set BUT subsitute data from the other data sets depending on the value of whats in "License info" columns..<br />
<br />
e.g.<br />
"License info" data Set CERTTYPE column <br />
CERTTYPE <br />
10<br />
11<br />
12<br />
13<br />
14<br />
<br />
<br />
I in "LicneseTypeEnum" Data set has values 10,11,12,13,14<br />
and the name part that asociates to these values<br />
<br />
"LicneseTypeEnum" Data Set<br />
<span class='bbc_underline'>I : NAME</span><br />
10 : blue<br />
11 : black<br />
12 : red<br />
13 : orange<br />
14 : yellow<br />
<br />
<br />
<br />
So when i show all the data from "License info" instead of showing the 10,11,12 etc from CERTTYPE, i would like to show the corresponding <span class='bbc_underline'>NAME </span>column from "LicneseTypeEnum"<br />
<br />
I will be doing this for most of the columns in License info

ianlufc

Hey

I used a joint data set and this enables me to join 2 datasets but can i join one data set to more than one other data set