Design, Publish, and Share RDL Reports in EQuIS – Nov 2017

November 21, 2017




Design, Publish, and Share RDL Reports in EQuIS – Nov 2017

TABLE of CONTENTS
3:36 RDL Workflow (6:55)
10:32 Select Source: EQuIS Professional Reports (2:05)
12:37 Create New RDL Report (1:48)
14:25 Save RDL Report: Open RDL Report Builder (4:12)
18:37 Open New RDL Report in EQuIS Professional (:39)
19:15 Run New RDL Report in EQuIS Professional (:35)
19:48 Add Content: Microsoft SQL Server Report Builder (8:41)
28:30 Add Secondary Dataset (8:56)
40:02 Questions and Answers (9 Questions)
40:02 Q1? Does this require a specific EQuIS license add-on to function?
40:19 Q2? When the report is saved to Pro, can it be in a folder?
41:50 Q3? If you can’t connect RDL to database, only to the report, what happens if your EQuIS report uses dynamic dates?
43:50 Q4? Could data from both tables be included in one chart?
44:14 Q5? What underlying EQuIS report types are compatible with RDL – just class reports?
44:48 Q6? Why didn’t you set inputs for the second report?
45:50 Q7? Can RDL be used to create a view that combines multiple tables of data into one table?
46:28 Q8? Are you able to show multiple tables in the RDL?
47:03 Q9? Is there a direct ‘Print’ option in the RDL widget?

