BI publisher 10g Include Empty Tags for Null Elements
Hello, it was recomended that I post my query here. I am newer to Buplisher and it may be easy but I am not sure how to get my values lined up in the correct columns.
I have a report that I am grouping by element a by month. So that each month is a column and each element a is @cell. What is happening is when the element does not exist for a given month the element values shift to the left becuase no value exists for that month.
What I would like to do is enter some value ) or NA or leave it blank for that element value for the that given month. So for instance month 1 has 10 different rowsets of data with elements of type 1 and 2. But month 2 has 10 rowsets of data elements of type 1, 2 and 3. We are then suming the count for each type and puting it in the column.
0