rkm258

Hi, I'am trying to provide a Custom Authentication Filter by defining a filter in the chain, so as to login a user, without using the JasperServer Login Screen. I'am able to login a user with a particular locale using below code. In the same way i would also like to use a 'TimeZone', but i'am unable to find out how i can set it similar to one below. Locale userLocale = LocaleHelper.getInstance().getLocale(locale); req.getSession().setAttribute(JasperServerConstImpl.getUserLocaleSessionAttr(), userLocale); There is a method getUserTimezoneSessionAttr() in JasperServerConstImpl, but i'am unable to find out how i could set value for this attribute. Thanks Ram

Hi, Donot set timezones on the Data sources that u select to run ur reports. In which case it will work fine against the dates in your database. As far as i know, the Timezone u select when entering the JasperServer, would not effect the dates u selected for reports. JS timezone selected will be helpful in operations like Scheduling jobs, where it should be with respect to current time. Ram

Hi, It looks that the JS is not able to obtain JDBC connection. Please make sure u have defined a valid datasource and defined it while creating the JS report. Make sure that ur Database is up and running. While creating JDBC/JNDI Datasource, there is a Test button to test against the database. Ram

Hi, I'am trying to find all the possible ways to embed JasperServer Pro into my application. 1. One way to do so is by using Web-Services Question: What is the Client Class that is used to communicate to Admin Service present at http://127.0.0.1:8080/jasperserver-pro/services/AdminService?wsdl Sample code will be of more help. I didnot find any information in the JasperServer Web Service Guide pdf. 2. Another way that i know of is by using HTTP API, the problem using this approach is that it exposes username and password by using j_username and j_password parameters, which i'am not willing to. Question: How can i get report executed using this and show the results, without showing the top menus, export options like pdf and others like the one present at, super mart demo - Monthly Sales by Quarter. This link will only show the report result, that is what i want. http://127.0.0.1:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&reportUnit=/supermart/salesByMonth/ SalesByMonthReport&standAlone=true&ParentFolderUri=/supermart/salesByMonth Ram

hi, Just thought of informing that the chart u asked for seems to be part of new "sixties" theme, present as part of latest iReports nb tools. Ram

Hi, Even i noticed it happening. I have one more question related to this post. That is, when exporting reports that have graph and say cross tab to excel. I'am seeing only cross tab, there is no graph. Just wondering if exporting to xls file ignores graphs in the report. Thanks Ram

hi, Does anyone has answer to above question i posted earlier. I have seen some webinars which talk about, extending the chart types, adding customizable themes, and using external visualization engines to extend charting capability. JasperServer Pro 3.1 seems to be improved in this way but, I didnot see any documentation on these. Also wondering y there isn't any chart type to be added on using Adhoc Report using Cross Tabs. Adhoc report using Table allows chart types to be added. Thanks Ram

Hi, Sherman, is right, no one generally asks such simple questions. Everything is actually self explanatory in User guide, install guide, admin guide and ultimate guides. There is this great forum with several registered developers to answer advanced questions like customizations, authentication, domains, topics, adhoc reporting, using ireports with jasperserver pro and others. Thanks Ram

Hi, I'am getting an error on saving a chart with meter in it, in iReport 3.1.2. All i have in my report is a meter. Then when i save i get an error: "Error saving the JRXML: null See the log file for more details." The exception is like below java.lang.IllegalStateException: Assertion failed. WindowsAPI is required to be called from AWT thread only, see http://core.netbeans.org/proposals/threading/ at org.netbeans.core.windows.WindowManagerImpl.assertEventDispatchThreadWeak(WindowManagerImpl.java:1438) at org.netbeans.core.windows.WindowManagerImpl.getMainWindow(WindowManagerImpl.java:142) at com.jaspersoft.ireport.designer.utils.Misc.getMainFrame(Misc.java:129) at com.jaspersoft.ireport.designer.utils.Misc.getMainWindow(Misc.java:120) at com.jaspersoft.ireport.designer.JrxmlEditorSupport.saveDocument(JrxmlEditorSupport.java:162) at com.jaspersoft.ireport.designer.JrxmlEditorSupport$1.save(JrxmlEditorSupport.java:73) at org.netbeans.core.NbTopManager.saveAll(NbTopManager.java:283) at org.netbeans.core.NbTopManager.access$300(NbTopManager.java:90) at org.netbeans.core.NbTopManager$NbLifecycleManager.saveAll(NbTopManager.java:440) at org.openide.actions.SaveAllAction.performAction(SaveAllAction.java:111) at org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118) at org.netbeans.modules.openide.util.ActionsBridge$ActionRunnable.actionPerformed(ActionsBridge.java:111) at org.netbeans.core.ModuleActions.invokeAction(ModuleActions.java:104) at org.netbeans.modules.openide.actions.ActionsBridgeImpl.invokeAction(ActionsBridgeImpl.java:52) at org.netbeans.modules.openide.util.ActionsBridge$ActionRunnable.doRun(ActionsBridge.java:102) at org.netbeans.modules.openide.util.ActionsBridge$1.run(ActionsBridge.java:71) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) [catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Thanks Ram

Hi, There seems to be some bugs in IReports 3.1.2, like on 'Replacing with Current JRXML' on the JasperServer Pro, getting an error java.io.IOException: DIME header less than 12 bytes. This seems to be fixed with IReports 3.1.4. Would there be any concern if I use this with JasperServer Pro 3.1, due to the fact that JasperServer Pro uses JasperReports 3.1.2. But IReports 3.1.4 is meant for JasperReports 3.1.4. Should I replace jasperreports jar file in JasperServer Pro ? If so which ones? Please provide any solution. Thanks Ram

hi, i'am using 3.1 jasperserver, but in dashboard there is a meter not that black dial chart. sorry i could not be of any help. ram

Hi, Initially when i started using windows installer of JasperServer, i too had the same problem. Donot use those windows installer. I have a war file distribution, which is working fine. there seems to be some problem with their demo installers. Ram

Hi, You can create them using iReports 3.1.2, and select the type meter in the chart types. I didnot see JasperServer doing that, as the only types it allows on using Adhoc Repoting using charts and table with chart shown are pie, line, bar and area. Ram

Hi, At the link http://www.jaspersoft.com/JasperSoft_JasperServer.html, it is said that customizable chart themes can be used to change the look and feel. I would like to know how these chart types can be extended and made available in jasperserver. For example : When creating Adhoc reports using Chart & Table with chart shown, the only chart types that are made available are bar, pie, line and area. How about using other types like bubble, meter, cadle stick, multi axis, scatter and other types as available in iReports 3.1.2. Is there anyway these themes can be applied when performing adhoc reporting. Also why are there no chart types available to add, to adhoc reports created using Cross Tabs. Thanks Rama Kumar

Hi, By using ROLE_USER role for all the users, any Adhoc Report created say by using Topic is viewed by every other user as well. Is there any way, where Adhoc report created and saved / dashboards created, are viewable only by those who created them. That is i want to provide a personal account storage kind of user interface, instead of a centralized repository control, that jasperserver right now does. What would be the changes needed to do so. Since ROLE_USER has higher privilages, restricting access using "by User" privilage settings is not working. Thanks Ram

Hi, As far as i know there is no such automated process. You need to define all the required elements in the JasperServer. But there is one automated process to move the reporting elements configured once they are in JasperServer using import and export utilities provided. This would be helpful when u are upgrading the server. Ram

Hi, Define 4 parameters, 2 each for the customer and city Parameters - make customer_where and city_where invisible, while defining input controls. Define customer and city parameters as visible input controls in JasperServer for the user to select values. Note: This solution cannot take care of "where 1=1" filter 1. customer <parameter name="customer" isForPrompting="true" class="java.lang.String"> 2. customer_where <parameter name="customer_where" isForPrompting="false" class="java.lang.String"> <defaultValueExpression><![CDATA["customer=$P{customer}"]></defaultValueExpression> </parameter> 3. city <parameter name="city" isForPrompting="true" class="java.lang.String"> 4. city_where <parameter name="city_where" isForPrompting="false" class="java.lang.String"> <defaultValueExpression><![CDATA["and city=$P{city}"]></defaultValueExpression> </parameter> Finally have your query as select * from customer where $P!{customer_where} $P{city_where} order by customer, city Hope this will help. Ram

Hi, Based on the reply i got from the support team, i would like to inform you that in JasperServer, by default any new role created and assigned to a new user, will make the user not to have access to any feature. You should atleast have ROLE_USER, assigned for the user to login and perform certain simple tasks. You can create new ROLES and have access to appl set, but i think this will need certain configurations to be set, which i'am not aware of right now. Please contact the professional services support team, for such customizations. I'am not sure if you will get answer for this here. If you do get, then it will be helpful to me too, as i'am trying to do the same ;-) Ram

Hi, In JasperServer Pro, there is a file named js.quartz.properties file in WEB-INF dir. Set host, username, password and from email address information in that file for the properties having report.scheduler.mail.sender as the prefix. Ram

Swood, Can you please explain how dynamic values can be used in filterExpression. I have a requirement where, i need to search for a value in User Profile Attribute value like <filterExpression>user.user_id in (${user_hierarchy})</filterExpression> where user_hierarchy (a user profile attribute) is a comma separated list of userid's In all the documentation that i have seen only static values are used in the filterExpression Thank You Ram

Hi, For executing JasperServer reports using JasperServer Webservices, just wondering if it possible to send the JDBC Data Source (Driver name, URI, username and password), information to use for executing a report instead of one defined while uploading the Reports into the repository. I did read a post earlier, that this has not been implemented yet, but i'am using JasperServer Pro 3.0.2 and wondering if this is something that has been made possible here. There isn't enough documentation in regard to this other than the web services pdf doc and sample java web appl for the same. Thanks

Hi, What i meant was, having created a virtual datasource for Domains, i tried creating adhoc reports using Create>Ad hoc Report>using domains. The problem is that on running the report, in Ad Hoc Editor, it is not displaying the recent data for the columns, after I made a couple of changes to the database, like changing the username. But the report is still using the same old username. After a while, if i logout and login again, then it shows the database changes i made, i.e new values. Thanks Ram

Hi, Just wondering if there is any caching of data done when 'Adhoc reports' are saved, for example created from domains. When i run the reports saved i donot see the recent snapshot of metadata repository. Some of the changes i made are not reflected. Thanks Ram

Hi, I started using JasperServer a couple of days back, to move all of my exisitng report XML files to jasperserver and hence provide adhoc reports. 1. I would like to use Topic for this task. But most of my reports have Parameters with isForPrompting="false", there are several values that i'am right now sending through the application which is right now using only JasperReports API. I would like to know if Topic has some support for this, may be by some customAdhoc kindof, please provide link to some doc or examples for the same. As shown below these parameters with isForPrompting = "false" are used with $P and $P! syntax. I'am assuming that only parameters with isForPrompting= true can be used for creating the input controls, correct me if i'am wrong. Please seee the code section for sample xml data. 2. Also is there any way i can provide the topic with the connection object to use, on creating the Adhoc reports using them. Code:<parameter name="user_hierarchy" isForPrompting="false" class="java.lang.String"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="actionplan_module_constant" isForPrompting="false" class="java.lang.Integer"> <defaultValueExpression><![CDATA[new Integer(1)]]></defaultValueExpression> </parameter> <queryString><![CDATA[sELECT fields from table WHERE constant_id = $P{actionplan_module_constant})AND apw.assignedto IN ($P!{user_hierarchy})]]></queryString>