cinglez

Hello. I have a report published on JasperReports Server 4.7 that is invoked by a URL with parameters. I need to be able to select my data source dynamically because I need to query different schemas on my Oracle database. I mean, the data source name must be passed as a parameter and so the report queries one schema or other. Without that, I must have 2 copies of the same report, each one using one of the datasources. How could I accomplish that (if possible)? Thanks in advance.

Hello. I've been using JasperReports Server 4.0 for a while, calling reports from Oracle Application Express. The form sends the following URL to the JasperServer: http://xxxx.yyyy.com.br:8081/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/MSV/Reports/MsvSac/SAC_APEX_HELP_PAGES&output=pdf&reportLocale=pt_BR&j_username=jasperadmin&j_password=jasperadmin&APEX_APPLICATION_ID=100010010&APEX_PAGE_NUMBER=20&REPORTS_PATH=repo:&APEX_APPLICATION_ID=100010010&APEX_PAGE_NUMBER=20 This works ok with Jasper Reports Server 4.0. Then I installed, on the same server, Jasper Reports Server 5.0, but using other ports. I exported my resources folder from 4.0 and imported into 5.0. The URL turns into this: http://xxxx.yyyy.com.br:8090/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/MSV/Reports/MsvSac/SAC_APEX_HELP_PAGES&output=pdf&reportLocale=pt_BR&j_username=jasperadmin&j_password=jasperadmin&APEX_APPLICATION_ID=100010010&APEX_PAGE_NUMBER=20&REPORTS_PATH=repo:&APEX_APPLICATION_ID=100010010&APEX_PAGE_NUMBER=20. This one does not open my report. In this case, I receive the error: com.jaspersoft.jasperserver.api.JSException: jsexception.could.not.find.resource.with.uri I can run the report on 5.0 if I navigate through the repository and click into it. Any clues? Thanks in advance.

Hello all. I am using iReport 4.0.2. My Windows 7 language is Portuguese (Brazilian), but I would like to use the iReport IDE in English (I am used to it). I couldn't find where to change it. Could you help me, please? Thanks in advance CInglez

In the attached chart, I need the dashed line to go all the way to the X and Y axis. How could I accomplish this? Thanks in advance

Hi. Is there a way to customize the size? I mean, my chart creates squares as shapes, but they are too big. How can I make them smaller? I am using this code: public void customize( JFreeChart jFreeChart, JRChart jrChart ) { XYPlot xyPlot = ( XYPlot )jFreeChart.getPlot(); XYSplineRenderer splineRenderer = new XYSplineRenderer(); splineRenderer.setSeriesShapesVisible( 1, false ); splineRenderer.setSeriesLinesVisible( 1, false ); splineRenderer.setSeriesVisibleInLegend( 1, Boolean.FALSE ); splineRenderer.setBaseItemLabelsVisible(true); splineRenderer.setBaseItemLabelGenerator(new StandardXYItemLabelGenerator()); splineRenderer.setSeriesStroke( 0, new BasicStroke( 1.0f, BasicStroke.CAP_ROUND, BasicStroke.JOIN_ROUND, 1.0f, null, 0.0f ) ); //splineRenderer.setSeriesPaint(0, new Color(0, 1, 165 )); splineRenderer.setSeriesPaint( 0, new Color( 255, 140, 0 ) ); xyPlot.setDataset( 1, xyPlot.getDataset(0) ); XYItemRenderer defaultRenderer = new XYLineAndShapeRenderer(); defaultRenderer.setSeriesVisible( 0, Boolean.FALSE ); defaultRenderer.setSeriesVisibleInLegend( 0, Boolean.FALSE ); xyPlot.setRenderer( 1, defaultRenderer ); xyPlot.setRenderer( 0, splineRenderer ); } } Thanks in advance

Well, since there is no answer, must I assume It cannot be done? Thanks

Hello all. I need to create a graphic (horizontal line), where the values for the X axis are on top AND botton. The plotted values are on botton, and on top there will be referenced values. Example: Y axis: Revenues / Price x axis (botton): Price in US Dollars x axis (top): Price in Brazilian Reais Is there any way to do this ? Thanks in advance

Sorry, I could not understand. What do you mean by "not embedded"? Thanks for the reply

Sure I can. It was a more complex report, so I removed some items like sub-reports and images, but the way it is now you can clearly see the difference between the Windows and Linux server results. I am also attaching the jrxml file. The same file was published on both servers, and the results are different. The workaround I used was to rezise the fields that were missing when using a windows server. Is there anything else I can do? Thanks

Hello all. I have some reports (jrxml) in a JasperReports Server 4.0 repository running on a Linux machine. I exported these reports using js-export (js-export.sh --uris /XXX/Reports --output-dir /home/oracle/jasper_exp). I imported them to another Linux server running the same configuration. Everything fine. But when I imported them into a Windows server, also running JasperReports Server 4.0, some reports do not look the same when displayed. Some text fields seem not to fit in the same frames as before, so them are not displayed. What is the trick? All configs are CE. Thanks in advance.

Hello to all. I have followed the JasperServer Localization Guide, but I have not being successful. I need to create and use a resource bundle for Brazilian portuguese (pt_BR). - I have created te .properties files - I have included the bundle on applicationContext-security.xml - It works IF there is no special characters. I have already changed the applicationContext.xml file: <constructor-arg value="ISO-8859-1"/> But special characters are still not displayed correctly. Any ideas? I have lost a lot of time on this... Thanks in advance.

Hi all. I am new to this forum. I am having a problem when trying to use date columns on an analysis view. When I drill down to day level (the date), I get the following error: "javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy". When I try to run the MDX on Schema Workbench, I get: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Vendas]} ON COLUMNS, Hierarchize(Union(Union(Union(Union({[Periodo].[Todos os Periodos]}, [Periodo].[Todos os Periodos].Children), [Periodo].[Todos os Periodos].[2002].Children), [Periodo].[Todos os Periodos].[2002].[Terceiro Trimestre].Children), [Periodo].[Todos os Periodos].[2002].[Terceiro Trimestre].[Agosto].Children)) ON ROWS from [Vendas] ] Illegal DATE literal: 2002-08-01 00:00:00.0 It seems to be someting with date format (in this case it is an Oracle JDBC connection). For this level (dimension) I use: Type: Date levelType: TimeDays uniqueMembers: true. How should I proceed? Thanks in advance

