Sitemap

Amicuk Programming Answers

Print out of Report Region dropping negative values

2015-10-11   Views:0

Advertisement

I am very new to APEX (< 2 months) and don't have much of a programming background. I have created a report layout using BI publisher and made it available as a shared component in my APEX applicaiton. When I print the the report region, most of the

I am very new to APEX (< 2 months) and don't have much of a programming background. I have created a report layout using BI publisher and made it available as a shared component in my APEX applicaiton. When I print the the report region, most of the data displays fine on the print out, but any amounts with negative values are suppressed. I can view the negative amounts just fine when they are displayed on the report region itself.
It took me quite a while to get the style sheets from BI Publisher to work with APEX. I thought the two were supposed to be compatible. Does anyone know how to resolve the issue above or if their are any known compatability issues between BI Publisher and APEX? We are on APEX version 4.2.1.00.08 and BI Publisher version 11.1.1.

The replay answer
Advertisement
This was indeed a bug. Response from Oracle:
This issue has been noted by development as a bug and I have file bug 16224878 regarding your issue. The issue explained by development pertains numeric format string which wraps the negative value in angle brackets: < val > , and the report is treating this as a HTML tag and filters it out. It looks like this is happening only for classic report regions, i.e. report queries seems to support this type of numeric format mask.
A work around would be to turn off printing for the classic report region and to provide a button to a report query for printing, using the same SQL for the report query as is used for the report region. Alternatively you could also use a different format mask.

Go to See the other 7 answers

Print out of Report Region dropping negative values

Category:DefaultRelease time:2015-10-11Views:130

I am very new to APEX (< 2 months) and don't have much of a programming background. I have created a report layout using BI publisher and made it available as a shared component in my APEX applicaiton. When I print the the report region, most of the[More]

Printing PDF from Report Region - Header Details

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I've searched around for a while but was unable to find an answer to my query. I have a simple report region, which i added a "Print" link to the bottom of - this brings up a formatted PDF version of the report which can be printed out, i'm[More]

How to print standard report region to a PC printer via Win printer driver?

Category:DefaultRelease time:-0001-11-30Views:130

I know it's not very sexy, but sometimes an app user needs to print a standard report region to a printer that is connected to their PC. So that they can print their Apex report in the same manner as they do everything else from their PC, using a pre[More]

APEX 3.0 Print report region

Category:DefaultRelease time:-0001-11-30Views:130

When I want to print a report region, and choose A4 as "Paper Size", Adobe cannot open the PDF document. Adobe says that the document is not a supported file type or because the file has been damaged. When I choose Letter as "Paper Size&quo[More]

HP Photosmart 7510 - L:ooking at my Print Quality Diagnostic Reports - Why so many more "PHA Drops?"

Category:DefaultRelease time:-0001-11-30Views:130

My Photosmart 7510 C311a indicates it has printed about 7500 pages since I purchased it in about November 2011. Tonight, after replacing the Cyan ink cartridge, I ran the cartridge alignment and then printed out the Print Quality Diagnostic Report. [More]

Performance issue for Report Regions

Category:DefaultRelease time:2015-10-11Views:130

We have an app which has as it's "Home Page" a portal-style page. The "portlets" are separate regions. Some of these regions are HTML forms, but most are report regions, invariably with PL/SQL returning the SQL query. On our dev box th[More]

"print quality diagnostic report"

Category:DefaultRelease time:2015-10-11Views:130

I have a HP Deskjet 3520 All-in-one printer and I just went to the "HP Deskjet 3520 series toolbox". Under the first tab (Device Services) is the button "Print Quality Diagnostics Page". I then clicked on that button and got the "[More]

How to Print a interactive report without  action button and search bar

Category:DefaultRelease time:2015-10-11Views:130

Hello every one.... I am working on printing an interactive report. If there are 20 columns in that report i need to select some columns for printing. For this purpose i used actions button which is in the search bar of the interactive report. But i[More]

APEX_040100.WWV_FLOW_API Error while creating a Interactive Report Region

Category:DefaultRelease time:2015-10-11Views:130

I am getting the following error while creating an Interactive report region on a page. (version - 4.1.0.00.32) Error Unable to create Dynamic Query page. ORA-04065: not executed, altered or dropped ORA-04065: not executed, altered or dropped stored[More]

Printing a Web Report Using Firefox Results in Lost Session Variables

Category:DefaultRelease time:2015-10-11Views:130

Post Author: AVXFlyer CA Forum: .NET I'm  having a problem with Firefox users printing a Crystal Report from a web site.  The first page of the web site collects information to be used in the report generation, for example, start date, end date, type[More]

Print PLSQL Dynamic content region in PDF format in Oracle Apex

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have created a report region by selecting "PLSQL Dynamic Content".This region calls the procedure with some parameters.So i want this plsql dynamic content to be in PDF format. For an easy understanding, I have created an application i[More]

Hot
hi friends, using print layout design i am getting reports for a purchased item with all types of taxes included. i want to display the total cost of same purchased items but more than one and each purchased items having different taxes included with [More]
I currently have a BT Homehub connected to a modem, which is connected to the ethernet port in my wall (which is downstairs). I bought a timecapsule to wirelessly back up my computer. It is connected via ethernet cable to my router. I have recently b [More]
I recently got a new monitor - Dell U2713H - to use with my macbook pro. If I use anything other than the default color profiles the gamma will shift after about 7 seconds during video playback to something much cooler and dimmer. it stays that way u [More]
I sometimes want to turn off all sounds on my iPhone except for the phone ringer when I take a nap, so I can sleep undisturbed unless someone needs to reach me by phone. My question is: If I turn off all notifications in the settings, temporarily, wi [More]
Hi everyody, I am trying to create a BADI Implementation for the standard badi BADI_LAYER in SE19. When I try to save this, it gives an error saying "Specify filter names". Can somebody kindly tell me what this problem is and how I can fix it? T [More]
Hi, please which should be used between for all entries or join????All abap programers and most of the dba's that support abap programmers are familiar with the abap clause "for all entries". Most of the web pages I visited recently, discuss 3 m [More]
Hello. I just downloaded the aqualogic integrator and am using it's workshop. I tried finding tutorials through the help menu and found the following link on a page in the help contents: Help Page URL: [url http://127.0.0.1:7033/help/index.jsp?topic= [More]
I have got the following code used for sending a simple mail over a SMTP with Authentication connection.         boolean debug = true;         // Create a mail session         java.util.Properties props = new java.util.Properties();         props.put [More]
This has been happening for a while and it doesn't cause any problems, but I'm concerned by the fact that I don't know what it says. When I'm watching videos or movies on my MacBook there's a message box that pops up and then goes away. It goes away [More]
bonjour, est-il possible d'utiliser la time capsule pour le stockage d'icloud?Salut Edgardub, Branche la Time Caspule à ton Routeur (neufbox, freebox, livebox...) et configure la comme borne d'accès WiFi, du coup tu peux couper le WiFi de ton Routeur [More]