Very Very Urgent - Matrix Help Required

[urchin556]

Hi Guys,
I am making a matrix report in which there are 3 cells.I am taking this report format into excel with fields as comma seperated so in the layout i had put ',' after every field.But in matrix if there is no record for that row and column it doesnt print ' ,' which is in the cell.But i want that to print so the layout will be proper.Please if anyone can help me out in this issue.
My query is very huge so i cant do much with that.

 

[nagornyi]

You can not solve this on the layout side. If rows and columns do not come from the SQL, there is nothing to display. Looks like you know which columns and rows you need on the report. So you may either try a tabular layot instead of matrix with cells populated by formulae, or to add union clause to your SQL that would bring some dummy records for all possible rows and columns (like selecting their names from dual).