-
The Reset Admin Password technical trick provides the queries necessary to reset the administrator's password via the database. Passwords are forgotten, overwritten and misplaced often; using this technical trick, the support team will always have a back-up plan to gaining back access to the system. -
The Concatenate Multi-Value Lookup into One Field for Display Purposes technical trick provides an overview of how to group or concatenate the various levels and values of a Multi-Value lookup into one field in both Oracle and SQL Server environments. This allows the lookup values to be more easily displayed in a portlet. The function concatenates the values together using a choice of delimiter, which then allows the multi-value lookup to be viewed as one portlet column, in the same manner as any other object attribute. -
The process is built to clear the random timesheet locks that happens occasionally. There are three Processes and one lookup component and one job definition in the package.- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
- The Lookup PRLock Check (Timesheet) (Id: REGO_PRLOCK_CHECK) should be used to update the GEL parameters for the above process.
- PRLock (Timesheets) Record Removal All (ID: rego_prlk_rc_rmv_all) This deletes ALL prtimesheet locks.
- Rego Remove Timesheet Locks (ID: rego_rmv_ts_locks). This process is run as a job “PrLock Clear for Timesheet Locks” which performs the same functionality as the above two processes. The process and job definition are separate XOG files.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
-
The Unlock Projects workflow process can be run through the "Execute a Process" job. The workflow will execute a query that will automatically unlock projects that have been exported / checked out for over 2 days. This prevents any projects from remaining in the “locked” state for a long period of time, preventing time from posting to these projects. -
The Grant RM Timesheet Edit Rights workflow process can be run through the "Execute a Process" job. The workflow will execute a query that gives a Resource Manager Timesheet Edit rights for their resources. Timesheet Edit rights are not inherent for Resource Managers when they are named as an individual’s resource manager. -
Course Description: Struggling to figure out how to best organize your blueprints? This class will walk through best practice blueprint design, including how many to have, how to use channels, using custom subobjects within the blueprint, and swapping blueprints at various project stages to mimic project phases or ideas. We’ll highlight some of the creative ways we’ve seen blueprints used in client implementations. -
Course Description: Do you already have a basic understanding of Jaspersoft Studio development? This session will include advanced topics like duplicating and modifying an OOTB report, multiple datasets, subreports, charting, widgets integration, and crosstabs. The detailed agenda is as follows: Jaspersoft Advanced – Out-of-the-Box Customization (2 hours) • Discover how to use OOTB reports, OOTB domains, resource bundles, and security access grant schemas. Jaspersoft Advanced – Chart Development (2 hours) • Explore multiple advanced charting techniques and types using built-in charting components, including properties (colors, plot options, sizing, gauges, etc.), dual pie chart, time series, and heat map. Jaspersoft Advanced – Scriptlets (2 hours) • Understand the basics of Jaspersoft Studio scriptlet development, utilizing Java libraries in custom Java classes to perform complex tasks in a simple manner. Jaspersoft Advanced – Roundtable (1 hour) • Understand crystal capabilities missing in Jaspersoft Studio, including sharing examples, report bursting needs, automation needs, and working with internal BI groups.

