[How to force column headers to not repeat in 4 column report]

Thank you Olyncircle! That worked.

I alwys thought column_number variable would store how many columns (fields) we have on the report. But looks like column count tells how many columns we are displaying vertically for each distinct row, which in my case was 4. 

[How to force column headers to not repeat in 4 column report]

Uploaded files. Hope this helps you understand my question. I changed data from my sample to different dataset but the layout is same. 

[How to force column headers to not repeat in 4 column report]

Hello everyone, Is it possible to force column headings to show only once for first row on each page? I have a column styled report and I am showing 4 rows in vertical format and column headings are repeating for all four rows hence creating space problems. 

Currennt sample out put:

Page 1

FirsName:    John Smith       First Name: Ebony Clyde       First Name: Ekin Johove      First Name: Dolat Ram

Dept:            HR                   Dept:            HR                      Dept:            FIN                  Dept:            IT

Salary:         40000              Salary:         38000                   Salary:         50000               Salary:         20000

DESIRED OUTPUT:

Page 1

FirsName:    John Smith     Ebony Clyde     Ekin Johove    Dolat Ram

Dept:            HR                  HR                    FIN                  IT

Salary:         40000              38000               50000               20000

 

[Sub report within a subreport error "resource not found at subreports/"]

That's what I have. Only first  level sub-report is working and sub-report inside sub-report is not working. Sub reports are linked like the following:

First sub report : SUBREPORT_DIR+ "sub-report1.jasper"

2nd level sub-report: SUBREPORT_DIR + "sub-sub-report1.jasper"

[Sub report within a subreport error "resource not found at subreports/"]

Hi Everyone,

I have a main report, main_report.jrxml which has a sub report called sub-report1.jasper and which also has a sub report called sub-subreport1.jasper. My main report is not able to find the sub report that is inside another subreport. Getting error:  "resource not fount at "subreports/sub-subreport1.jasper". 

main_report.jrxml

                   sub-report1.jasper

                                       sub-subreport1.jasper

Main reports are in "MainReports" directory and sub reports are in "subreports" directory. I only have one subreports directory under MainReports which contains all sub reports including sub-subreport1.jasper.

I am passing sub report path via parameter "SUBREPORT_DIR" from main to sub and to its sub-sub. It has a value of "subreports/". 

Why is JasperStudio still not able to find the sub report that is called from another subreport?

[net.sf.jasperreports.engine.JRException Error when running jar file, but run fine in IDE]

    

[net.sf.jasperreports.engine.JRException Error when running jar file, but run fine in IDE]

Your jar might be missing dependency jars. You should create a fat jar so that it contains all required dependent jars. .Can you also add sysouts to see what date values are being passed to report params? 

[Two reports, same information, diferent format]

    

[Two reports, same information, diferent format]

It depends how reports are getting their queries. You could pass same query as a parameter string from external source to your reports. Write your query inside a parameter , say paramReportQuery Then in sql editor of each jasper report, you just have this parameter name as follows:

$P!{paramReportQuery}

[How to I pickup latest date row in my report?]

How to pick up highlighted rows?

ID    NAME     AMOUNT     DATE

1       CA          1000              2022-05-01

1       CA          1000              2022-05-02

1       CA          1000              2022-05-03

2       CA          1000              2022-05-01

2       CA          1000              2022-05-02

I created a variable on ID+NAME+DATE, then created a variable with MAX(DATE) and reset it on the group but its doesn't seem to be working 

 

[conditional sum not working when more than one conditions]

Hello Friends, 

I have a veriable that sums of values based upon two conditions. If I use both conditions, the value is coming up 0. However if I only leave one condition, I get a value. What could be wrong?

($F{city}.equalsIgnoreCase ("NEW YORK") && $F{city_zip}.equals (10001) )? $F{sales_amount}:0

I have data where both conditions are true yet the variable is not summing up the values. If I just use one condition in the expression, then I am getting values. Do I need to create group on the condition fields? I am resetting the variable at report level 

[Crystal Reports to Jasper Conversion]

Hello, Does anyone know of a free automated tool for converting Crystal Reports to Jasper (jrxml)? I've done manual conversions in the past but now I am looking for an automated tool for a customer. I have searched already and I couldn't find any suitable thread to provide some guidance. Any help is highly appreciated.

[The requested resource [/jasperserver] is not available]

Ok. so I dont' know if it resolved this error but after I uninstalled Jasper server, I also deleted these two filers from c: users/user_xxx folder.

.jrsks

.jrsksp

I then reinstalled community version 7.5 and it seems to be working now. 

[The requested resource [/jasperserver] is not available]

I am getting exactly same error. The older versions used to work seamlessly after fresh install but something has changed in the latest versions which is causing this issue. My older version 7.2 worked perfectly fine but I un-installed it and installed latest 7.8 and it's not working. 

I verified tomcat is up. Apache Tomcat/8.5.57

One thing I've noticed is newer version is asking form chrome.exe location and I checked it was pointing to correct path. Older versions never asked for it. Not sure if Chrome is causing any issues. 

jasperserver.log is attached. 

[Double sided reports with different margins]

So you want "odd" pages to have one type of margins and "even" pages a different type? Of your report will always be two pages long?

Checkout following threads:

https://community.jaspersoft.com/questions/538958/setting-margin-values-dynamically

https://community.jaspersoft.com/questions/538231/adjust-page-margins-oddeven-pages

[Linux installer]

Is it possible to install Jasper studio from a linux installer file on a a windows machine? 

[How to install]

NM! I figured out what I needed to do. Although it's not possible to do same install with .zip as with installer. Both are two different things. With zip (portable), there's no way to achieve same install in my opinion. You will have to copy the zip file somewhere, extract it and then run JStudio from there. 

[When i run the report with parameter getting error on Document is Empty?]

Make sure your parameter is linked correctly from main report to your sub-dataset. If you can post jrxml we should be able to helpful. Also, are you getting an error or the report is coming up empty/blank?

[How to install]

How to install

[How to summarize all groups then display group details]

I meant you create one dummy group, or master group in report with something like "1" as value in it. Then you create one more group on ACCOUNTS field that contains A, B, C, D, and so on values. 

Dummy Group Header  (GROUP#1)

• Summary of Account A  - variables that would sum data and reset on group#1 level
• Summary of Account B
• Summary of Account C
• Summary of Account D

Dummy Group Footer (suppress)

Account A Details Header (GROUP#2) 

Account A Details...

Account A Details Footer 

Account B Details Header

Account B Details...

Account B Details Footer

 

Account C Details Header

Account C Details...

Account C Details Footer

 

Account D Details Header

Account D Details...

Account D Details Footer

[How to summarize all groups then display group details]

I would say try to create one dummy group which should be the first group in order. Then you create all four groups for you A, B, C, and D accounts. You summarize data of all four groups into dummy group header section. And summarize data of each individual groups (A, B etc.) in their respecive group header and footer sections. 

[Parameters in an in clause]

Can you use your second query in your IN clause?

select doc,nom from table where tpo in (select distinct(tpo) from tabla));

If not, do you except the values from second query to popup in parameter drop down? 

[i may not be thinking out of the box. multi value parameter in WHERE clause]

 

 

[Repository Explorer docking]

To reset the interface to the default perspective, select Window > Reset Perspective.[/code]

I wish there was another way to just dock the orphan windows as resetting perspective to default cleared all my settings. 

[Repository Explorer docking]

Jasper Studio 6.3

I am very frustrated to not able to find a way to dock the Repository Explorer back. Does anyone know where that control is located which docks all the windows back to default or at least docks Repository Explorer?