Hello all. I downloaded viewer_pt_BR.properties and Bundle_pt_BR.properties. I just can't find any doc telling me what to do with those files. Seems to me that those should be used replacing some of the original *.properties files, but there are no files with similar names. I am using JasperServer 3.7. I do have both opensource and licensed Professional editions. Thanks in advance

Hello everybody. Where could I find some demos on JasperAnalysis / JasperServer. It could be online or downloadable. I need to show the features to my colleagues, since we are evaluating the community and professional versions. Is there something like that? Thanks in advance. Carlos Inglez

Well, I followed the JasperServer Localization Guide. I created the files jasperserver_config_pt_BR.properties and jasperserver_messages_pt_BR.properties. Inside the config file I changed the date formats, but could not see where to change the number formats. In the applicationContext-security.xml, I added the line <value type="java.util.Locale">pt_BR</value>. Restarted Jasper Server. The documentation sugests it should follow the user's browser default locale. But I tried it on a brazilian portuguese Windows machine and the number formats are still american-style. On iReport the only thing I did was to change the pattern for that text box to currency (it was showing the american format). What am I missing here? Please help Carlos

Thanks. That did the trick!

It was the tag "Keep Together" in a Report Group. Funny thing is that this option exists on iReport, but is not accepted on Jasper Server. Thanks anyway, it is solved!

Hello everybody. How can I use brazilian portuguese number / date formatting on Jasper Server? I use iReport 3.7 to design the jrxml files. The "pattern" property does not have the option "NNN.NN0,00". Please note that dots and commas do not follow the same patterns as the US number formats. Any help is appreciated. Thanks in advance Carlos Inglez

Hi. Sonalb, how did you do that exactly? I have a specific report giving me the same error. Both iReport and JasperServer are 3.7. Some other simpler reports could be parsed fine. What else should I look for? Thanks in advance.

Hello all. I've installed Jasper Server 3.7.0 on a Linux box. Everything seems to work fine but when I create a new datasource (oracle JDBC), it does not show up on the repository. It seems to be created, since it tested OK (the connection successfully worked), and I cannot create another datasource with the same name (it tells me there is already a resource with that name). How can I see it on the repository navigator (jasperadmin)??? Please help. Carlos

Hello All. I have a special need I still could not find a workaround on iReports. I need to create a report where a master group has 2 same-level detail groups, and they must be displayed as 2 separate repeating frames. Ex: ======================================== Customer: ACME Addresses: aaaaaaaaaa bbbbbbbbbb cccccccccccc Products: xxxxxxxxxxxx yyyyyyyyyyyy zzzzzzzzzzzz. For both addresses and products, the master record is Customer. Is there a way to do so? Thanks in advance. Carlos Inglez

Thanks for the post. It did not work on a 32bit server as well. Thanks again

Thanks for the reply, but I already tried that. It simply did not work, on any of the 3 servers we have. The solution was to install the war version. Thanks again.

Hi. I am trying to run the installer for Linux (jasperserver-3.5.0-linux-installer.bin) on RedHat Enterprise Linux 5. I downloaded the installer and gave the permissions (chmod + x). When I try to run it, it gives me an error: "There has been an error. A debug file has been created at /tmp/bitrock_debug.xml". The file is unreadable (attached). Any ideas? Thanks in advance

Hello all. I am new (evaluating) Jasper Reports / Server, and I just could not find a simple information (sorry if it is too easy). I am trying to create a new datasource on Jasper Server, to connect to an Oracle 11g database. I have already downloaded the jdbc driver from Oracle OTN, but I don't know what to do next. I could make it work perfectly on iReport, but on de Admin console of Jasperserver, after I fill all the information (just like on iReport), the connection testes always fails. I don't know where to put the jar JDBC driver... Any help would be appreciated. Thanks in advance