joannem

Hello, Can anyone assist me with why I would be getting this error? I am using an xml file which does have data in it, however when I run the report I get th error "The document has no pages". Thanks in advance, Joanne Post Edited by joannem at 07/21/2009 20:28

Hello, I have dumped the database on the one system which contains jasperserver and would like to load it into jasperserver on a different system. I found the dump command no problems but am unsure how to use this dump file to load into msql on the other system. Any commands I see they are asking for the database name but I'd like to load the complete dump file. Any assistance would be greatly appreciate! Thanks in advance! Joanne

I've attempted and I continue to get casting errors. I've created the variable "$V{NUM_FORMAT}" and put in the initial value "new java.text.DecimalFormat("0.##")". I've tried setting the "Variable Class Type" to Double, String, java.text.DecimalFormat ..... My variable that I want to use this format in contains "( ($F{venprice} != null ) ? $F{venprice_label} + ": " + $V{NUM_FORMAT}.format($F{venprice}.doubleValue()):$F{venprice_label} + ": " + 0.00)" I continue to get errors like the following 1. When I have the Variable Class Type on NUM_FORMAT is set to java.text.DecimalFormat ...... "The method doubleValue() is undefined for the type DecimalFormat" OR 2. When I set the Variable Class Type on NUM_FORMAT to java.lang.Double ..... "Cannot cast from DecimalFormat to Double" as well as the one above "The method doubleValue() is undefined for the type DecimalFormat". So I'm assuming that I need to have the variable NUM_FORMAT set to java.text.DecimalFormat but then how do I correct the error regarding the method doubleValue() ? Thanks for your help!

Haven't had a chance to try the last post but going to attempt today!

I have tried using the NUM_FORMAT option but I get an error. What is the variable class type supposed to be set to for this variable? I left it as string not really thinking about it but then got an error "Cannot cast from Decimal Format to String". I've tried setting it as Double but then get the error only references Double instead of String. Sorry but java is not my strong point so any assistance would be greatly appreciated. Thanks!

Hello, I have a field in my template which contains a text field as well as a decimal field. Example: $F{venprice_label} + ": " + $F{venprice} - venprice_labe needs to be a string variable but venprice needs to be a 2 place decimal field. Can anyone tell me how to set this in the expression for my field. Thanks!

Hello, Is there any type of orphan control or keep together command that wil allow you to keep 2 bands together if hit the end of the page? For example I do not want to see a group header as the last thing on a page and the detail for that group header to be on the next page. There are 2 bands in this instance.. the group header and the detail. How do I keep this from happening? Thanks in advance!

Hello, I am having some difficulty in getting my report query set up so that I can access the data the way I want to. I am using an xml file and selecting Xpath for my Query Language. My xml file is in the following format <smartxml> <lang> <labels> </labels> </lang> <repdata> <invcd>1234</invcd> <whs>abc</whs> <uom>each</uom> <serlot> <lotcd>t12</lotcd> <onhand>20</onhand> </serlot> <serlot> <lotcd>t22</lotcd> <onhand>50</onhand> </serlot> </repdata> <repdata> <invcd>1234</invcd> <whs>zxy</whs> <uom>each</uom> <serlot> <lotcd>bb3</lotcd> <onhand>10</onhand> </serlot> </repdata> </smartxml> So if I put in the query /smartxml/repdata then I am able to get the following Invcd 1234 Whs UOM abc each Lot On Hand t12 20 Whs UOM zxy each Lot On Hand bb3 10 This is not correct because when there is more then one serlot tag within the repdata tags then I only get the first occurance. If I put the query to /smartxml/repdata/serlot I then get all occurances of the serlot within the repdata tags but I'm trying to group by Invcd and Whs and it disregards any grouping within the repdata tags. I really hope this makes sense to someone as I am not sure how to resolve getting what I see above but under the first occurance of the lot where there is t12 (lot) and 20 (onhand) there should also be t22 (lot) and 50 (onhand) Any assistance would be greatly appreciated!

Thank you for your help, it worked perfectly!

Thank you for the response. I am using my subreport to display the details of my report and the page numbering is set in my main report however I cannot get the page count to work. I'm trying to display Page X of Y. Any suggestions on how I do this?

Hello, I am using a subreport and want to use page numbering but if I put the page numbering in the main report that calls the sub report then on the first page I get 1 of 1 and the next page which is the detail of my report (subreport) is 2 of 0, then 3 of 0. Does anyone know how I can use page numbering on my report and make it work on both the main report and sub report? Thanks in advance!

Is there a way to check to see if a value of a variable that is performing a count is odd or even value? For example I have created a variable tranno_count. I have a coloured box that is sent to the back of my data and I want to say to print this box when the value of tranno_count is odd. This is so alternate lines are displayed with a coloured background. Does anyone know how/if I can refer to a variable value as being odd or even? Thanks in advance

Hello, I am trying to log into jasperserver as jasperadmin but I cannot remember what the password is. I thought for sure there was a file that contained the usernames and passwords. Can anyone assist me with this. Thanks in advance!

Thank you Scott for your assistance. I have purchased the iReport documentation, unfortunately I do not have it with me today. I will see what I can come up with from the information you gave me!

Hello, Can anyone assist me with Scriplets, what they are and how to use them. I am new to iReport and have been given the suggestion to use scriplets to solve one of my issues, however I'm not really sure what I do. Thanks in advance!