Jump to content
We've recently updated our Privacy Statement, available here ×

ian.waterman

Members
  • Posts

    14
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by ian.waterman

  1. We have built report using Ireports in Jasperstudio 6.1

    In many report we use Arial and have headers in Bold text. All is fine in viewer and through our application.

    However, when we export to PDF all Bold text reverts to normal.

    I have tried to follow 

    https://community.jaspersoft.com/wiki/custom-font-font-extension

    But if I try to Browse to Fonts on C:WindowsFonts I can not select Arial, consequently I am unable to embed in PDF.

    What am I doing wrong or is there another approach I should be following to ensure Bold text remains bold when exported to PDF

    THank yuou

    Ian

  2. Working only with the Studio I have added a Style using instructions I found on a previous post

    1) Right click on styles >> Add >> Style
    2) give it a forecolor
    3) right click on style >> Add Conditional Style >> give a condition like below;

       $P{GroupField}="text"

    For the field you want to apply the style, click on the field and in the property select the style.

    In my case Colour is Red, existing field colour is black. Condtion  = $F{CRDR}.equals("Credit")

    Condition works as I am using it in another expression to change Text shown

    When I look in Source it has created style which I assume is OK

    </style>
        <style name="Style1" forecolor="#FC052A" markup="none" fontName="DejaVu Sans" fontSize="11">
            <conditionalStyle>
                <conditionExpression><![CDATA[$F{CRDR}.equals("Credit")]]></conditionExpression>
                <style/>
            </conditionalStyle>
        </style>

    When I apply the Style to my text field it appears to disappear from the Designer screen, and when I run report it is blank. If I remove style from text field text returns and when report runs the correct Black text is there.

    Any suggestions as to what I am doing wrong or is there a step I have missed

    Thank you

    Ian

  3. I have created 3 Crosstabs at 3 different Group levels and all work fine up to a point.
    We use a Parameter in Main report to control Language and number formats, this work fine in main report.

    Paramter in main report = LanguageCode which for UK is "en_GB".
    I have set $P{REPORT_PARAMETERS_MAP} in Paramter Map Expression in CT properties.
    When I try to create a Parameter in CT defualt name is Parameter1, however, properties dialog box will not accept new name of LanguageCode. 
    If I try to override in Advanced Tab I get error Java.lang.NullPointerException.
    I can not delete Parameter1 either

    If I use the Code Value in my Format expression all works fine. I can not even add Paramter1 to expression as it does not appear in the object list in the expression edit window. 
    If I manually type $P{Paramter1} the expression errors.

    If I try to create another Paramter the Parameters list in Outline window does not change, ie Parameter2 does not show in window, but if I now go back to Expression editor a parmeter with name Paramter1 is available, 
    If I add Parameter with default value set as en_GB expression returns Null.

    Is there a setting I have missed?

    Thank you
    Ian

  4. Kevin

    Thank you for guidance,

    Still not working as expected

    I have changed Vars as suggested

    </variable>

    <variable name="RecNo" class="java.lang.Integer" resetType="Group" resetGroup="AgreementNumber" incrementType="Page">

    <variableExpression><![CDATA[$V{RecNo}+1]]></variableExpression>

    <initialValueExpression><![CDATA[new java.lang.Integer(0)]]></initialValueExpression>

    </variable>

    <variable name="PHControl" class="java.lang.Integer" resetType="Group" resetGroup="AgreementNumber">

    <variableExpression><![CDATA[$V{RecNo}]]></variableExpression>

    <initialValueExpression><![CDATA[new java.lang.Integer(0)]]></initialValueExpression>

    </variable>

    Print when on Header is set as

    </group>

    <group name="AgreementNumber" isReprintHeaderOnEachPage="true" keepTogether="true">

    <groupExpression><![CDATA[$F{AgreementNumber}]]></groupExpression>

    <groupHeader>

    <band height="149">

    <printWhenExpression><![CDATA[$V{RecNo}.doubleValue()!=$V{PHControl}.doubleValue()]]></printWhenExpression>

    <textField isStretchWithOverflow="true" evaluationTime="Group" evaluationGroup="AgreementNumber" pattern="" isBlankWhenNull="false">

    I have placed VARs on report on Page in both Group Header and Footer. In Header PHControl = 2 and Recno = 1

    In Footer They are both 2 on pg1 however, group header still prints on Page 2

    Cant see how Values are being set?

    Any suggestions?

    Ian

  5. Building a report which lists out invoices within an agreement. The headers for the invoice details are in the Agreement Header.

    Generally works fine however, if list of invoices goes over to next page I want the Agreement header to repeat. I have tried checking the Reprint Header on new page , but that causes header to reprint irrespective whether invoice list flows onto next page.

    I created a Count of Agreements which Increments and resets on the Agreement Group and a record count. According to this entry https://community.jaspersoft.com/wiki/variables the agrement count should only evaluate on change of Agreement. However, it seems to count every record.

    I had hoped that I could use a print when expression that only allows the Agreement Header to print when the two counts are equal and <> 1, (in most cases invoice list is more than 1 but had this just incase)

    However, as the two counts are always equal the header always prints. 

    What am I doing wrong with the Count Variables 

    Is there a better way to conditionally control the subsequent printing of the agreement header

    Source Description of Vars

    </variable>
        <variable name="PHControl" class="java.lang.Integer" resetType="Group" resetGroup="AgreementNumber" incrementType="Group" incrementGroup="AgreementNumber">
            <variableExpression><![CDATA[$V{PHControl}+1]]></variableExpression>
            <initialValueExpression><![CDATA[new java.lang.Integer(0)]]></initialValueExpression>
        </variable>
        <variable name="RecNo" class="java.lang.Integer" resetType="Group" resetGroup="AgreementNumber">
            <variableExpression><![CDATA[$V{RecNo}+1]]></variableExpression>
            <initialValueExpression><![CDATA[new java.lang.Integer(0)]]></initialValueExpression>
        </variable>

    Thank you

    Ian

  6. We have a report which works fine when restricted to a single page. Embedded within the report is a subreport which only holds a table of debtor items. When the list is more than about 12 items it breaks onto the next page. However, on page 1 it looks unprofessional as the table is not closed off, ie the last row does not have a bottom line.

    How can we force the inclusion of a line on a page break. When table is complete on Page 2 the closing table line is present.

    Thank you

    Ian

  7. Found an answer to this

    new Boolean ($F{DataType}.equalsIgnoreCase("1 Detail"))

    However, I now need to have a list of conditions

    1 Detail

    2 Bank Charges

    I have tried

    new Boolean ($F{DataType}.equalsIgnoreCase("1 Detail"))

    or

    new Boolean ($F{DataType}.equalsIgnoreCase("2 Bank Charges"))

    But I got a compile error

    Syntax error on token "or" invalid AssignmentOperator

    What is the correct syntax, or is there an IN operator

    eg

    new Boolean ($F{DataType}.in("1 Detail", "2 Bank Charges"))

    Ian

     

  8. Using i-Reports 3.7.4

    Hope you can give me some pointers

    I am trying to suppress detail band  when the datatype = Summary (ie print when datatype = Detail

    I looked at existing report where we have two details bands, the second contains a notes field, this detail band is suppressed if notes field is null in Print When of the band properties

    new Boolean ($F{StatusRecComments} != null )

    I have tried

    new Boolean ($F{DataType} != "Summary") – this suppresses nothing

    new Boolean ($F{DataType} == "Detail") – this suppresses everything

    Any suggestions

    Thanks

    Ian

  9. Thats not really the issue it the keep together making big groups on page 1 print on Page 2, leaving 1 blank.

     

    PrintWhen is availbale but not sure how I can use that to achieve same result as keep togther. There is no expression avaialble with the keep together.

     

    Ian

  10. I am an I-Reports newbie (mainly work with Crystal).

    In order to avoid orphan headers later in report we are using Keep together for a group.

    However, on page one our first group is too big for page and report always starts with a blank page. How do we overide the keep together for the first page or first record.

    We are a bit behind times and still on i-Reports 3.7.4. Its  embedded in an application and do not have the option to upgrade. Database is SQL server 2008.

    Thank you

    Ian

×
×
  • Create New...