[any configuration options for query designer ?]

the query designer is looking pretty good.... but I have some problems with it

 there seems to be a 16 char limit on some of the strings...  for instance... this code is generated by the query builder

SELECT
     COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_CO,
     COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_CO
FROM
     "my-db"."COMPANYMASTER" COMPANYMASTER

 

so that code doesnt work because of the identical aliases...  i guess it should look like this

SELECT
     COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_COMPANYCODE,
     COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_COMPANY_NAME
FROM
     "my-db"."COMPANYMASTER" COMPANYMASTER

 

and ideally ( the root of my question actually )  i would like to be able to configure the querybuilder so that it does not prefix everything with the schemaname.tablename except in those cases where it is needed to prevent ambiguity... actually i would like the above query to just come out like this:

SELECT
     COMPANYCODE,
     COMPANY_NAME
FROM
    COMPANYMASTER

maybe there are already some configuration options for this?

 

thanks

Steve Nell

[highlighting every nth line ( with a twist )]

 

We've found it easy to highlight every 3rd row in most cases, but in some reports we have group headers / footers that appear conditionally.    Normally we would not want to include group headers / footers in the highlight count, but these special reports were designed to replicate the formatting on some legacy reports.   The end result is that the group header and footer have a similar appearance to the detail row and therefore I have been asked to include those in the highlight count.

I have tried using various types of variable counts / sums that when added to Page_COUNT would give me a running sequential number that I could use for conditional highlighting, but have been unsuccessful in that approach.

Is there maybe an easier method that I am overlooking?

 

thanks

Steve

[possible to flatten a recordset?]

we have a report that looks like this:  ( columns delimited by pipe character )

schedstep | description | predecessor
15 | foo1 | 14
16 | foo2 | 13   
16 | foo2 | 14
16 | foo2 | 15
17 | foo3 | 16

but we want it to look like this

schedstep | description | predecessor
15 | foo1 | 14
16 | foo2 | 13,14,15
17 | foo3 | 16

regards,
Steve Nell

[eclipse plugin... is there such a thing?]

I see various mumblings about an eclipse plugin, but most of these are from a few years ago and/or reference a version of iReport prior to 3.0.

Just curious if a current ( iReport 3.5.x and above ) version of an eclipse plugin exists...

thanks

Steve

[groovy _does_ work in 3.5.2]

problem:

I took the 'list' sample in 3.5.2 and ran 'ant test' and everything worked...
then I modified the report to use groovy as the scripting language -- whan I ran the 'ant test' script on the modified sample I got the error below... 

     [java] java.lang.NoClassDefFoundError: org/codehaus/groovy/runtime/callsite/CallSiteArray

 

resolution:

I found the problem... turns out that I had this file in my ant  directory.

C:apache-ant-1.7.1libgroovy-all-1.6.0.jar

 

Post Edited by stevenell at 08/13/2009 23:33

[class not found ... but only if i compile with ant]

I am using iReport 3.5.2, JasperReports 3.5.2

when I compile my reports with Ant, I get the following when I try to run the reports
(java.lang.RuntimeException: Class not found: org/codehaus/groovy/runtime/callsite/CallSiteArray)                                                  

but if I compile the reports with iReport I dont have this problem.

the relevant parts of my buildfile are below. 

thanks
Steve

    <path id="compile-classpath">
      <fileset dir="d:/iReport-nb-3.5.2/ireport/modules/ext">
        <include name="**/*.jar"/>
      </fileset>
      <pathelement location="c:/p4ws/ihms/main/lib/ihms-ireport-helpers.jar"/>
    </path>

    <taskdef name="jrc" classname="net.sf.jasperreports.ant.JRAntCompileTask" >
      <classpath refid="compile-classpath" />
    </taskdef>

....
....
....

 

      <jrc
          srcdir="c:/p4ws/ihms/main/reports/src"
          destdir="${g.target.env.home}/lib/ihms-common/com/ame/ihms/reports"
          tempdir="${g.target.env.home}/lib/ihms-common/com/ame/ihms/reports"
          keepjava="false"
          xmlvalidation="true">
        <classpath refid="compile-classpath"/>
        <include name="**/*.jrxml"/>
      </jrc>

[repeat group header... but add "continued"]

thanks -- that does work

Steve

[repeat group header... but add "continued"]

 

Repeating the group header when it splits onto a new page works nicely, but i would like to add the something like "continued" when it repeats.

