Databases
StackOverflow2013
Postsdbo
POTrying to build excel jxls template for my application to render and generate forms but ran into problems
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTrying to build excel jxls template for my application to render and generate forms but ran into problems
    primarykey
    data
    text
    <p>Hello everyone I have a jxls/sql related question and hopefully I can use some help from you. </p> <p>I am trying to write sql in an excel template, run it in jdeveloper to launch the my application and once the user click a button the app generates a excel form based on the template I created.</p> <p>I tried my code in oracle sql 10g and it works fine and gave me the resultes i wanted but once I put it into the excel template(I followed the required jxls documentation), the application wont be able to render the template and return a form to me. </p> <p>Maybe I have errors in the sql code that should not be written like this? </p> <p>I would qppreciate your help thank you in advance! </p> <p>HERE IS THE SQL CODE IN EXCEL:</p> <pre><code> &lt;jx:forEach items="${rm.exec("WITH rvus AS ( SELECT period_last_day, cpts.cpt, fy.fiscal_quarter(period_last_day) AS quarter, work_rvu, units, charge_amount FROM FIN.idxchg_credited_clp_current idx JOIN DOM.pc_cpts cpts on idx.cpt = cpts.cpt WHERE period_last_day &gt;= fy.fiscal_year_start('30-JUN-13') AND period_last_day &lt;= '30-JUN-13' ),totals as ( SELECT cpt, quarter, sum(work_rvu) as total_rvu, sum(units) as total_units, sum(charge_amount) as total_charge FROM rvus GROUP BY quarter,cpt ) SELECT cpt, SUM(DECODE(QUARTER, 1,total_rvu))Q1TotalRvu, SUM(DECODE(QUARTER, 1,total_units))Q1TotalUnits, SUM(DECODE(QUARTER, 1,total_charge))Q1Totalcharge, SUM(DECODE(QUARTER, 2,total_rvu))Q2TotalRvu, SUM(DECODE(QUARTER, 2,total_units))Q2TotalUnits, SUM(DECODE(QUARTER, 2,total_charge))Q2TotalCharge, SUM(DECODE(QUARTER, 3,total_rvu))Q3TotalRvu, SUM(DECODE(QUARTER, 3,total_units))Q3TotalUnits, SUM(DECODE(QUARTER, 3,total_charge))Q3TotalCharge, SUM(DECODE(QUARTER, 4,total_rvu))Q4TotalRvu, SUM(DECODE(QUARTER, 4,total_units))Q4TotalUnits, SUM(DECODE(QUARTER, 4,total_charge))Q4TotalCharge FROM totals group by cpt}" var="totals"&gt; &lt;/jx:forEach&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBray
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COOH and the error message in jdeveloper just says it cant parse my query above.
      singulars
      1. POTrying to build excel jxls template for my application to render and generate forms but ran into problems
      1. USBray
    2. COIt may have something to do with the fact the double-quotes are necessary to begin and end the attribute value. I don't know if JXLS allows you to escape the double-quote character so it can be included in an attribute value.
      singulars
      1. POTrying to build excel jxls template for my application to render and generate forms but ran into problems
      1. USrgettman
    3. CO@rgettman so I tried it wont work either.....would it be possible that the query parsed could not start with "with rvus as" but has to start with a select statement? Thanks.
      singulars
      1. POTrying to build excel jxls template for my application to render and generate forms but ran into problems
      1. USBray
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload