santhosh.devadurga
-
Posts
8 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Everything posted by santhosh.devadurga
-
Using Parameters in FROM part of a SQL query
santhosh.devadurga replied to j.seyfriedxiiix.de's topic in Products
I would suggest you to create a one more parameter like, Parameter Name: LanguageValue Class: String Expression: $P{language} + "_article_view_full" ( better handle the null or empty value cases for $P{language} ) Then query like, SELECT * FROM $P!{languageValue} ( ! should be there ) Let me know if you have any concerns -
Using With in SQL Statment Jaspersever 7 in a container
santhosh.devadurga replied to beard9982's topic in Products
Make sure you have restrated the server for the property to take effect. Still if it does not work, then try this. Make the value to false for property security.validation.sql.on=true in file WEB-INFclassesesapisecurity-config.properties and restart the application server for the property to take effect. -
Error evaluating expression for Oracle Connection
santhosh.devadurga replied to vs06's topic in Products
Hello vs06, change the report language from "Groovy" to "Java". -
Error evaluating expression for Oracle Connection
santhosh.devadurga replied to vs06's topic in Products
Try using forward slash instead of colon (":") for providing service name (in your case MYDB), like java.sql.DriverManager.getConnection("jdbc:oracle:thin:@"+$F{SERVER}+":"+$F{PORT}+"/"+$F{SERVICE}, $F{USERNAME},$F{PWD}) -
Hello CaPsLoCkEr, please share the logic/expressions used for creating 2 variables: 1, firstDayOfLastMonth and 2, lastDayOfLastMonth.
-
Yes, it can be done by using subreports. While adding a sub report it will ask for a connection, instead of selecting "Use same JDBC connection used to fill the master report" select "Use another connection" and provide the expression to your required DB. Sample expression : java.sql.DriverManager.getConnection("jdbc:oracle:thin:@"+$F{SERVER}+":"+$F{PORT}+"/"+$F{SERVICE}, $F{USERNAME},$F{PWD}) Hope it will resolve your problem.
-
Yes, it can be done by using subreports. While adding a sub report it will ask for a connection, instead of selecting "Use same JDBC connection used to fill the master report" select "Use another connection" and provide the expression to your required DB. Sample expression : java.sql.DriverManager.getConnection("jdbc:oracle:thin:@"+$F{SERVER}+":"+$F{PORT}+"/"+$F{SERVICE}, $F{USERNAME},$F{PWD}) Hope it will resolve your problem.
-
Hi Manohar, Putting all those fields(Above the Grade sheet) into one frame may solve your problem. And even try work around with the Opaque property of the fields. Hope this will help you.
