|
|
|
|
| Re: how to create this matrix report? [message #616261 is a reply to message #616253] |
Sat, 14 June 2014 06:02  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Reports Builder is clear enough: Oracle
REP-1302: Cross product has two or more child groups.
Cause: A cross product group has more than one child group. Only one child is allowed per cross product group.
Action: Remove all but one of the child groups to the cross product group.
It means that you'll have to put any additional information into just one child group.
If possible, prepare information you need to display in the report elsewhere, such as in a view (if you can do that within a single SELECT statement), or by using the global temporary table you'd populate using some PL/SQL code which can be called from the database (as a stored procedure) or can be located in your report (under the Object Navigator's "Program Units" node) and called from one of report's triggers (such as "After Parameter Form").
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
