simple cross tab dumpt to Excel

[atarrqis]

Oracle and CR11
I have a simple cross-tab but no experience with them.
I have 3 fields for the row - period, project, part
I just want all fields to show on all rows so when it exports to Excel the user can sort easily.
So instead of:
3 ABC 123
TOTAL
3 DEF 456
789
TOTAL

it needs to be:
3 ABC 123
3 ABC TOTAL
3 DEF 456
3 DEF 789
3 DEF TOTAL

 

[lbass]

You could get the three rows to show like that, but not the total. You might be better off creating a manual crosstab, but you haven't indicated what your column field might be or whether there are so many instances of the column that this is not feasible.

-LB

 

[atarrqis]

column = account and there could 99 so it didn't seem feasible. How would I do it if I gave up on the Total so just period would be on every line with project?
Thanks.

 

[lbass]

I would just concatenate the three fields and use that as a single row field:

totext({table.period},0,"")+" "+{table.project}+" "+totext({table.part},0,"")

-LB

 

[lbass]

Actually, if you want them in different cells, then use the concatenation formula as your first row, and then add period, project, and part as your second to fourth rows, and then just suppress the concatenation row label and minimize.

-LB

 

[SkipVought]

Just export your crosstab to Excel, since that's where its going, and then use Excel's Subtotal FEATURE (not the SUBTOTAL() function) to subtotal for each break as desired. Forum68.

You could also do the entire project directly in Excel, using MS Query to access your Oracle db.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]