How can I set the column width of a column in a classic report?

user1.0

I'm working in Apex 19.2.

I have a classic report that selects several columns with different data types. Right now all the columns are the same length. I would like to shrink some columns to save space on the page. For example, the Year column doesn't need to be _____________________ long. I only need 4 character length.

If I try to format the length in the query, like this:

    APEX_ITEM.TEXT(4,ACTIVE_YEAR,'style="border:none;width:32px" class="right-align" id="YEAR_'|| AMT_ACCUMULATOR_REF_NUMBER ||'"') ACTIVE_YEAR,

I get a not a number error just running the query.

I put this code in the HTML expression for the column:

<span style="display:block; width:32px">#ACTIVE_YEAR#</span>

and got the box to change size but the data entry field is the same length. It looks like this now.

I changed the cell width to match the size of the box:

It had no effect as you can see in the screen snippet.

So, how do i get the Active Year box AND the data entry field corresponding to that box to be the same size?

fac586

See related thread:

https://community.oracle.com/tech/developers/discussion/4491542/how-can-i-get-rid-of-the-space-between-columns-in-a-classic-report

user1.0

I figured this one out. I needed to add 2 parameters to my apex_item

APEX_ITEM.TEXT(4,ACTIVE_YEAR, NULL,4,'style="padding: 0px 0px 0px 0px;margin:0px;white-space: nowrap;width:35px;text-align: right;"') ACTIVE_YEAR

I still think it would be nice to know why setting the cell width didn't work when that was what was suggested in an earlier posted solution.

TexasApexDeveloper

Because being polite here you are running up an ice covered hill in flip flops... Trying to manually implement a pseudo-tabular form in APEX 19.x is beyond wrong.. you SERIOUSLY need to take the time to LEARN how to work with an interactive grid, as apposed to trying to kludge together a simpler (NOT..) version with APEX_ITEM and a standard report..

Thank you!

Tony Miller

White Rock, NM

user1.0

I get it - no one likes the old way of doing things. But we have an entire new system built on classic reports because the IG wasn't able to do what was needed. Unless it's been deprecated, then it's my understanding it's still supported.

I was hoping this particular use case would work in IG. I'll try it a 4th time.

I'll probably have to add a delete button which will break things but my users won't be happy using the action menu to delete a record. The delete button is a must have.

user1.0

Nothing in this thread has been helpful. If an admin can close it you might as well do so.

I already solved the issue myself and I'm not getting any helpful feedback anyway.