| | |
Not able to generate Report
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Aug 2005
Posts: 1
Reputation:
Solved Threads: 0
hi,
How do I get cell value of each column field in the matrix report. I have simple matrix report which has column field as DivisionNo,Row field as AccountNo and cell field as Credit_Amount whose source is DATABASE column. And I have Summary column for account wise ie rowwise summary. I am trying to generate report against accountwise and divisionno and supressing whose summary is '0' but the problem is it is supressing a row whose summary is '0' but it has values for some of the column field value for particular row.
I would like to know how should I track the value of each column field(ie repeating field whose direction is across) The cell field is Credit_amount. how to trap value of credit for each division so that I can supress only those rows whose summary value is '0' and it has some value in column fields.
Thanks
Ram
How do I get cell value of each column field in the matrix report. I have simple matrix report which has column field as DivisionNo,Row field as AccountNo and cell field as Credit_Amount whose source is DATABASE column. And I have Summary column for account wise ie rowwise summary. I am trying to generate report against accountwise and divisionno and supressing whose summary is '0' but the problem is it is supressing a row whose summary is '0' but it has values for some of the column field value for particular row.
I would like to know how should I track the value of each column field(ie repeating field whose direction is across) The cell field is Credit_amount. how to trap value of credit for each division so that I can supress only those rows whose summary value is '0' and it has some value in column fields.
Thanks
Ram
![]() |
Similar Threads
- Generate Report as PDF and Excel file (Java)
- Need to generate a weekly report in asp -- DateFormat(Now() - 7 days (ColdFusion)
- MSN error Report - HijackThis Logfile (Viruses, Spyware and other Nasties)
- VB.NET: how to generate report of transaction in ebanking project (VB.NET)
- Windows Journal (Windows NT / 2000 / XP)
Other Threads in the Oracle Forum
- Previous Thread: Why won't I be prompted for input
- Next Thread: PL/SQL + Apache2
| Thread Tools | Search this Thread |
Tag cloud for Oracle
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware erp federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho





