tejeshwar

Hello, I have created a Hyperlink for the Crosstab measure Group cell. However now, the Hyperlink appears for all the cells present under Measure Group. The requirement is to give the Hyperlink to only the cells with a particular value in the Measure. That is, if the Cells under Measure Group have values like 3,4,7. I am trying to set the hyperlink to the cells having the value as 3 only and not to the cells having the other two values. Thank you, Tejeshwar

Hello, I have been workig on crosstab on Ireport Pro 3.5. How can we edit the Height of the Crosstab RowHeader Cell. The Height seems to consistent and i am nt able to modify it using the Grid Lines provided. Thank You, Tejeshwar

Hello, Does anyone have a demo JRXML of a Gantt Chart. I am Trying to create one ans want to know more details about the Gantt Chart. Thank You, Tejeshwar

Hello, When trying to access to the Login page of our JasperServer Install. we are getting an loginerror.html page with the message, "Invalid credentials supplied. Could not login to JasperServer." When checked in the logs, the error message has been given as, 2009-08-19 09:00:56,634 ERROR hrjasp - HRJASP???? 9999 [{0}=Missing VIRTUAL_SESSION_ID] 2009-08-19 09:00:57,227 WARN JILicenseFilter - Licence acceptée. La licence JasperAnalysis Professionnel Commerciale expire le 12/15/10 12:59 AM. 2009-08-19 09:00:57,234 WARN JSCommonController - There was a login error 2009-08-19 09:00:57,278 INFO ResourceBundleThemeSource - Theme created: name 'theme', basename [theme] 2009-08-19 09:00:57,280 INFO ExpressionEvaluationUtils - Found JSP 2.0 ExpressionEvaluator 2009-08-19 09:00:57,287 INFO ExpressionEvaluationUtils - Found Jakarta JSTL ExpressionEvaluatorManager 2009-08-19 09:03:11,277 ERROR hrjasp - HRJASP???? 9999 [{0}=Missing VIRTUAL_SESSION_ID] 2009-08-19 09:03:11,318 WARN JSCommonController - There was a login error 2009-08-19 09:08:09,040 WARN JSCommonController - There was a login error What could be the possible Issue in the install. We have Tomcat as our web server. Thank You, Tejeshwar

Hello, While generating a Cross Tab one of the requirements is to Give different Color codes to different Sets of Cross Tab Cells under the Measure. That is, if we consider Sales as a measure, i want to color the cells with Sales value less than 1000 as one color, then Color Sales between 1000 - 10000 with one color and if sales value is greater than 10000, another color will be assigned. Is there a way to implement this. Assigning different Color codes to different cells based on the data of the cell. Thank You, Tejeshwar

Hello, i was able to implement Column level security in a domain succesfully. however, i am unable to implement row level security in my domain, this is the XML Code is used for Row level: <securityDefinition xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema" version="1.0" itemGroupDefaultAccess="granted"> <resourceAccessGrants> <resourceAccessGrantList id="EMP_INFO_resource_access_grant" label="optionalLabel" resourceId="JoinTree_1"> <resourceAccessGrants> <resourceAccessGrant id="EMP_INFO_row_grant"> <principalExpression><![CDATA[authentication.getPrincipal().getAttributes().any{it.getAttrName() in ['Country'] && it.getAttrValue() in ['USA'] }]]></principalExpression> <filterExpression>HR_ED00.EMPID IN ('ATS0111')</filterExpression> </resourceAccessGrant> </resourceAccessGrants> </resourceAccessGrantList> </resourceAccessGrants> </securityDefinition> i am getting the follwing error in the log Caused by: java.lang.IllegalArgumentException: exception parsing filter string ' HR_ED00.EMPID IN ('ATS0111')' what is the correct format of Filter Expression to be used in file. the format i am currently using is "<JDBC Table ID>.<Field ID> in ('<string>') please provide with the correct format to use and any additional information on the topic will be really helpful. Thanks, Tejeshwar

Hello, i have uninstalled 3.0 and deleted the folder in Program files and tried installing Jasper Server 3.1. However, at the end of installation i am gettting a pop message showing a "Post Installation Error" couldnt access mysql with the username "Jasperdb @ localhost" and the Server is functioning. is there anything else we have to do before installing the 3.1 jasperserver. please help. Thanks, Tejeshwar

Hello, where to Download the DomainIRPlugin-1.0.jar. i am using Ireport 3.0 and Jasper server pro 3.0. it is automatically available as mentioned in the manual. Thanks.

