[Report loading time issue]

When i am executing query from MYSQL it is taking  "Showing rows 0 - 499 (68311 total, Query took 0.0102 seconds.)".

I execute this query from Jasper admin and its taking 3-4 seconds to load first page then its processing for remaining pages.

But when i am using visualize.js to fetch data then its taking more than 30 seconds to load the data. some times 40 seconds.

I am not sute but I think visualize.js waits untill all pages are getting execute.

I want to set same mechanism as Jasper admin in visualize.js.

 

Can any one help me, why visualize.js taking big time.

[how to sort all fields using ireport]

i need to set sorting on every fields of my report, not by order by in sql query.

[how to sort all fields using ireport]

I want to set sort options on each fields, not by order by in sql.
 

[how to sort all fields using ireport]

Hello,

I have created one report with two subreports without table structure.

Now i want to set sort option on all fields.

How to set ascending, descding to all fields.

[How to divide data column wise]

I am using mysql.

[How to divide data column wise]

Hello,
I want to divide data column wise.
How to displya them.
Like

my query is "select name from user where user_n_id = 22"
I get

  Name
1 ABC
2 CDF

I want to display like this :

Name1   Name2
ABC         CDF

[Inline (toggle) report is possible using visualize.js ?]

I want dril-down report using visualize.js.

Is it possible to open report like toggle functionality in Visualize.js ?

like

id name count

1  k         2

2  b          34

 

now click on 2 count new report open below 2.

and click on 32 new report will open below 34.

[How to get value using visualizejs]

I want to check condition of my data, that if i get value 0 then color is blue else color is green.

 

[how to set pagination in drill report or rendering another report into main report]

I want to set pagination in my main report as well as on click on link i am rendering other report so  i also want to set pagination in other report also.

[how to print first page immediately of my report using visualize.js]

There is five pages of my report, so to load all data it is taking 4 minutes,

is there any way that i print first page immediately using visualize.js.

[how to print 0 to 24]

I am using ireport,

i want to print 0 to 24 through loop or any other condition, kindly guide me

how can i print data 0,1,2....24

 

[how to reduce execution time using visualize.js]

I have created one report in jasperserver.

When I run this report in jasperserver admin panel, it is taking 90 seconds,

but when the same report I am executing using visualize.js in my web page it is taking 5 minutes.

So how can i reduce execution time using visualize.js ?

[how to display first row data in the report]

I still didnt receive any answer of this question.

CCan anyone help me

[how to connect mdb in ireport or jaspersoft studio in windows 8.1]

thanks hozawa

[how to connect mdb in ireport or jaspersoft studio in windows 8.1]

when i connect mdb through jaspersoft studio it show me error of  java.lang.ClassNotFoundException : com.ms.jdbc.odbc.JdbcOdbcDriver

also i am not able to connect mdb in iReport 5.6.. in windows 8.1.

how can i connect mdb in jasperserver pro ?

[how to remove gap between two sub report]

not done.

ccan you give me an example

[how to remove gap between two sub report]

/sites/default/files/images/subreport_gap.png

getting gap between two sub reports

[how to remove gap between two sub report]

still i didnt receive any answer of my issue.

[how to remove gap between two sub report]

I want to remove gap between two sub reports as my fields are comming dynamically.

how can i set dynamic page width

[Print subreport horizontal]

1 > go to report properties.

2> set print order : Horizontal

3>  set Columns as 15 or whatever you like

4>  set Column width 70 or whatever you like

 

 

[how to print dynamic fields]

I wan to print dynamic field into my report.

Like From my query i got result

Name

a

b

c

now i want to display this value as a field like:

a                      b                        c

[how to get sum of field value]

hello,

in my subreport, my query is select  mobile from emp where id = 12;

when i run this query i am getting data

8888888888

2222222222

now in my main report i want to displya record like this:

name   mobile1            mobile 2

abc     8888888888      2222222222

[how to get sum of field value]

hello,

in my subreport, my query is select  mobile from emp where id = 12;

when i run this query i am getting data

8888888888

2222222222

now in my main report i want to displya record like this:

name   mobile1            mobile 2

abc     8888888888      2222222222

[how to get sum of field value]

Hello,
I want to print sum of total values of my field into my result:

in my table report

like

name  mark   total

aa        3         16

bb        6         16

cc       7           16

[how to display first row data in the report]

hello,

in my subreport, my query is select  mobile from emp where id = 12;

when i run this query i am getting data

8888888888

2222222222

now in my main report i want to displya record like this:

name   mobile1            mobile 2

abc     8888888888      2222222222

 

 

how to do this.

please anyone help me.