prashanth.talkad

hi, i know the exception above sounds non-conclusive, but here it goes - my application talks to jasperserver when running reports and all was fine tilla week back and all reports were coming up fine(pdf reports). this week, for no apparent reason(not sure what got changed), i cannot run the reports and it throws ------ Caused by: java.lang.Exception: 1 - Access is denied at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at i'm still able to login to jasperserver and run those reports but when i run the reports from my application(which hasnt been touched), run into the above error. i checked on all the certs involved. any help is appreciated - r there any other places i need to be looking at? thanks ptalkad

hi, i know the exception above sounds non-conclusive, but here it goes - my application talks to jasperserver when running reports and all was fine tilla week back and all reports were coming up fine(pdf reports). this week, for no apparent reason(not sure what got changed), i cannot run the reports and it throws ------ Caused by: java.lang.Exception: 1 - Access is denied at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at i'm still able to access jasperserver(via the application) and run those reports(manually) but when i run the reports from my application(which hasnt been touched), i run into the above error. i checked on all the certificates involved. any help is appreciated - r there any other places i need to be looking at? i've looked at the bug sheet where there is an "access denied" issue with scheduled reports. this report i'm tryin to run is not a scheduled report. thanks ptalkad Post edited by: prashanth.talkad, at: 2008/06/09 23:45 Post edited by: prashanth.talkad, at: 2008/06/10 04:54 Post edited by: prashanth.talkad, at: 2008/06/10 04:57

hi pedja, thanks a bunch, i realised and implemented the fix last nite but forgot to post it on the forum, thanks a lot anyway.... time zones suck !!! cheers!!! Post edited by: prashanth.talkad, at: 2008/04/21 21:09

i figured out the BOLD part of my query above. i had not used PDF encoding. once I did that, it worked. BUT, the other problem where i'm unable to truncate the white space in a line is baffling me :(( :sick: LUCIAN, any ideas please !!! Post edited by: prashanth.talkad, at: 2008/04/21 04:11

Hi, I have two little problems here::: 1) I'm trying to <b>BOLD</b> am couple of words in a static text box as below:::: <staticText> <reportElement x="214" y="38" width="354" height="95" key="staticText-4"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" sStyledText="true"> <font/> </textElement> <text><![CDATA[TEXTTEXTTEXTTEXTTEXT <b>Tel +64 4 xxxxxxxxxx Email inquiries@xxxx.xxx.xx www.xxxxxxx.xx</b>]]></text> </staticText> When I upload this report JRXML into Jasperserver, it seems to be showing the text in BOLD as it should be, but when I view the same report by exporting it to PDF format, its NOT BOLDED :blink: 2) I'm trying to print a salutation for a coverletter as below: Dear Salutation FirstName LastName Suffix, The problem here is that Salutation, Suffix and First Names are usually null. I've used the below JRXML to format the text when they are null. <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Opaque" x="73" y="181" width="14" height="18" key="textField-11"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[(($F{NAME_SALUTATION_DESCRIPTION}!=(null))?$F{NAME_SALUTATION_DESCRIPTION}:"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="87" y="181" width="49" height="18" key="textField-15" isRemoveLineWhenBlank="true"> <printWhenExpression><![CDATA[new Boolean($F{V_PERSON_FIRST_NAME}!=null)]]></printWhenExpression> </reportElement> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{V_PERSON_FIRST_NAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="136" y="181" width="118" height="18" key="textField-16" stretchType="RelativeToTallestObject"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[(($F{V_PERSON_LAST_NAME}!=null)?$F{V_PERSON_LAST_NAME}:"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="254" y="181" width="22" height="18" key="textField-17" isRemoveLineWhenBlank="true"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[(($F{NAME_SUFFIX_DESCRIPTION}!=null)?$F{NAME_SUFFIX_DESCRIPTION}:"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="101" y="307" width="24" height="19" key="textField-18"/> Tried both the "Blank when Null" option and the "Print when Expression" terms to print a blank if value is null, but just CANNOT seem to get wide GAP that it introduces in the report. I just cant seem to format it and make it look like Dear LastName if all the rest are null. It looks like this now: Dear ...........long white space...... LastName :blush: please help !!!! :silly: thanks,

lucian, any idea if i'm missing something here....i'm so close to achieving the interleaving of landscape and portrait pages in my report and this had to happen :sick:

hi, my jdk version is 1.5.0_12 and jre 1.5.0_12(i also have the jre1.6.0_03). i'm developing using netbeans 6.0 with the visual web pack extension. not sure why its not able to recognise the digester - i downloaded the digester jar as well and put it in my lib folder - commons-digester-1.8.jar Post edited by: prashanth.talkad, at: 2008/03/25 04:12

when I try to parse the xml via the JRPrintXmlLoader, the prepareDigester() method in the class seems to throw a VerifyError - Caused by: java.lang.VerifyError: (class: net/sf/jasperreports/engine/xml/JRPrintXmlLoader, method: prepareDigester signature: ()Lnet/sf/jasperreports/engine/xml/JRXmlDigester;) Incompatible argument to function The line that throws the error is:::: JasperPrint pageReport = JRPrintXmlLoader.load(new ByteArrayInputStream(reportTemplateXml)); Is there something I'm missing here? thanks

