I try to create one same variable in query designer for differents queries whiche have not the same field. I explain:
For example, I have one of my query based on a ODS which has a field called EAN but its technical name is RIS_R1007_F57 and I have another query based on another ODS which has also a field called EAN with the following techincal name RIS_EANMD_F1.
I would like to create a report with 2 tables and each query inside with in the variable screen, a variable which seeks in the both tables.
Anyone has an idea?
Thanks in advance for your help.
Edited by: rahhaoui mohamed on Jan 26, 2010 11:39 AM