[Yet Another Excel Worksheet Question]

Yes. Let Tab 4 be a another subreport (new jasper report) with the same query without groupby.

Then combine the subreport to the mainreport and make it to display at tab 4. 

 

[How can I use a parmeter to define the where clause of my report?]

Hi Tina,

below is the sample where clause that should like in your sql. Here ID is your database column, P_ID is the parameter name

where ID = $P{P_ID}. Then go to parameters tab, create a new parameter of data type either string or number and enable (check) the prompt button.

That's it. Run the report and see how it works now

 

[How to print dynamic field in to report using sql]

How many values/rows that your field have?

for your example, this is what I do.

I will drag the field/column thrice into detail band. for the first column, I use print when expression and write

$V{REPORT_COUNT}==1

which means that the first row is displayed. Similarly, I will do for the other two columns.

If your field has more than 5 values then you need to consider for another choice.

 

Let me know how it worked for you

 

[Crosstab report Measure count]

Try this.

create 4 varaibles v1,v2,v3,v4 of integer data type

v1 -> $F{Account1} == 0 ? 0:1

v2 -> $F{Account2} == 0 ? 0:1

v3 -> $F{Account3} == 0 ?  0:1

v4-> $V{v1}+$V{v2}+$V{v3}

create a new column label as NonZero Value Count(  - column header )and have the value as $V{v4} ( - detail band)

Let me know if you face any issue

 

 

 

 

[FORMATS IN DATES iReport 5,6,0]

Hi There,

Can you express in english so that I can provide you the solution with the dates stuff

[How to auto size column width in excel export of Jasperserver.]

Click on the main report and go the advanced option and hit the propteries. This is the place where we can set properties while excel exporting in Jasper Server.

[How to overcome band height limitation issue?]

Did you try using Groups? So that it would be easy for debugging also.

[How I can repeat the same report in 1 sheet?]

Yes. subreport will surely.

Let your report be Report1. Save as this Report1 as Report2 in the same location.

Now think of your Report1 is your first subreport and Report2 is your second subreport.

Finally create a main report which can consume the above subreports.  Place these subreports in 2 different groups.  Thus, you can see the same result coming twice in the sheet.

There might be other solution without using subreports also.

 

 

 

 

 

 

 

 

[How to setup the subreport and main report of jasper studio in Jasper server]

Just publish the main report to jasper server. That's it. 

While published in jasper server, it will show your subreport as a resource used in main report.  just click on the location where you need to publisha and ensure that you've associated the data source to the report

[How to setup the subreport and main report of jasper studio in Jasper server]

Just publish the main report to jasper server. That's it. 

While published in jasper server, it will show your subreport as a resource used in main report.  just click on the location where you need to publisha and ensure that you've associated the data source to the report. 

 

[2 subreports consumed in Main report doesn't give the expected the output?]

Hi Guys,

Need help in the below issue.

 

I've created 2 sub reports (each subreport output is 3 pages ).

 

When I used the first sub report in the first group header of my main report, I got 3 pages jasper output as expected.

 

However, when I used the second subreport in the second group header of my main report, jasper gives me 18 pages of output (the first 3 pages is the output for first subreport and all other pages are blank)

 

Can you help me how to resolve this?

 

Why jasper gives such output when I consumed the second subreport?

 

Thank You

[Jasper cannot read the SQL Fields? Why?]

Hi Guys,

I ran a query against the database. I could see the results generated. However, when I use the same query in Jasper, it cannot read the fields. Suprisengly, jasper didn't throw any error as well.

Why Jasper cannot the read the fields for a successful ran sql query?

Thank You

[How to use multiple Data Sources in a Jasper Report?]

Hi Guys,

I need to create a Jasper report with 3 sub reports. 2 sub reports use data source say DS1 and the other sub report use data souce DS2. When I tried to preview the main report, it throws a sql error. Can anyone help me how to acheive this?

Thanks,

Andy

[How to improve performance of an Jasper Dashboard?]

Thank You for your input

[How to improve performance of an Jasper Dashboard?]

Hi Guys,

Can anyone share thoughts of improving the performance of Jasper Dashboard?

 

Thanks,

Jo