944,162 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 2935
  • Oracle RSS
Aug 18th, 2005
0

Not able to generate Report

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
kotturr is offline Offline
1 posts
since Aug 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: Why won't I be prompted for input
Next Thread in Oracle Forum Timeline: PL/SQL + Apache2





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC