al881

Use the community edition of JStudio. Concentrate on compiling the .JRXML to .JASPER Go here http://community.jaspersoft.com/questions/847812/implement-ireport-eclipse-java-window-application

I can only speak from integrating JBOSS 5.1 and Jasper Reports 4+ The files I included were jasperreports-4.0.2.jar jasperreports-fonts-4.0.2.jar jasperreports-javaflow-4.0.2.jar We build simple templates (.jrxml) and compile to .jasper files. You package the .jasper files into your WAR file or whatever your deployment file is. Then in your JAVA code, you marry the correct .jasper file to the data you pull from the DB to produce the report. Depending on how large the data is to use for the report, your user experience will be somewhat uncomfortable. Example,let's say the data is 100,000 records of "something". When you transform the data to the report, it will take some time so you need to prep the user to understand this. Here is the flow of what we do: 1. User selects an operation that allows them to pull data back. Usually date driven. 2. This data is displayed in a table (JSP type form ) 3. Below this table are icons to generate or export a Jasper PDF or Excel report. 4. User clicks the icon, which goes to another form that informs user that report may take some time. User presses button to confirm or abort. 5. Then pop up a small window informing "report being generated or ????" Al

Just curious about the printout of the parameters in a log file When the query is listed in jasperserver.log I notice that after the query has completed, there are 2 params being listed. Both have to do with java.util.Date But a lot of my reports have up to 8 parameters and those are not printed out. I thought that there was a relationship between a param being marked as mandatory but in one report (being called from another report), all of the params are optional; yet the 2 java.util.Dates are only printed. JServer Pro, 5.6 2015-02-05 15:33:40,693 DEBUG JRJdbcQueryExecuter,Error Rate - Detail Report subreports #1:396 - Parameter #1 (StartDate of type java.util.Date): Sun Feb 01 00:00:00 UTC 20152015-02-05 15:33:40,693 DEBUG JRJdbcQueryExecuter,Error Rate - Detail Report subreports #1:396 - Parameter #2 (EndDate of type java.util.Date): Sat Feb 28 00:00:00 UTC 2015 Am I missing an item in the log4j.properties file ? Thanks Al

That works

Never mind. Dumb question. The "Print when expresion" is on the chart. I didn't see it.

My charts usually reside in the summary band, so I suppose you can key the Summary band off of a field. if field > 0 ..... But if there are multiple charts in the band and they don't necesarrily synch off of the same field ?

This is the community charts. if the data is empty, how can you avoid displaying the chart?

I was notified that a release might have this enhancement. I can't seem to find a reference to it in release notes. Is it part of the com.jaspersoft.jasperserver.api.metadata.user.domain.User API ? Can I reference it from Studio 5.6 or do I need to upgrade ?

This is for Product Edition: Professional for AWS Features: Fusion AHD EXP DB Product Version: 5.6.1 Build: 20140903_1011 License Type: Commercial Expiration: None On a report that launches another report from the hyperlink: On server V5.6.0 this type of PATH worked: "/Reports/tvol_dba_detail" Aftter migrating the reports to 5.6.1, it does not work. The text needs to be changed to ""/reports/tvol_dba_detail" Note the lower case "r". Both servers show the path as "/Reports/......"

I can confirm that themes now work in the AWS server. This is version 5.6.1 Build: 0140903_1011 Professional version.