lucian i used the getPages() method in JasperPrint and tried to loop through the list of pages alternatively between the portrait and landscapes but i encounter an exception when I call "exportMergedReport.exportReport();" - ClassCastException - JRBasePrintPage.... ne comments? my code is below: JasperPrint reportCoverLetterInPortraitMode = jasperServerReportDao.generateReport(JASPER_REPORT__PORTRAIT_URI, parameters); JasperPrint reportCertificateInLandscapeMode = jasperServerReportDao.generateReport(JASPER_REPORT_LANDSCAPE_URI, parameters); JRPdfExporter exportMergedReport = new JRPdfExporter(); List coverLetters = reportCoverLetterInPortraitMode.getPages(); List certificates = reportCertificateInLandscapeMode.getPages(); List list = new ArrayList(); for(int i=0; i<coverLetters.size(); i++){ list.add(coverLetters.get(i)); list.add(certificates.get(i)); } exportMergedReport.setParameter(JRPdfExporterParameter.JASPER_PRINT_LIST, list); exportMergedReport.setParameter(JRPdfExporterParameter.OUTPUT_FILE, pdfFile); exportMergedReport.exportReport(); thanks,,,,,,:)

also, has anyone tried to interleave portrait and landscape pages - for example, if i have a report with 2 pages, one to be printed in portrait mode and the other in landscape mode - and the query returns N rows - for my design, its printing N portrait pages forllowed by N landscaped pages. I wanna print interleaving portrait/landscaped pages thats easy when an end user prints the report. One way lucian suggested is to write my own exporter - which i dont have time for at this moment. any other suggestions lucian? thanks in advance.

lucian, when you say "you will need to manually split the reports into JasperPrint objects that contain a single page" I dint quite understand what you imply. does it mean that I have to merge some portions of reportPortrait and reportLAndscape from the code posted earlier? :sick:

here's my code for the report generation - please lemme know if there is any parameter i'm missing here that might print portrait and landscaped reports alternatively rather than all portraits first and then all landscapes :(( File pdfFile = File.createTempFile("ABC", ".pdf"); Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put(JASPER_REPORT_PARAMETER_NAME1, JASPER_REPORT_ID); parameters.put(JASPER_REPORT_PARAMETER_NAME2, getID()); JasperPrint reportPortrait = jasperServerReportDao.generateReport(JASPER_REPORT_PORTRAIT_URI, parameters); JasperPrint reportLandscape = jasperServerReportDao.generateReport(JASPER_REPORT_LANDSCAPE_URI, parameters); JRPdfExporter exportMergedReport = new JRPdfExporter(); List list = new ArrayList(); list.add( reportPortrait ); list.add( reportLandscape ); exportMergedReport.setParameter(JRPdfExporterParameter.JASPER_PRINT_LIST, list); exportMergedReport.setParameter(JRPdfExporterParameter.OUTPUT_FILE, pdfFile); exportMergedReport.exportReport(); thanks!

thanks for clarifying Lucian ! I've re-designed my reports to include batch exporting via 2 JasperPrint objects and feeding them to the JRPdfExporter list. I've uploaded the portrait and landscape.jrxml's into JasperServer. Scenario:: The query returns more than one row. Lets say "n" rows. When I run the report via the java application, it always prints the "n" portrait pages and then prints the landscape format. What I'd like to see is that it prints the portrait and landscape reports printed alternatively - it augurs well for the end user as well! any help lucian? :) thanks

hi, i'm trying to get a two page report, one in landscape and one in portrait mode. can i achieve this with a cingle jrxml? like for example if the two pages are, lets say details of a person on one page(portrait) and a certificate for the person for passing his certification in the other page(landscape). i've currently designed the report in a single jrxml with a single query to populate the fields in both the pages since both pages have similar fields like name, date and the like. any help is appreciated. thanks, p

hi, i'm trying to get a two page report, one in landscape and one in portrait mode. can i achieve this with a cingle jrxml? like for example if the two pages are, lets say details of a person on one page(portrait) and a certificate for the person for passing his certification in the other page(landscape). i've currently designed the report in a single jrxml with a single query to populate the fields in both the pages since both pages have similar fields like name, date and the like. any help is appreciated. thanks, p Post edited by: prashanth.talkad, at: 2008/03/11 04:05 Post edited by: prashanth.talkad, at: 2008/03/12 02:43

hi gilmarnunes, did you find out how you can acheive this. this is the exact same thing i'm looking for. i've designed a 2 page iReport and i want one of the pages to be in portrait mode and the other in landscape mode :S thanks, prashanth

hi, i've designed an iReport with two pages to be displayed for every row returned by the SQL query. While I want one of the pages to be in portrait and the other in landscape when I print, I'm unable to acheive this - considering that the report design exists on a single page(a single jrxml where i can either allot "portrait" or "landscape" to the page. Is there any other way to acheive a two-page report. For now, I've split the report into two bands and i display the first page contents in band1 and page two in band2. PLEASE ADVICE. thanks, prashanth

hi, i've designed an iReport with two pages to be displayed for every row returned by the SQL query. While I want one of the pages to be in portrait and the other in landscape when I print, I'm unable to acheive this - considering that the report design exists on a single page(a single jrxml where i can either allot "portrait" or "landscape" to the page. Is there any other way to acheive a two-page report. For now, I've split the report into two bands and i display the first page contents in band1 and page two in band2. PLEASE ADVICE. thanks, prashanth

hi, figured out that the band in which my cover letter was aligned was not printing out. so i changed the band and it worked pronto!!! :D neways, i got another Q now - is it possibile to PRINT the first page(the cover letteR) in PORTRAIT and the second page(certificate) in LANDSCAPE mode? considering the design in iReport corresponds to a single page

hi, I have a report which i've split into 2 pages - a cover letter and a certificate if you may - each containing values got from the sql query. the problem is that the sql query returns, say N rows - the report is printing out values($F{variable_name}) from ONLY the FIRST and LAST row in the first page and the second(also the last) page of the report. What I need is that it prints 2 pages per ROW returned by the query. If its a single page report though, it print the contents in N number of pages(example: if I had just the certificate to print out, it will print N certificates with values from N rows returned by the query) Any help is appreciated. I know i'm missing something elementary here but not able to figure out what ?!?!?!? thanks