selene.platt_1

I have a Jaspersoft Report in which I want to suppress (not print) an entire row if a specific field value repeats. The data set has duplicate values in certain columns, and I can suppress printing duplicates by unchecking the 'Print Duplicates' checkbox in a particular column, but I want to suppress the entire row if one of those columns has a duplicate and therefore prints as blank. Is there any way to do this? Thanks!

Thanks, I had just assumed that two m's meant a 2-digit hour, e.g. 03:00. Interestingly, in the Excel output report, the time still looks like it's 24-hr until I click on a cell - then it appears as 12-hr. When I changed the cell formatting from Custom to Date and specified the correct format, the dates all displayed as I expected. Really odd.

I am trying to print a datestamp in an Excel Jaspersoft report with the time in 12-hour am/pm format. Under 'Dataset and Query', the database field (which is date format) has Class Type = java.sql.Date: In the table, under Text Properties, I am using the format 'MM/dd/yy hh:mm a', which is supposed to give me what I want: However, in the report, the timestamps are listed with military (24hr) time: What am I doing wrong? I should mention that I'm defining them as dates rather than strings so the user can sort them by date in the Excel file. Thanks in advance for any help - and please give specific instructions because I am not an expert at Jaspersoft Report! p.s. I am referring to this pattern guide: https://community.jaspersoft.com/wiki/date-and-time-patterns

I added the code you suggested to my SQL but am now getting these errors: 'MULTI_SELECT_VISIT' is equivalent to your 'PM_M_CAMP_ID'. I am running Jaspersoft Studio version 6.4.3.final. I searched for the error in this community forum and others are getting it after trying to implement multi-select parameters. This is how I'm defining my parameter: This is the SQL to compare visit - pe.eventlabel is the field to which I'm comparing the selected visits (multi-select field). What is 'IN' above? I'm not familiar with that syntax. What am I doing wrong? Thank you.

I am relatively new to Jaspersoft Studio and am trying to follow your directions (jgust) to change a single-select parameter to multi-select. I was able to select the java.util.ArrayList class, but cannot select Arrays.asList() for the Nested Type Name. You indicate "you can initialize...", but does that mean I must define the parameter this way? If I have the list of values via a SQL query, how do I populate the multi-select list? I think I'm missing a few steps and unfortunately need them spelled out to understand how to set it up. Thank you!

Hi, I'm new to Jaspersoft and can't answer your question, but I am wondering if you created a true pivot table or a crosstab? I need to create a real Excel pivot table and crosstab is not that.

Hi, I'm new to Jaspersoft reports and although I have checked the 'ignore pagination' box for my data table, the max # rows displayed in a tab is always 50,000, and the table continues to a 2nd tab. Is there an internal max that Jaspersoft recognizes? I want all rows to be on a single tab. Thanks!