dprogrammer

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.

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

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

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"

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?

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?

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 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

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

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.

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.

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.

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

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

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.

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

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 levelSummary of Account BSummary of Account CSummary of Account DDummy 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

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.

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?

Hello Teodor, I am having same issue with one of my sub-reports that has 5 columns, a width of 9600 and a height of 3400. The report works fine in JasperStudio but errors when run from JasperReports Server. My error is: "Caused by: org.xml.sax.SAXParseException; lineNumber: 153; columnNumber: 135; cvc-enumeration-valid: Value 'ElementGroupHeight' is not facet-valid with respect to enumeration '[NoStretch, RelativeToTallestObject, RelativeToBandHeight]'. It must be a value from the enumeration." I checked my jrxml and it has the latest property ElementGroupHeight. See a section of the jrxml below. Line 153 is the line starting with ... ...

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.