laura.mays
-
Posts
6 -
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 laura.mays
-
I have a datetime field, i.e. May 10, 2020 10:41:41 PM. I'd like a filter in my report that pulls only those records in which the time is > 5:00 PM. How do I do that? I could build a calculated field to filter on but none of the existing functions actually extract the timestamp from a datetime field (i.e. Time and Timestamp functions don't work because the field is not a string).
-
In a Studio report we have a table that includes a date field. When displayed in Studio there is a 12:00 a.m. timestamp added to the field. The report is populated with a query. The field in the source is datatype Date. The source is sqlServer. The connection is JDBC. The field has a class type java.sql.Date (java.util.Date provides the same results). Why is the timestamp being added? When run in different timezones this report is providing different data and it shouldn't.
-
The challenge is that there is not just one person that updates the reports. We use change controls and don't save them right back to the same server we pull them off of (i.e. we have dev, qa, stage and then prod). We don't edit in prod becuase these are reports that we are feeding to our application for dashboards and other interaction. How do either pull the report into my workspace from github OR download it from prod and save it to my workspace? And remember there can be several (20 on one report) subreports.
-
I am new to my company. We have several studio reports that have been published to a JasperReports server. I need to import them to a workspace so I can update them. There is one main report with approx 20 subreports. How do I import to my workspace the entire bunch as one project without having to import the .jrxmls one by one? Also, is there a way to import the project/report using the .zip that is created when you export a report from JRS? We use github and store updated zips there. Would be good to import the most recent version that is stored in git.
-
I have created a JasperReports Ad hoc view and Report. There are three date fields that I need to use to filter by.. Ad Hoc Filter Example: File Created Date is between [start date] and [end date] OR File Closed Date is between [start date] and [end date] In the Report I created from the ad hoc I have added an input control for start_date and end_date. Question: How do I connect/inject that input into the date fields that need to be filtered?
-
If Today is 10/7/2019 how do I calculate the 1st day of the prior month (9/1/2019) in the AdHoc editor?
