phiLightSoftware's channel
Loading...
29
subscribers
32,997
video views
Uploaded videos
1-10 of 28-
Excel - Table Button Bindings
phiLightSoftware
176 views
Learn how to create a Button to extract data into a Excel Table using Filters Parameters. Without the Button data would be extracted into the Table as soon as one of the f...
-
Query Builder - Creating Drill Throughs
phiLightSoftware
1,045 views
How to create Drill Through to show more details or analysis of the selected row in the parent Report. Any number of Drill Throughs can be created with addition Drill Throu...
-
Studio - Filter Lookups
phiLightSoftware
87 views
How to define custom Lookups and Value Lists in Studio. Lookups appear on Query Filters.
-
Studio - Debugging and Testing
phiLightSoftware
215 views
How to debug and Test Datamodels in Studio. How to view SQL statements generated by the Engine in Query Builder and also to view the current State Values. Query Tester is...
-
Query Builder - Emailing Reports
phiLightSoftware
287 views
Embed reports in Emails by placing an Output Expression using EmailReport or Email functions. The example shows the emailing of an Employee Contact List from both Excel an...
-
Site Setup - User Security
phiLightSoftware
92 views
How to setup User security in Site Setup so that access to various products can be controlled. User access can be defined at a group level or an individual User Account le...
-
Site Setup - Single Sign On
phiLightSoftware
4,099 views
How to setup a Single Sign On User Account in Site Setup based on the users current Windows User Account or Group. There are two types of users that can be created in Site...
-
Query Builder - Filter Attributes Part 2
phiLightSoftware
256 views
This video explains the various Filter Options available when creating a Query in Query Builder. These include how to use cell references in Excel, comparison operators , i...
-
Query Builder - Filter Attributes Part 1
phiLightSoftware
1,346 views
This video explains the various Filter Options available when creating a Query in Query Builder. These include how to use cell references in Excel, comparison operators , i...
-
Excel Basics - Using Tables Formulas Part 2
phiLightSoftware
145 views
Demonstration of Reporting using Excel Tables. Table Formulas launch the Query Builder where the Query is defined with cell references for the filter criteria. As the cell ...
Advertisement
Play all(28)