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: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior 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" ?
|
|
|
Goto Forum:
Current Time: Fri Feb 21 11:11:52 CST 2025
|