DOWNLOAD
Design, Publish, and Share RDL Reports in EQuIS – Nov 2017 [48:46][134mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Explore Permissions in EQuIS Enterprise – Nov 2017

November 14, 2017




Building Advanced Action Levels – Part 5 – Mixed Action Levels – Nov 2017

TABLE of CONTENTS
1:07 Overview: Enterprise Permissions (3:24)
4:32 Permissions: Roles (:33)
5:04 Permissions: Object (1:35)
6:38 Permissions: Folder (1:31)
8:10 Scenario A: Project Manager unable to load EDDs to a facility (4:30)
12:38 Scenario B: User certificate (.usr file) is not generated when a user or Administrator changes the password (2:44)
15:22 Scenario C: Unable to view and download a certain file in Explorer Widget (6:33)
21:57 Questions and Answers
21:57 Q1? If I impersonate a user to test permissions – does that count as a log-in for that impersonated user?
23:26 Q2? Why do some modules, e.g. DQM, require the user have admin permission?
24:57 Q3? Changing permissions on roles vs. reassigning user to different role?

DOWNLOAD
Explore Permissions in EQuIS Enterprise – Nov 2017 [29:00][58mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Building Advanced Action Levels – Part 5 – Mixed Action Levels – Nov 2017

November 7, 2017




Building Advanced Action Levels – Part 5 – Mixed Action Levels – Nov 2017

TABLE of CONTENTS
1:03 Copper Canadian Water Quality Guidelines (3:22)
4:25 Advanced Action Levels: Formulas (3:53)
8:17 DT_ACTION_LEVEL_LOOKUP (7:10)
15:27 Example EDD: Advanced Action Level: SINGLE_MIXED (4:42)
20:12 Mixed Action Levels: EQuIS Professional (8:20)
28:33 Advanced Action Level: MULTIPLE_MIXED (6:19)
34:53 Q1? How are hardness concentrations found?
35:23 Q2? Why does it matter putting the calculation as the last?
36:54 Q3? Way to specify the number of significant digits being returned for the calculated AAL?
38:23 Q4? Two hardness results for my sample, how can I specify which hardness result should be used in calculation?

DOWNLOAD
Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017 [27:51][51mb]
Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017 [27:05][49mb]
Building Advanced Action Levels – Part 3 – Action Level Lookups – Oct 2017 [37:08][86mb]
Building Advanced Action Levels – Part 4 – Action Level Formulas – Oct 2017 [33:34][87mb]
Building Advanced Action Levels – Part 5 – Mixed Action Levels – Nov 2017 [41:11][79mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Building Advanced Action Levels – Part 4 – Action Level Formulas – Oct 2017

October 31, 2017




Building Advanced Action Levels – Part 4 – Action Level Formulas – Oct 2017

TABLE of CONTENTS
:47 EPA National Recommended Water Criteria for Priority Toxic Pollutants (1:23)
2:12 Single_Formula: Advanced Action Levels (5:52)
7:57 Apply Advanced Action Levels to dt_action_level_lookup (5:23)
13:20 Advanced Action Levels EDD (4:49)
18:09 Advanced Action Levels EQuIS Professional (2:33)
20:42 Bonus Tool: Action Level Lookup Calc Tester (5:00)
25:43 Questions and Answers (4 Questions)
25:43 Q1? Where are the equations for calc_method stored?
27:01 Q2? Which hardness Ph values will EQuIS use in Action Levels calculations?
28:18 Q3? Advanced Action Levels features only available to 6.6 version?
29:57 Q4? Hardness, how do we know which one is the first one?

DOWNLOAD
Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017 [27:51][51mb]
Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017 [27:05][49mb]
Building Advanced Action Levels – Part 3 – Action Level Lookups – Oct 2017 [37:08][86mb]
Building Advanced Action Levels – Part 4 – Action Level Formulas – Oct 2017 [33:34][87mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Building Advanced Action Levels – Part 3 – Action Level Lookups – Oct 2017

October 25, 2017




Building Advanced Action Levels – Part 3 – Action Level Lookups – Oct 2017

TABLE of CONTENTS
1:27 Definition: Sample Specific Lookup Methods (3:24)
4:51 Definition: Advanced Action Levels Configuration (3:44)
8:36 Single Lookup (7:31)
16:07 Multiple (AND)_Lookup (8:54)
25:00 Multiple(OR)_Lookup (6:46)
31:47 Q1? Can you leave the default group 0 blank?
34:23 Q2? If lab results is in different units from the action level, does the unit from the result get converted if there is a conversion defined in the unit table?
34:51 Q3? What would happen if the sample has two or more hardness or pH values?

DOWNLOAD
Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017 [27:51][51mb]
Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017 [27:05][49mb]
Building Advanced Action Levels – Part 3 – Action Level Lookups – Oct 2017 [37:08][86mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017

October 17, 2017




Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017

TABLE of CONTENTS
:38 Definition: Toxic Equivalency (TEQ) Sum (:16)
:54 Definition: Method Analyte Group (MAG) Sum (1:13)
2:10 Setup: TEQ SUM MAG Group in EQuIS Professional (2:10)
4:16 Setup: TEQ SUM Action Level using an EDD (3:00)
7:17 Run TEQ SUM Action Level Exceedance II with Parameters Report (1:28)
8:44 Setup: MAG SUM Advanced Action Level in EQuIS Pro (9:45)
18:28 Q1? Is ND_X the default code for NDs?

DOWNLOAD
Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017 [27:51][51mb]
Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017 [27:05][49mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017

October 10, 2017




Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017

TABLE of CONTENTS
1:24 Definition: Action Levels (1:52)
3:16 Types of Action Levels (1:21)
4:38 Action Levels Tables (2:41)
6:18 Configuration: Advanced Action Levels (1:05)
7:19 Overview: Advanced Action Levels EDD (11:44)
19:04 Q1? Explain what the “comparison_group” in dt_action_level_lookup does?
20:34 Q2? Can Advanced Action Levels look at weekly vs monthly action levels?

DOWNLOAD
Building Advanced Action Levels – Part 1 – Introduction and Location Based Action Levels – Oct 2017 [27:51][51mb]
Building Advanced Action Levels – Part 2 – MAG Sum and TEQ Sum Action Levels – Oct 2017 [27:05][49mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Configuring EDGE Series – Part 5 – Preparing EDGE for Field Crews – Sept 2017

October 4, 2017




Configuring EDGE Series – Part 5 – Preparing EDGE for Field Crews – Sep 2017

TABLE of CONTENTS
2:54 SPM Workflow: Review Planned Tasks (1:05)
3:50 SPM Workflow: Create EDGE Field EDD (3:31)
7:22 EDGE Only Workflow: Publish EDGE Field EDD (5:05)
12:27 Run EDGE Field EDD (4:02)
16:29 Retrieving Reference Values (3:06)
19:35 Configure Field Device (6:10)
27:09 Step by Step Instructions

DOWNLOAD
Configuring EDGE Series, Part 1 – Application Options and Working Folder – Sep 2017 [18:53][46mb]
Configuring EDGE Series, Part 2 – Configuring EDGE Forms – Sep 2017 [37:09][63mb]
Configuring EDGE Series, Part 3 – Groups and Range Checks – Sep 2017 [41:16][93mb]
Configuring EDGE Series, Part 4 – EDGE Configuration Tool – Sep 2017 [30:30][79mb]
Configuring EDGE Series, Part 5 – Preparing EDGE for Field Crews – Sep 2017 [28:18][70mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Configuring EDGE Series – Part 4 – EDGE Configuration Tool – Sept 2017

September 27, 2017




Configuring EDGE Series – Part 4 – EDGE Configuration Tool – Sep 2017

TABLE of CONTENTS
:46 Overview: EDGE Configuration Tool (4:43)
5:29 Create Enumerations, Add Enumeration Values (4:07)
9:36 Format Sections (3:53)
13:30 Lookups (7:55)
21:28 Tabs (3:33)
25:04 Captions and Settings Migration (4:37)
30:00 Step by Step Instructions

DOWNLOAD
Configuring EDGE Series, Part 1 – Application Options and Working Folder – Sep 2017 [18:53][46mb]
Configuring EDGE Series, Part 2 – Configuring EDGE Forms – Sep 2017 [37:09][63mb]
Configuring EDGE Series, Part 3 – Groups and Range Checks – Sep 2017 [41:16][93mb]
Configuring EDGE Series, Part 4 – EDGE Configuration Tool – Sep 2017 [30:30][79mb]
Configuring EDGE Series, Part 5 – Preparing EDGE for Field Crews – Sep 2017 [28:18][70mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Configuring EDGE Series – Part 3 – Groups and Range Checks – Sept 2017

September 20, 2017




Configuring EDGE Series – Part 3 – Groups and Range Checks – Sep 2017

TABLE of CONTENTS
1:16 Why Groups: Field Results / Custom Activities (1:53)
3:11 Why Range Checks: Configuration Tools / Out of Range Limits / Stabilization Limits (5:50)
9:01 EDGE Configuration Format: Simple Field Action Levels / Advanced Field Action Levels / Advanced Field Alerts & Action Levels Report / Enumeration (11:57)
20:58 Groups: field_activities (3:14)
24:13 Groups: field_results (1:54)
26:02 Groups: field_result_Action_Levels (3:44)
29:47 EDGE Setup Advanced Field Alerts and Action Levels (9:10)
39:50 Q1? Y and N values, will NA be available in future releases?

DOWNLOAD
Configuring EDGE Series, Part 1 – Application Options and Working Folder – Sep 2017 [18:53][46mb]
Configuring EDGE Series, Part 2 – Configuring EDGE Forms – Sep 2017 [37:09][63mb]
Configuring EDGE Series, Part 3 – Groups and Range Checks – Sep 2017 [41:16][93mb]
Configuring EDGE Series, Part 4 – EDGE Configuration Tool – Sep 2017 [30:30][79mb]
Configuring EDGE Series, Part 5 – Preparing EDGE for Field Crews – Sep 2017 [28:18][70mb]


Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Next Page »


EarthSoft Currents Week 47 2017 Video Newsletter

Design, Publish, and Share RDL Reports in EQuIS - Nov 2017