Hello, where to Download the DomainIRPlugin-1.0.jar. i am using Ireport 3.0 and Jasper server pro 3.0. it is automatically available as mentioned in the manual. Thanks.

Hello, When i am trying to update the SQL Query in an input control and saving it, it is throwing up an exception in a pop up as, org.hibernate.exception.GenericJDBCException : Could not insert any idea why this is happening. Thanks.

Hello is there any way to Reduce the number of Tables in a datasource while creating it in the JasperServer. it is because, i am trying to create a Domain using a certain JDBC datasource, but Tables of the Datasource arenot loading in the launch designer, and this should be because of the large number of tables in the Datasource being used. Thanks.

how can we use a variable which gives the max value of a Field as a Default Value of Parameter in the query

Hi i have been trying to execute a SQL Query in the Default Value Expression of a Parameter in my report using Java coding. but when i try to execute the report, the Portal is showing compilation Errors. is there any specific method to use a SQL query in the Default Value Expression of a parameter Thanks, Tejeshwar

Hello, i have been trying to create a Domain using the an Oracle JDBC database as the datasource. But when i launch the Domain Designer and select the Schema, the tables arent being listed and the portal is not responding. can anyone explain the cause of this. Thanks, Tejeshwar.

Hi, Can the Default page size in the Adhoc Reports section, be set to A4 size as the default value, instead of the Letter size. how can we do this. Thanks.

tejeshwar Wrote:sorry didnt notice the option i adhoc report page..can somebody delete this post... Hello, I need to get the "Row Count" of the report for a Table Adhoc Report and display it along with the Data in the Report. is there a way to do it.. Thanks Tejeshwar.

Hello, I need to get the "Row Count" of the report for a Table Adhoc Report and display it along with the Data in the Report. is there a way to do it.. Thanks Tejeshwar.

Yes the browser has been set to a French Locale and im logging in by setting the Locale to French, still the special characters are not being recognised and the fields are not appearing. Thanks, Tejeshwar.

Hi, i have been tryin to implement adhoc reports, where the Field label have been given in Frecnh. However, when i have run a specific report and am trying to add the one of the fields having a special character like 'é' in the word "Prénom" , the field doesnt appear in the "Report Selector" window. is there any solution for resolving the issue, so that we can add fields containing special characters. Thank you, Tejeshwar.

In Adhoc Reports the values which are numeric in nature are being displayed in the format "9999.99" is there a way to display them without the decimals, other using the to_char() function in the adhoc query, because using to_char() disables the functions we can perform on the numeric fields in the adhoc editor. Thank You, Tejeshwar.

i have tried to generate a Bar Chart from an SQL query which gave the Fields, - Year as a Number, - Age with Possible Values as -'Age - less than 18 years' -'Age - 18 to less than 35 years' -'Age - 35 and above' i created a Group with the Group Expression as '$F{Age}' A variable Age_C was Created with Calculation Type as 'Count' and Reset Type as 'Group' with the Reset Group being 'Age'. then for the Chart Properties, Category Expression as - $F{Year} Value Expression as - $V{Age_C} With the Follwing the Details im able to generate a Bar Chart, but the details in the Value Axis are proper. with some garbage Values. i tried implementing the report by deploying and generating a chart of the same details. when i saved it and compared the details of my original report with the report generated using Adhoc Editor, though the details and Variables were similar, the adhoc reports output was fine unlike the original jrxml's output. it would be really great if somebody can help me with this issue. Thank You, Tejeshwar

Hi Srikanth, Thanks for the reply...report is working fine now.

Hi i had created a adhoc report for which i wanted to use a certain date as a FILTER i followed the procedure by creating a parameter and then following up that by creating a date Input Control of the same name as the parameter. But when im trying to run the adhoc report from the server its giving me an error in popup as "You may need to use iReport to change the default values of some parameters." need assistance regarding this error. Thank You, Tejeshwar

How to declare a default value for a parameter whose parametr class is date need the format for giving the default date value. i have tried different combinations and it seems to like not taking the years above 2000. -Tejeshwar

hi im getting the following error after i have deployed a report in the adhoc editor and trying to run it.. java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1355) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSourceFactory.registerDriver(DbcpDataSourceFactory.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSourceFactory.createPooledDataSource(DbcpDataSourceFactory.java:42) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcReportDataSourceServiceFactory.getPoolDataSource(JdbcReportDataSourceServiceFactory.java:168) at can somebody help me with the following error... thank you, tejeshwar