After reading about the pro version, you have to match up the countries with a numeric system. Example: 004 = Belize, as an example. You could hard code the values if you want but..... Since i don't have the data in the DB to match that type of requirement I abandoned the Pro and used the Google one. The Google one, which is not as automated as you like via a GUI; must be hand edited in the XML source tab. There is only one document I found that showed the values and that is here: http://jasperreports.sourceforge.net/sample.reference/map/index.html Just drop the XML nodes c:item inside of the c:markerData node. there are 4 items, The latitude and longitude come from my database. You can populate the title and inforwindow with anything. (when you click the location, the infowindow pops up. When you hover your mouse, the title pops up. Here are examples: $F{entityname}+"nSales Volume:"+$V{DBAVolumeTotal}+"nQty:"+$F{qty} "<p style=text-align:right;'></p><pstyle='text-align:left;'><b>"+$F{entityname}+"</b><br/>Sales Volume: <b>"+$V{DBAVolumeTotal}+"</b><br/>Qty: <b>"+$F{qty}+"</b><br/>Address: <b>"+$F{address}+"</b><br/>City: <b>"+$F{city}+"</b></p> You can replace the infowindow with When you click, you can launch another report. You will find in the document "ireport-ultimate-guide.pdf" (even though I don't use iReport, a comment that says): "Using dynamic entities is not simple because ID Expression must return a valid entity ID for the map you have chosen. In order to do so, you must have the map’s entity codes directly in your database and make them appear in the chosen dataset, or you must write a helper class to determine the ID from the geographic name as it appears in your dataset." In this document is where you will find all of the best info for a pro map. Regards

This is the commerical version. Server 5.6.0 located on Amazon. Build: 20140527_1807 Theme updates don't work or does updating a new theme. error is: "syntax error: Unexpected token <" Note that this occurs on a deployed theme from Jaspersoft. So saving the jasper_dark to some new name and uploading the theme fails. Also, I have read the document on themes and inheritance so I modified the logo file and uploaded. This doesn't work after rerstarting Tomcat, even though I can view the changes since I labelled the description field. (Thus it accepted the file) I have restarted server many times and even tried FTP'ing the new theme into the server and trying to install by hand. Still can't do it. Linux protections look ok, no changes that I can see from the command line. All tests work great locally on a laptop,

I'm looking to retrieve the host servers URL. Using something like com.jaspersoft.jasperserver.api.metadata.user.domain.User Is there some API that I can use to get the JR server hostname? looking for http://THIS HERE/jasperserver-pro/flow.html Thanks

How is everyone unistalling Studio from Mac? I do not see any uninstall applications in the /Application/Jaspersoft folders Thanks

Has anyone successfully implemented the Map Pro component? I can't seem to get any type of recognition out of it. I have gone through all of the documentation, including an advanced tutorial. doesn't seem to be doing any good. I went back to the "standard" Map component (looks like a Google one) but you can't assign a separate dataset to the component like you can with the Pro version. Anyone know of any good demo's using the Map Pro component? Thanks

This was shown to JR personnel on a con call 2 weeks ago. Not sure if there will be an update to remedy the problem. More clarity on how report is set up. The table is set up in the Summary band. After report runs the first time, I click a hyper link that is set up on one of the columns data. This hyperlink calls another report. After the second report completes, press the back button. This triggers the main report to run again. After the report has complete, navigate to the page that starts the table. When the table becomes visible, the pop up message starts. Note that the table is the 3rd element in the summary band. So this means the table does not become visible until page 3. This is occurring on multiple reports

V5.6, commerical. (Mac ) When working remotely, you sometimes have to place a LIMIT on data being retrieved. Whether it's a poor internect conenction (VPN, home, etc) you need to modify SQL at times to: 1. Check SQL to make sure LIMIT is removed, before deployment 2. Just causally looking at the SQL I need a way to prevent Studio from always making an ssumption that everytime you view a dataset you try and connect to the database. Many options to make Studio better: 1. Turn off connnection unlkess needed 2. Quick view of SQL Any way of preventing connection attempt in Studio? Regards and thanks Al

Thanks for the post. I'll look it over when I can

My point was about redundant SQL calls. The main one and the tables dataset are identical. I want to pass the data from the first query to the table. I found an example but doesn't seem to work.

If you go to the server and delete the report and re-deploy; it works. No changes to files was done Al

This is 5.6 professional. Studio and Server I have a report, which has 6 sub-reports inside. From Studio, when you deploy the main report, the pop up dialog shows the six sub-reports...."repo:sub-report.JRXML" All is ok, and deploys fine. When running the report, the error is "Resource not found at: sub_report.JASPER". NOTE the JASPER and JRXML above. I have gone thorugh all of the pdf's and there is not much documents on sub-report deployment. To add more confusion to this, last week I changed the .JRXML reference to .JASPER in Studio and I got it to work. Then when I ran the report locally from Studio today, there was a Java error that lead me to rename the deployed files back to .JRXML and re-deploy LOCALLY; which worked. So I think that if I do the same for the remote server, I can get it work, but this doesn't help in understanding what real problem is. Any help appreciated, Regards and thanks, Al

I have a query that takes some time. This query pulls back data (groups) etc. I then have a table. I want to pass some of the data to the table and display it. (I do not want to pass params into the tables dataset, since i can do this) But I want the data to display from the previous query. The tables dataset will be a dummy query. Here is an example: select names from table where dates = xxxxxx group by names. Then I want to display those names on the table. Regards and thanks

Attached. When the second report returns back to the first. The first report runs. Then when the TALBE becomes visible, this popup occurs.

generic properties not set for interactive column

The question is the error I receive on the server. V5.5 I have a report that calls another report (not a sub report) from a hyperlink on a table. (among other items) The main reports table has 4 columns. One of them is a hyperlink that calls another report. Parameters passed are 2 dates and one BigDecimal. All is ok . Both reports work. When I go back and run the main report, when I reach the page that has the table, I get the popup error. Each page I advance triggers the popup when the table is active. The hyperlink still works. If I go back to the repository menu and load the main report, and fill in the input params, the error is gone and the hyperlink works fine. After clicking the link, the report is generated ok and when I return back to the main report; the error starts again. Catalina.out log looks clean. Regards and thanks