yskripch

Hello, Currently, I am having problems when I mouse over a hyperlink, the hyperlink does not change color. Am I the only one having this problem as I didnt see any other posts? If anybody know where I can look to fix this that would be great or maybe post there mdxtable.css or styles.css or stylesheet.css that would be helpful for me to compare to my own. Thanks for the help.

I wish there was a way to do this. :D , if anybody finds a way I would be interested to know as well.

When you are passing parameters between reports you have to make sure you specify the exact name of the parameters from the 2nd report on the hyperlink tab in the 1st report. So if my parameter name is "Customer_last_Name". When in the hyperlink tab, I click on add parameter and I use "Customer_last_Name" as the link parameter name and then I specify the correct class and then on the expression I would put in something like this "$P{Customer_last_Name} for the local parameter I am passing to the 2nd report. You can also replace it with a $F if you want to pass fields. Check to make sure your names match.

Can you login into JS-Pro using the defualt url? If not, then you have to get the correct URL and make sure you have the apache server or jboss running.

Hello All, I have the classic 3.0 version of Ireport and the new 3.1.4 version of Ireport. I like the net beans look and it works great. The one thing I cannot figure out is how do you link input controls to reports in the new 3.1.4 version of IReport. In the old version it was very easy to link them because as you right click on "Input Control" you have the options of creating a new control or linking one. This was very useful for me as it allowed me to reuse many input controls between reports. I cannot find the same feature in the new version. If anybody could tell me how to do this, I would appreciate it greatly. Thanks in advance.

Ok. That sounds great. Where should I put the code for the scriptlet you posted? Sorry for such a simple answer but I am new to reporting software and web developemt languages. Also, you are importing "import org.apache.commons.lang.WordUtils;" do I need a class or jar in my apache to have this work? Thanks, I appreciate all the help.

Hello all, I have a problem that the string that I am retrieving from the database is very long. It can be over 1000 characters and it does not have any white spaces. The problem is that I cannot make a field big enough to cover the full string. I would like to be able to insert white space or new line characters into the string so that JasperReports would wrap the string on the white spaces. If anybody knows how to do this, please let me know. I have been trying to come up with a way for a couple of weeks and still have not managed to find one. Thanks for all the help. Yuriy

I am also, curious if there is an answer for this inquiry. I have a similar query. Where I use select stuff from some_table $P!{WhereStatement} I was told this should work, but I receive the same error.

I usually convert the BigDecimal to a Double then I can just use the minus sign. so my code for the variable looks like this. new Double (someValue.doubleValue() - someOtherValue.doubleValue() ) hope this helps.

Are you grouping the values in your sql statement?

You should try using java.sql.Timestamp class rather then java.util.Date. The date class will truncate the time when it is converted to java.sql.Date so using the timestamp is the only way I found to over come the problem. Hope this helps.

most likely it would work because most of the files are the same

The only one I could think of was to design a second report that drills down to the main report when the user clicks on a parameter. If there is a better way of doing this then please me know. Thanks.

There are two ways to solve this problem. 1st: Have the input control use the date/time datatype which will allow the users to select the date and time. You would have to set the parameter class to Timestamp. 2nd: Have the users select only the date and then modify that parameter to include the correct timestamp. The tricky part is that you must use the java.sql.Timestamp class because it holds on to the timestamp. If you use the java.util.Date class then the timestamp will be truncated when the Date class is changed to java.sql.Date class. Hope this helps.

As far as I know that is not possible. I was interested in a similar feature and I was told by JasperServer Support that it is not possible to use parameters in other input controls.

Here is what I did: 1. Create a parent folder. 2. put the folder you want inside the parent folder. 3. Set the parent folder permission to "No Access" 4. Set the child folder permission to "Read Access:" This will hide the folder from the user while allowing the items within the child folder to be accessed by the report system. Hope this helps.

Here is what I did: If you create a parent folder and place your image folder (or any other folder) into it. Then give the parent folder "No Access" to the users but set the permission to "Read" for your image folder (or any other folder) then the reports can be ran but the user will not see those folders in the repository. Hope this helps.

Hello All, I have been using JasperServer and iReport for a couple of months now and I have worked out most of the bugs I have with it. The last problem I cant figure out is how to specify the time in a date parameter. What I would like to do is be able to search a query based on dates and time. Normally the following code would work select * from table where date between to_date('' 11/18/2008 00:00:00','mm-dd-YYYY HH24:MI:SS') and to_date('11/18/2008 23:59:59','mm-dd-YYYY HH24:MI:SS') But when I have my user input set to use date datatypes, it passes the date but the time is always is set to midnight. I would like to be able to change the time to 11:59pm of the selected date. I do not want to use the date/time datatype because that would force the users to set the time themselves and our previous reporting system did not require that. Does anyone know how this can be done? The only way I have thought of is to use a scriplet to change the time after the user selects the date in the parameter so that I could just use the parameters in the query. But if there is an easier way of doing this please let me know. Thanks a lot.

Hey, Thanks for the reply. I figured out what was wrong. I wasn't using the correct path. I was using the label of the folder and not its unique name when I was specifying the uri. So my folder was labeled as hidden reports but its unique was hidden_reports. When i was specifying the uri I did /root/hidden reports and so I was missing the "_" in the name. Thanks for the reply.

I just tried that and excel saved it as an xml spreadsheet. The way I would like to have the report look is like the following: <Title> Report 1 </Title> <data> stuffstuffstuffstuffstuff stuff stuff stuffstuff </data> So this can be easily parsed based on the identifiers between the < >. This was possible in jasper decisions.

So, How would I convert Excel or HTML to XML format? Would I need to write a script to do that or is there a plugin available somewhere? Thanks.

Hello, I am running JasperServer 3.0 and I would like to be able to have my users download the reports in xml format. On the documentation it says that JasperServer supports xml output format but it does not say how I can add the functionality to the JasperServer. I have found the necessary files that need to be edited so that the necessary buttons and functionality is added, but I do not know how to invocate the xml exporter. I have attached the files that I believe need to be edited so that JasperServer can use the xml exporting function. If anybody has any ideas how this can be done please let me know. Thanks.

Hello, I am trying to export the reports I have made on my local machine so that I may upload them to the server at my company. I receive the following error when trying to run the export utility. 16:19:26,281 WARN ResourceBundleMessageSource:184 - ResourceBundle [bundles.jsexceptions_messages] not found for MessageSource: Can't find bundle for base name bundles.jsexceptions_messages, locale en_US jsexception.uri.not.found the command I am running is: js-export.bat --uris /folder1,/folder2,/folder3 --output-zip myFolders.zip Let me know if you have any ideas how I can fix this. Thanks a lot.

Thanks for the way to make it work..I dont know why I didnt think of it. lol..Thanks again.

The first case you described is the one that I needed. Thanks for the quick reply. I will try it out now.