jo.jasmine
-
Posts
16 -
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 jo.jasmine
-
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?
jo.jasmine replied to tinagoepp's topic in Products
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 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
-
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
-
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.
jo.jasmine replied to amrutaa's topic in Products
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?
jo.jasmine replied to daad.madhusudan's topic in Products
Did you try using Groups? So that it would be easy for debugging also. -
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.
-
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
-
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.
-
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
-
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
-
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?
jo.jasmine replied to jo.jasmine's topic in Products
Thank You for your input -
Hi Guys, Can anyone share thoughts of improving the performance of Jasper Dashboard? Thanks, Jo
