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
When syncing to ipod, songs do not show up on ipod when syncing is complete. Am I doing something wrong? could the cord be bad? Can anybody help me?Connect your iPod and click on it's icon when it appears in the sources list. In the preferences Summa [More]
Just bought a macbook air when setting it up I used the wrong apple id for my primary icloud account.  I have tried to delet it but because the find my mac is on it does not allow me to delete the accout and restart. Any ideas?? ThanksIf your Apple I [More]
Full Error Message "(shared network name)is not accessible. you might not have permission to use this network resource. contact the administrator of this server to find out if you have access permissions. There are currently no logon servers availabl [More]
Please allow a bridge command line option to allow the user to select a specific bridge master cache. The  motivation is as follows:  I have written a c++ programme to key-word  all of my many thousands of photo projects.  Essentially each project is [More]
Nokia Pro Cam used to have a circle with 2 arrows at the bottom right of the screen to switch to Panorama or Smart  Cam.  And there was the camera button and video button on the right middle of the screen.  Now, there are 3 buttons on the right middl [More]
Hi Do anybody know how to print multiple transfer orders in a single go rather than printing TOs one by one using LT31. ThanksHi Terry, How about LX21? RegardsRead other 3 answers [More]
I'm on ECC6.0, and looking to set up a dynamic date range in a variant. The date range is a select-option on my selection screen. I can easily setup the dynamic date for the 'low' value in the range, but I can see no way to also declare a dynamic dat [More]
I created new Frame, and I want to open this frame from Main Frame menu item. Help meYou should add an action listener to the Menu Item. In the action listener's actionPerformed(ActionEvent) method, call your frame's setVisible(boolean) method. //fra [More]
Hi All, I am trying to start locators [email protected]:TEST:caching> ./startlocator.sh : command not foundline 13: : command not foundline 16: : command not foundline 19: : command not foundline 22: : command not foundline 25: : command not foundline 2 [More]
Hi, I purchased the Creative Cloud Membership Photography Plan but in my account it's showing as a free membership and both the LR 5 and Photoshop CC is showing as trial. Please advice what steps to take. Thank you, BreezyCreative Cloud chat support [More]