Home » Developer & Programmer » Reports & Discoverer » how to create this matrix report?
how to create this matrix report? [message #616252] Sat, 14 June 2014 05:38 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
table:products with filds:p_id,p_width as wid,p_weight as wei,p_quality as qly
see attachment files
the matrix report is problem.jpg
how to create this report?
------------------------
i create data model,but this error show:rep-1302:A cross product group has more than one child group. Only one child is allowed per cross product group.
data model is attachment
  • Attachment: problem.JPG
    (Size: 109.94KB, Downloaded 405 times)
Re: how to create this matrix report? [message #616253 is a reply to message #616252] Sat, 14 June 2014 05:40 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
error in data model
  • Attachment: error.JPG
    (Size: 75.62KB, Downloaded 421 times)
Re: how to create this matrix report? [message #616261 is a reply to message #616253] Sat, 14 June 2014 06:02 Go to previous message
Littlefoot
Messages: 21509
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").
Previous Topic: set the text fild alignment
Next Topic: lines in matrix report
Goto Forum:
  


Current Time: Fri Nov 15 01:45:40 CST 2019