mlopez_1
-
Posts
372 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by mlopez_1
-
Be sure that your jar file for using with this scriptlet is in jasperserver/WEB-INF/lib folder and restart server. If not, check out logs for errors. Mariano
-
Try using: where $P{Message} > date_added Using {} and not () If not, use $P{Message} as java.sql.Timestamp Mariano
-
How can i set default value to a parameter by sql query
mlopez_1 replied to snehilitech04's topic in Products
I only use ' Arrays.asList("abc","def") ', the input control must be multiselect query, and parameter must be java.util.List exactly with the same ID. Finally, in the query I use AND $X{IN, FIELD, PARAMETER_ID} Mariano -
Probably may be connections exhausted for server bd. Check out the logs for exceptions. Mariano
-
Make sure that you have both, parameter and input control with exactly the same ID for 'STATES'. Mariano
-
You have to do two things: - Make a variable/s for ordering using Dataset and Query Dialog -> Sorting depeding on the parameter. - Make a group/s in the same order as before, and set Group Properties -> Expression depending on the parameter in the same way as variables did. This works perfectly for me. Mariano
-
With a crosstab. Mariano
-
If I understood, you only have to duplicate textfields that you need. Mariano
-
Try defining $P{select_fac} as String, if the parameter class is ‘java.lang.Boolean’ returns a number. For initializing try: new Boolean(false).toString(). Mariano
-
Tou can search cascading input control at wikipedia and will find: http://community.jaspersoft.com/wiki/cascading-input-controls You can use checkbox and use it in another input control, wirting a query that when recieving false value from this input control doesn't show any record. Mariano
-
Using $X{IN, FIELD_NAME, PARAMETER_NAME} in the final query. Mariano
-
When I had queries with a lot of records a set several cascade input controls for filtering the targeted on then you could manage this table with much less records. Mariano
-
I did this in two ways: - using a variable for detect when group has changed and adding this new value to variable, finally display at footer group. - using stored procedure, a function really, at D.B. level, that return this value coma separated and using it in my query. Mariano
-
Multiselect input controls aren't designed for working with 3000000 values. But you can use a repositorio query for this values, if you have it in table, and put this query in the input control. Mariano
-
!$F{CENTER}.equal("NYC"). Mariano
-
Try to create DATASET with your query and use it i a subreport that retrieve the data desired and stored it in a variable from the subreport to main report. Mariano
-
Create two query in jasperserver: - First with master query, countrys. - Second with slave query depending on parameter retrieved from first query. Now create two input controls, with its parameters inside Report Unit. - First input control single select first query - Second input control single or multiple select with second query. JasperServer refresh second input control automatically when change first input control. Mariano
-
1.- NO, yo have two options: - Install psi-probe and you can see all the logs. - Make a context for tomcat's logs folder to see as virtual folder: https://stackoverflow.com/questions/7068046/how-can-i-list-all-the-files-in-folder-on-tomcat 2.- Perhaps some parameter gives this information, if not, you can write a scriptlet to retrieve all information of tomcat server. Mariano
-
This can help you: http://community.jaspersoft.com/wiki/customer-demo-how-create-multi-select-filter-report When you need something you can find it by searching in this web, it's what i have done. Mariano
-
How can i get data format as 113962 to 113,962 in ireport
mlopez_1 replied to r.reddy.galla's topic in Products
Search for format decimals in java. -
Go to input control folder locations with jaspersever application and right click, select permissions and be sure that ROLE_USER has read only permission. Mariano
-
It's a bug. Take a look at: http://community.jaspersoft.com/jaspersoft-studio/issues/9476 There is referenced another one. Mariano
-
I have a variable called Variable_2, that make a heavy query with a scriptlet that returns a number. Another variable, called Variable_1 is: Variable_1 = Variable_2.longValue() > 0, for visualize deail band. Variable_2 is put in a text field in detail band, and works well. Variable_1 is put in "Print when expression" in detail band property and make Variable_2 a new evaluation, making these heavy query again. Once Variable_1 is evaluated, why only with referenced it at the same level, detail band, evaluate it again, instead of retrieve value previously calculated?. Mariano
-
Hozawa, I think you are right and I was wrong. It's more likely the things you explain. Mariano
-
Assign HTML ID to a jasper element( say a textfield or table)
mlopez_1 replied to ankita.mobifly's topic in Products
I think remember that properties -> appearance -> Key. Mariano
