Hi all!
I want to create a Matrix report from the following datamodel
1. Customers table
2.Products table
3. Customers2Products
In matrix Cells I want to display "YES" if the customer has bought a product and "NO" otherwise.
It works perfectly for YES case but for No case it doesn't appear...
When you select a field and you press F4 you get Property Palette
At the end of the properties list there is one which say "Print on " : First Page, All pages ...
Best,
T.
Hi all!!
How can I link Table and Ref Cursor Table??
I mean, How can I pass input parameters to the PL/SQL procedure if they are not User parameters but they come from another table??
Thanks a lot
F.
Hi all!
Do you know why this query works perfectly in sqlplus and I get an error in Oracle Reports?
select t.doc_id
into num_memo
from jk_address_a ver,
table (select text
from jk_address_a v
where v.person_id = num_person...
Hi!
My layout(Body) has some fields at the top (A,B,C) and then a matrix layout. When the matrix is too big, it's displayed in several pages.
How can I do to repeat (A,B,C) on each page??
Thanks a lot!
f.
Here are the layout and datamodel:
http://tlloreti.googlepages.com/layout.JPG
http://tlloreti.googlepages.com/modelodatos.JPG
Thanks for your help!!
F.
Hi!
i'm trying to create a matrix report but I get the following result:
http://tlloreti.googlepages.com/incorrectmatri.JPG
and I don't know what is wrong!!
Can you help me?
I would like to obtain something similar to:
70000000107 70000000109
PH
PESO
with results in...
Hi all!
I have to create the following report:
1. I query column1,column2 from Table A
2. depending on column2 value I have to access to different tables: B1, B2 to get more information which must be displayed on my report
How can i do it??
Can you recommend me some tutorial?
Thanks!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.