dwalton_1

Just a note that things like MONTH-1 or DAY+1 don't work either.

I recently downloaded the new version of jaspersoft studio (6.5.0) for eclipse. I used to be able to choose specific dates for a parameter when previewing a report, now if I pick a specific date it treats it as null. The only values I can get to evaluate to non-null are the relative dates like "DAY" or "MONTH". Switching to an older compatibility mode doesn't seem to work either. DATERANGE("2017-12-22") evaluates to null when I preview. DATERANGE("DAY") evaluates to the correct Date, 2017-12-22. Anyone have any thoughts? Here's the documentations on Jasper's Date Range object: http://jasperreports.sourceforge.net/sample.reference/daterange/index.html

Thanks for the response! The support team pointed me to section 8.8.1 of the admin guide and I was able to solve my problem by changing the following properties: In .../WEB-INF/applicationContext-semanticLayer.xmlskipDomainDatabaseValidation -> true In .../WEB-INF/applicationContext.xmldefaultDomainDependentsBlockAndUpdate -> falseThen I went into the domain designer, saved it after making no changes. It popped up a warning saying I was modifying objects used in ad hocs/reports, but it let me continue anyway. Then I checked the ad hocs and they all still worked fine. Went back into domain designer and don't have the error anymore.

I recently upgraded to jasper server 6.2 from 5.6. I used the export/import feature to move all my reports and ad hoc views over. However, now every time I try to edit the domain using the domain designer it complains that I've changed every column of every table and won't save any changes. It even does this if I go in the domain designer and click OK without changing anything. Was there a major change to the format of the schema XML file between versions 5.6 and 6.2? It seems like something it's doing when it saves is rearranging everything. It seems like the only way I can get past this is to delete all the ad hoc views and reports, then save the domain, and then recreate them by hand, which I really don't want to do.

Anyone else have this problem? I tried exporting the adhocs, deleting them, updating the domain, then importing the adhocs, but it overwrote my domain changes.

I'm trying to remove a column that doesn't exist anymore from the display tab in the domain designer. After I delete it and click OK, a big list comes up with ALL the tables in the domain that are used in any adhoc reports saying I can't modify them. Seems like a bug since I haven't touched any other tables at all, I'm just deleting a column from one table. I did recently upgrade from jasper server 5.6 to 6.2 using the export/import feature. Maybe that's the cause of this? Also the datasource behind this domain is an Oracle database. Has anyone else had this problem or know of a work-around I could try? I have a couple new tables I need to add to the domain, but I can't save any changes until I remove the non-existant column.

I did find this bug report from 4 years ago: http://community.jaspersoft.com/jasperreports-server/issues/5833 Maybe no work has been done since to solve this?

I'd like to show the date range my adhoc is filtering on when it gets emailed out every week. Is there a way to display the filters when a report is exported/emailed? I'm using Jasper Server Pro version 6.0.1 on AWS

I'm on an old version and would like to upgrade to the newest version on AWS. The AWS Marketplace page only says that 6.1 is available. When will Jasper Server Pro 6.2 be available on AWS? https://aws.amazon.com/marketplace/pp/B00B527JQ0

I recreated the ad hoc view from scratch and it worked this time. I did rename and delete some calculated fields and measures when I was creating the original version, so maybe that's where things got weird.

I have an ad hoc view that has several calculated measures in the columns and a single calculated field in the group area (this is a table displaying totals data only). When I try to create a report using my ad hoc view, I'm getting the following error: Error MessageReport design not valid : 1. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1 2. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1 3. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_StartDate 4. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_EndDate 5. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_NumberIfViews 6. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_NumberOfClicks_1 7. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_ClickThroughRate_1 8. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_StayedOnPageForLessThan5Seconds 9. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_BounceRate It seems like it's putting the following in front of each of my calculated measures (this is the name of the calculated field that the ad hoc view is grouping by): public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1 When I export the report and check the ad hoc xml files everything looks correct, but the report xml files have these messed up field/measure names. This looks like some kind of bug in the report creation process, is there anyway around this? Thanks for your time.