Home : Report Wizard - Raw Data Only When Occurs
Q14461 - INFO: Report Wizard - Raw Data Only When Occurs

The Raw Data Only When Occurs report is created using the Spread Report Wizard.  Creates a report showing values only for date/times where data occurs for any variable frequency (Hourly, Daily, 15 Minute...).  It is recommended to only use one frequency of data for best results.  Report uses the DRC and SQLFIRST/SQLRESULT formulas and will expand to show records for any date range when it is output. 

Start the Spread Report Wizard from Design>Spread Reports:

Follow the steps in the wizard and choose all your metal variables. 

Example 1: Quarterly Metals

We take metals 3/quarter (typically 3 consecutive days).  The report will list every day in the report date range where any one of the variables has a result.  Notice Feb 2nd we took an extra Arsenic but did not run any other metals. 

 

Example 2: Filter Turbidities

We run Turbidities every 4 hours in the lab.  We created Hourly variables as we can take it more frequently if we are having issues.  I want to see all the Turb results for the month. 

Run the Wizard, choose Raw Data Only When Occurs and choose your lab Turbidity variables:

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 7/20/2017 4:03 PM.
Last Modified on 7/24/2017 8:52 AM.
Last Modified by Scott Dorner.
Article has been viewed 860 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article