i.e.

ASSETS

------ page break ---

ASSETS ( continued... )

 

I've searched but didnt find anything obvious -- is this possible?

 

thanks

Steve

 

 

[style handling issues]

using iReport 3.5.1

1 ) when I add a style reference to the 'styles' node in the 'Report Inspector' pane, I would then expect to see any styles contained in the referenced .jrtx to appear in the drop down for 'style' in the properties pane when applying a style to a control... but they dont show in the dropdown and I have to type it in...

2 )  it is kind of a pain to set style references on every element by digging through the properties...  after adding my style template reference as mentioned above, it would be nice to see the contained styles show up as child nodes of that template node in the report inspector pane... ( would also be nice if they would appear in hierarchical layout honoring the 'parent style' property )  and then be able to drag a 'style' node onto an element to apply the style....   ( these enhancements may be more appropriate in the 'style library window', but it would be nice to be able to do from both areas because it seems the 'styles library window' is more of a 'per iReport installation', so being able to apply from the report pane would be easier to keep configured in situations with multiple developers )

3)  when I do set a style as described in #1, the control that received the applied style does not adjust to reflect the new style ( font size for instance... )  so this is a little cumbersome because I have to set the font size manually so it will be readable in the designer and then also set the style

 

I am new to styles, so I could be off base on all of these -- but if they are accurate let me know and I will post feature / bug requests as appropriate.

thanks

Steve

 

 

[relative path / common resource problems]

in case anyone else runs into this... 

I created a batch file to start iReport -- the batch file sets a few environment variables

@setlocal
c:
cd c:\p4ws\ihms\main\reports
SET REPORT_BASE_DIR=%cd%\src
ECHO %REPORT_BASE_DIR%
D:\iReport-nb-3.5.1\bin\ireport.exe
@endlocal

 

then i use a java helper class ( JU.java ) to retrieve the REPORT_BASE_DIR value and I use that function to set my default values for parameters used to locate resources

    <parameter name="CFG_REPORT_BASE_DIR" class="java.lang.String" isForPrompting="false">
        <defaultValueExpression><![CDATA[JU.getBaseDir()]]></defaultValueExpression>
    </parameter>

 

the advantage to doing it this way is that i can still preview everything at design time because of the default param values, but at runtime I can pass explicit values to these parameters

( btw -- I could not use classpath as a resource location solution due to some deployment restrictions  )

 

[How to get *.jrprint file using IReport?]

.jrprint is one of the output formats i think...  so if you preview the report first, then click on the 'save' button ( small disk icon ) i think jrprint is one of the formats you can save in

Steve

[Building iReport-nb 3.1.4]

also having this issue -- anybody figure this out?

thanks

 

[error when accessing resources via classpath]

Using iReport 3.5 I created a simple report example

 

C:\TEST
+---myreport
|       TestReport.jasper
|       TestReport.jrxml
|
\---myresources
        logo.png
        style.jrtx

 

I set the classpath in iReport to include the folder c:\myresources

I added an image to the Title band and set the 'image expression' to "logo.png"

In the designer view the image loads ( i can see a design preview of what the image looks like ).

But when I try to preview the report I get the error below.   This happens in 3.1.2 and 3.5.0 .....  am I doing something wrong?

thanks

Steve

  Compiling to file... C:\test\myreport\TestReport.jasper
Compilation running time: 578!
Setting net.sf.jasperreports.engine.query.JRJdbcQueryExecuterFactory as Query Executer Factory for language: sql
  Filling report...
  Locale: English (United States)
  Time zone: Default
Error filling print... Error loading byte data : logo.png
net.sf.jasperreports.engine.JRException: Error loading byte data : logo.png      at net.sf.jasperreports.engine.util.JRLoader.loadBytes(JRLoader.java:299)      at net.sf.jasperreports.engine.util.JRLoader.loadBytesFromLocation(JRLoader.java:477)      at net.sf.jasperreports.engine.JRImageRenderer.getInstance(JRImageRenderer.java:180)      at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:951)      at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:898)      at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275)      at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:311)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:247)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:899)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:821)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:628)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:544)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:921)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)  Caused by: java.io.FileNotFoundException: logo.png (The system cannot find the file specified)      at java.io.FileInputStream.open(Native Method)      at java.io.FileInputStream.<init>(FileInputStream.java:106)      at net.sf.jasperreports.engine.util.JRLoader.loadBytes(JRLoader.java:285)      ... 17 more 
Print not filled. Try to use an EmptyDataSource...

 

 

