Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying Blank Value fileds also from the DataBase

Hi,

I have included two queries in my report and linked them.

I have grouped data based on Region and displaying Country --- its corresponding values from both queries. say Part1 and Part2

On running the queries seperately !

From the 1st query, COUNTRY FIELD (Africa) has some values for the parameter 'YEAR' value -(2007,2008). But from the 2nd query, Aftrica has value for parameter YEAR 2007, blank values for all coloumns for YEAR 2008.

On linking the two queries in a single report and placing the fields, Because of 2nd query's BLANK values for YEAR 2008, Africa is not displayed at all..

I should get those values of Africa from query 1 to be displayed in the 1st part and blank values of query 2 also to be displyed in the second part.

Please help me in solving this issue..

Thanking You..

Regards

Eswari.B

replied

Hi Eswari,

Go in Database Expert and Link Tab and change the join type to Left Outer Join or Right Outer Join according to your Table structure.

Thanks,

Sastry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question