Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Variable text alignment in an interactive report

JustJeffJan 11 2018 — edited Jan 13 2018

Greetings.

Our users have an old Excel spreadsheet that they use to generate some reports. Being a red-blooded Apex-er I scoff at Excel and say we can do it better in Apex. And usually we can. But this one is giving me some problems.

Here's what part of the Excel spreadsheet looks like:

pastedImage_0.png

So I created a procedure that gets the data and writes it to a table. Then I created an Interactive Report in Apex that displays the data from that table (we're on Apex 5.1.3). Pretty straight-forward so far. What's killing me is getting the formatting/alignment right. After some trial and error (mostly error) I figured out how to incorporate some CSS stuff so I can control the font weight. And I can change the font colors and get rid of wrapping. But darned if I can figure out how to get the alignment right.

Here's what shows up in Apex:

pastedImage_1.png

Everything always aligns on the 'End'. On the 'Sales - Third Party' line I have this code: "text-align: left; font-weight: bold; ". So that line should be left justified. The font-weight command works fine. But I just can't get that text-align to work. It seems like nothing can replace this:

 ![pastedImage_3.png](https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/jive_attachments/4/6/1/46188454egami.png)

Does anyone have any ideas?

Thanks y'all!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2018
Added on Jan 11 2018
5 comments
1,083 views