Post Edited by stevenell at 04/22/2009 15:03

[relative path / common resource problems]

we store / organize our reports relying heavily on directory structure.. for example one of our reports is located here
<report-lib-home>/gl/trialbalance/main.jrxml
<report-lib-home>/gl/trialbalance/subreport1.jrxml

at runtime I can pass parameters that tell the report where _thisreport_  and where _commonresources_ are located ( i.e. we have a common header subreport, logos, etc.. )
for example, our common resources are here
<report-lib-home>/_resources/header-subreport.jrxml
<report-lib-home>/_resources/default-style.jrxt
<report-lib-home>/_resources/company-logo.png

 

the problem is that during design time I cant specify these location values via relative path....  ( well, sometimes I can, but in some circumstances it doesnt work -- one example is telling the common subreport to use the the common .jrxt file as a style reference. it works as when i preview the subreport itself, but when i preview the master report it fails )

 

so that leads me to my question  -- is there a way to do this that I am overlooking?  can iReport pass parameters to a report at design time?  ( I know that I can create a parameter and give it a default value in the report itself -- that is what I was trying above ... but what I am looking for is a way to mirror what happens at runtime -- passing a few parameters to the report so developers can set these 'location' values in iReport and not rely on default value of parameter specified in the report )

one way i would like to deal with this is to place a properties file at the root of my reporting library and make those properties available as parameters that iReport passes to the report

thanks

Steve

[Custom Wizard template]

this may not be the correct solution, but I did something similar to you except that I kept the names of my modified wizard templates as  classicC.jrxml and classicT.jrxml... then added them via tools / options... then did a new report via wizard and my changes were there

Steve

[creating consistent look across multiple reports]

Giulio,

thanks for the advice..  I am looking at the report wizard -- I see that it utilizes two .jrxml files (classicT, classicC).  

In order to utilize the wizard it looks like I would modify one or both of those files and have our developers start new reports by using the wizard.   Seems straightforward...   do i modify these files w/in the com-jaspersoft-ireport.jar file itself, or is there some other way to hook my own jrxml's into the wizard?

thanks

Steve

[creating consistent look across multiple reports]

I am looking for advice..

We have around 100 reports that have to be converted to JasperReports...  several members of our development team will using iReport on this effort.  We want to take this opportunity to apply a consistent look to all of the reports.

Other than creating a style manual...  any recommendations on ways to control / facilitate a common look?

thanks

Steve

 

[default font]

Is it possible to set a default font family / font size for a report?

 

thanks

Steve

 

[does javascript prevent use of java helper classes]

that does work nicely

 

thanks,

Steve

[when to use BigDecimal]

Our reports are mostly financial -- generl ledger reports, jobcost reports, purchaseorders, workorders, etc..

Initially we started out using BigDecimal for everything... but have encountered some 'unweildliness' along the way..  now we are considering using Double...

I understand the internal representation and rounding issues... just curious if anyone has opinions on this or if I am overlooking some pitfalls that come with Double.

 

thanks

Steve

[global javascript functions, or imports]

is there a way to reference other javascript files -- so that I could have a library of formatting functions for instance?

thanks

Steve

 

[global javascript functions, or imports]

is there a way to reference other javascript files -- so that I could have a library of formatting functions for instance?

thanks

Steve

 

[does javascript prevent use of java helper classes]

I have been formatting some text using a java helper class.  Now that we have javascript capability ( very nice )  I am converting some of my reports... but it appears that if I use javascript for a report, I cannot access my java helper class... is this true?

 

[javascript vs java for expressions]

When I use java for my expressions, it appears they must be true expressions.  But when I use javascript for the expressions, I can get away with some iteration...

for example.. this appears to work in javascript:

var f="foo";
var b="bar";
var g=f.concat(b);
g=g.substring(1);
g;
 

is this type of iterative evaluation only available when using javascript for expressions?

thanks

Steve

 

 

[how to make a rectangle or frame grow with subrpt?]

try using frames instead of rectangles.

I ran into something similar in the detail band...  I wound up putting each subreport inside of a frame, and then wrapping all 3 of those frames inside of another frame.  My border was on the outside frame.    I had no trouble making the outer frame grow...

Steve