Jump to content
Changes to the Jaspersoft community edition download ×

ian.waterman

Members
  • Posts

    14
  • Joined

  • Last visited

ian.waterman's Achievements

Apprentice

Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges

0

Reputation

  1. Bruno That did the trick. Thank you for your help. Ian
  2. 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
  3. 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
  4. Tried all those Solved problem by opening source file and editing parameter name there. All working OK now. Thanks for your time Ian
  5. 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
  6. The answer which was emailed is different to response below. Don't think solution below will work as I only want to print Agreement Header on new page if invoice details overflow to page 2.
  7. Sorry error in above In Header REcNo = 0 When header is printed on page 2 both are still showing as 2, and this ignore the Print when expression $V{RecNo}.doubleValue()!=$V{PHControl}.doubleValue()
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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...