Jump to content

imrohithsnair

Members
  • Posts

    10
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by imrohithsnair

  1. MYSQL with clause in Jasperreport  and Jasper Soft Studio

    WITH
      tb1 AS (SELECT a, b FROM table1),
      tb2 AS (SELECT c, d FROM table2)
    SELECT b, d FROM tb1 JOIN tb2
    WHERE tb1.a = tb2.c;

    I need to use query like above example in MySql dataset, can i able to use?

    I have tried like this but i couldn't able.

    Thank You in advance

  2. In below example I need red lined measure tab should be in yellow colured column 03/10/20 as well as gery lined 

    beacause in 01/10/20 there is two result "01/10/20"and "01/10/20" 

    respectively 

    in 03/10/20 there is two result "03/10/20"and "03/10/20"

    I need in first two column of measure...."there will be many result it should need to start from first"

    is there any idea 

    screenshot_2020-11-27_181458.png.1fb7f226d5cb020e405b9b1d8e3a5c46.png

  3. I can change Color of the field by inserting conditional style.

    My question is if my field value is with AB-CD

    i need to split AB and CD and change AB with one color and CD with another color

    i can able to split value but i could'nt able to change the style

    is there is any method to todo?

    Thanks in Advance

  4. The clause is used to check whether a particular value is present in a discrete set of values. Here is an example:

    SELECT * FROM ORDERS WHERE SHIPCOUNTRY IS IN ('USA','Italy','Germany')

    The set here is defined by the countries USA, Italy and Germany. Assuming we are passing the set of countries in a list (or better a java.util.Collection) or in an array, the syntax to make the previous query dynamic in reference to the set of countries is:

    SELECT * FROM ORDERS WHERE $X{IN, SHIPCOUNTRY, myCountries}

    where myCountries is the name of the parameter that contains the set of country names. The $X{} clause recognizes three parameters:

    Type of function to apply (IN or NOTIN)

    Field name to be evaluated

    Parameter name

    Above example works perfectly...

    My questions is?

    how to dynamically change Field name by passing parameter?

    i have tried by passing parameter for field name $P{...} but couldn't

     

  5. I'm using JDBC database as dataadapter, it almost take 2min and 10 sec for 2000-3000 rows. Is there any tips or method to make report filling faster for JDBC dataset in Jaspersoft studio as well as in jasperreport while exporting

×
×
  • Create New...