Home » Developer & Programmer » Reports & Discoverer » Make a field height as the one in the report (Oracle Developer 6i)
Make a field height as the one in the report [message #663983] Fri, 30 June 2017 10:18
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
Hello, I have created a group-left report with the following query ;
 select document_id, document_date, 
       sum(document_money) over (partition by document_id, document_date) as sum_money,
       document_details
from   documents; 
Most of the times.
The group fields are : document_id, document_date, sum_mony and one not grouped field which is document_details.
Most of the time document_details retrieve many rows with one row for the other field. I would like the other field to have the same height as the document_details field. I will upload the report I have been working in. You can see that the fields are a bit different with the names. In the report you have :
SRF_NO, THE_DATE, TS_MONY, SL_MONY, Details.
The group left fields are : SRF_NO, THE_DATE, TS_MONY, SL_MONY.
So, most of the time "Details" have more rows than the others. How can Set the height of the other fields as "Details" ?
Previous Topic: How to print fixed position text at the bottom of last page?
Next Topic: setting vertical elasticity overlapping on lines below it
Goto Forum:
  


Current Time: Sat Nov 18 04:20:13 CST 2017

Total time taken to generate the page: 0.01436 seconds