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 3For 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 6For 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 97Is 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 3Pls. help.