simonet

HI I have a variable in a subreport which is the total of Interests of debts. On Printing it's shown, but the returned value is null. Infact on Printing it 's not soctracted at the income, or better, the result is null because it is also null. But as said before, the subreport goes well and the value is shown.... I checked the increment type of the target variabile, set to report, and the reset type set to report. variables are both double. what happened ? regard

HI I have a variable in a subreport which is the total of Interests of debts. On Printing it's shown, but the returned value is null. Infact on Printing it 's not soctracted at the income, or better, the result is null because it is also null. But as said before, the subreport goes well and the value is shown.... I checked the increment type of the target variabile, set to report, and the reset type set to report. variables are both double. what happened ?

HELLO I want to use values of fields or variables of subdataset, but whne I put on of them inside the sheet, onto a band, I get problems saying that they could be found ? How can I use their value ? From the report field or variable their element arent even shown Thanks, regard ! F.S.

Hi I should save the output of the JRHtmlExporter in a database instead of the file system. In this second case it creates a folder where it inserts px and images. I would like to know how to get the stream of all the elements being saved in the folder and save them to the database separately. regards

If I shall write a class, what kind of class shall I write ? In other words how do u use this class loader.... regards

passing parameters from Java ? RIGHT ?

to make the JasperManagerFiller to find subreports of a report inside a database, where can I edit the REPORT_CLASS_LOADER parameter ? in the file jrxml ? what shall I write ? the url of the database ? regards

Hello I have thousands of file.jasper stored in a xml database called eXist. My software run on Linux, but those jasper are uploaded by a windows site.... I can download and get the report with its subreports, then I fill all the subreports with the java method JapserExporterManager.fillReport and I get all the JasperPrint. I add a Parameter to the report Jasper_Print_List with the List of JasperPrint of its subreports. Nevertheless I get an error saying that the Exporter cant find obviousely c:document and settingetc etc a subreport.jasper... How can I solve this problem ? Thanks

and if there are more columns than 1, how can I get them ? Post edited by: simonet, at: 2007/11/26 13:54

Hi I have a file.jasper which is being loaded by the java method: JRLoader.loadObject(its bytes).... to get its subreports I had to scan all the bands like: JRElement[] elem = null; elem = report.getDetail().getElements(); if(seekSubReports(elem)==-1) return false; //It DOESNT MATTER elem = report.getTitle().getElements(); if(seekSubReports(elem)==-1) return false; elem = report.getPageHeader().getElements(); if(seekSubReports(elem)==-1) return false; elem = report.getPageFooter().getElements(); etc etc GROUPS INCLUDED !! ISN'T THERE A WAY TO GET AN ARRAY OF BANDS AND SCAN IT with a for iteration INSTEAD TO DO AS SHOWN ABOVE !!! IT'S SO UGLY !!!! Thnak you very much

GREAT !!! Thank you very much Regards 74B10 simonet

Infact I cant find methods from JasperReport class which return a SourceExpression....

Well I have jasper Files stored in a database, I do not know which are the reports and subreports. I only know the name of a report. From another site I download the jasper file which is the main Report by my software using the HttpClient and the GetMethod. I make a JRLoader.loadObject(its bytes) and cast into a JasperReport. Can I go up the subreport name by using JasperReport methods ? Because I ask myself, how can IReport fill its report with its subReports..... with its library ?!?!? then jasperreport JAR has not library which allow to get SubReports name from a jasper... Thanks advancetly !!!

Hi I loaded a jasperFile and got an object JasperReport in Java. which methods shall I use to get the subReports names ? Thanks

I found a way: I use a JRLoader and cast it into a JasperReport. Now I have its instance and I can see its parameters. I m seeking how to get the subreports name !

The input Stream belong to jasper file, not to xml file. Excluding the new piece of code the software works, that is when a report is a single one. the new piece of code: if the report contains other subreports, before filling it I compile it with the CompilerManager and I get that exception.

I try to compile it but an Exception is caught: org.apache.xerces.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence. the method which I download the report with is getRequestBody that return an array of byte. I create the InputStream of the report by calling the new ByteArrayInputStream(arrayOfBytes)) so I have an InputStream of the Report. I pass it to the JasperManager.compileReport which return a JasperReport as you said, but I cant keep on going ahead because that Excepttion is caught......... Thank you

well let's suppose you have records of sales !!! so, for each record IReport shows a sale. for getting the total you should create a variable named for example TOTAL. when you create it choose EDIT and set opportunely the increment type and the reset type, I think the first one should be set to "report" the second one set to "nothing" or the contrary, I dont remember. the field function must be set to SUM and the expression must be set equal to the value of the field SALES...... this variabile must be inserted into the band SUMMARY instead of the DETAIL one. Create another variabile called IVA set to its percentage moltiplied by the TOTAL seen before and another one called TAXES. Then create another one called for example EARNING, insert its expression and put all these variables into the last band SUMMARY hope this help Post edited by: simonet, at: 2007/11/20 15:18

does it work ? ma sei Italiano ? funziona ?

It's not my english, because I write too fast. Well I tell it again: I have thousands of jasper files stored in a XML Database. Among those jasper there are both reports and subReports. I do not know which are the reports or the subreports. I was said to write a software that given a report name, it downloads it and exports it into a pdf or html file and store it again to the database. Well I only know the name of the report, so once downloaded it (with my software using an HttpClient and the getMethod) and got its inputStream, how can I get its subReport names so that I can download them, get thier inputStream and merge all togheter. Hope this is clear. Thanks again

Well I have eXist as Database, an xml database which allow to store also other kind of file format... anyway.... I do not know a priori which and how many jasper files are there inside that database, I only know the name of a report. So once known the report name, or better the report jasper name, I donwload it using HttpClient and getMethod and I get an InputStream of it and then pass it to the Filler returing a JasperPrint. now how can I go up to the subreport name ? arent the subreport names there into the jasper ?!?! As regarding the Html, during the converting, how can I get the Stream of the html file and the directory and its files so that I can store them into the database. Otherwise I should save them into files and then wait and send ....nooo I dont like this way. Thank you very much simonet

you have to put it at the summary band and set the variable increment and reset type opportunely ! sincerily

Hello Just a question: when I get the object JusperPrint in Java and export it into pdf file, how can I go up again the subreport name, ? because If I get the japser files locally, no problem, but as I have them on a remote server obviousely the FillManager cant find the subreport ones ! I mean what method of which class shall I use the get the subreport jasper name ? and if the output format is HTML, how can I get the inputStream of the folder and the other file so that I can store them to a remote server ? THANKS YOU Sincerely 7ab10 simonet Post edited by: simonet, at: 2007/11/20 10:56

thanks very much Post edited by: simonet, at: 2007/11/15 12:19

Thank you vey much for help, BUT I use Linux. It doesnt even work on Windows anyway, I already Tryied