Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Fixed size of BLOB report column

Spooky
Member Posts: 46 Blue Ribbon
Hi!
Apex 4.0.2 version, Theme 1
I am trying to set fixed size of inline blob image column showing in classic report. So, whatever size of image is saved in the table, I want to show it at fixed size. And if there is no image corresponding to the row, then that empty space should stay also.
I hope you understand the question...
Thanks!
Apex 4.0.2 version, Theme 1
I am trying to set fixed size of inline blob image column showing in classic report. So, whatever size of image is saved in the table, I want to show it at fixed size. And if there is no image corresponding to the row, then that empty space should stay also.
I hope you understand the question...
Thanks!
Tagged:
Best Answer
-
Spooky wrote:Specifically, the value of the <tt>id</tt> attribute in the column's <tt>th</tt> element:
Thanks!
It's not working.
What do you mean by table header ID of the image column? Is that column heading, i.e. column name?<th id="PHOTO" class="header">...</th>
which can be seen using a web inspector or by viewing the page source. Usually this is the column alias ( not the column heading) used in the query and shown in the report Column Attributes.
Answers
-
Request a workspace at apex.oracle.com and import your application there. Post a link to your application here once you're done.
Should take no time at all. Once done, I'll login and take a look.
Keith Malay -
Spooky wrote:Images can be resized using CSS. Add a style sheet in the page HTML Header property:
Apex 4.0.2 version, Theme 1
I am trying to set fixed size of inline blob image column showing in classic report. So, whatever size of image is saved in the table, I want to show it at fixed size.<style> td[headers="IMAGE"] img { display: block; width: 75px; border: 1px solid #999; padding: 6px; background: #f6f6f6; } </style>
where the <tt>IMAGE</tt> value in the attribute selector is the table header ID of the image column. Setting only one dimension (in this case the width) scales the image with the correct aspect ratio.
However, if the original images are large then scaling them in the browser this way is a huge waste of bandwidth and produces poorer quality images than creating proper scaled down versions using image tools. Downloading megapixel images and then reducing them to thumbnail size results in pointlessly pushing millions of bytes that will never be seen.
For improved performance and image quality, and where you require image-specific scaling the best approach is to use the database ORDImage object to produce images of the required size automatically. (Note that this is not possible in Oracle XE as Multimedia is not included.)And if there is no image corresponding to the row, then that empty space should stay also.That depends on what you mean by "that empty space", and on the method used to display the image. Provide more details, or an example on apex.oracle.com. -
Thanks!
It's not working.
What do you mean by table header ID of the image column? Is that column heading, i.e. column name? -
Spooky wrote:Specifically, the value of the <tt>id</tt> attribute in the column's <tt>th</tt> element:
Thanks!
It's not working.
What do you mean by table header ID of the image column? Is that column heading, i.e. column name?<th id="PHOTO" class="header">...</th>
which can be seen using a web inspector or by viewing the page source. Usually this is the column alias ( not the column heading) used in the query and shown in the report Column Attributes. -
Ok, I get it now and it's working.
Thanks!
This discussion has been closed.