Skip to Content
0
Former Member
Nov 15, 2012 at 05:56 AM

BEx query related

21 Views

Hi,

We have a query whose input variable is "date" and the output format is like:

Column1 Column 2 Column 3 Row 1 Row 2 Row 3

For example if the date is 13/07/2012, the output is like:

Column1 Column 2 Column 3 Row 1 2 56 6 Row 2 53 6 97 Row 3 4 5 6

For example if the date is 31/07/2012, the output is like: (Since no data is available for Row3)

Column1 Column 2 Column 3 Row 1 2 56 6 Row 2 53 6 97

Is it possible to fix the query so that the output format remains the same? If so, how? for example for 31/07/2012 the output is like

Column1 Column 2 Column 3 Row 1 2 56 6 Row 2 53 6 97 Row 3

Pls. help.