In this video we will discuss the basics of connecting your Cabinet Vision database to FlySpeed, how to build a (very) simple query with FlySpeed, and how to bring that query into Cabinet Vision to build a (very) simple report.
I've noticed my audio is less-than-fantastic, I'm planning to work on improving what I have or getting something a little higher quality for future videos. Thanks for bearing with me :)
- 00:00 Start
- 00:50 FlySpeed Download Link
- 02:00 Connecting Your CV Database
- 07:00 Building Your Query
- 08:25 One to Many Relationships
- 11:00 Automatic Joining (FROM)
- 12:05 Specific Selections (SELECT)
- 14:30 Manually Adding and Joining the Parts Table
- 18:20 Counting Parts.Part ID
- 24:30 Bringing Your Query into CV
- 27:30 Creating/Designing the Report
- 30:05 Tips on Resizing Columns
- 32:10 Removing Unnecessary Trailing Zeroes (Number Format Method)
- 33:10 Removing Unnecessary Trailing Zeroes (ToString Method)
- 35:05 Convert Values to Integers
- 37:08 Grouping, Headers, Group Headers
- 39:10 Create A Group Header
- 43:40 Grouping by Room, then Cabinet (End of Planned Content)
- 46:13 Using Frame to add Lines (Say hi to my cat)
- 47:18 Page Breaks
- 49:30 Multiple Group Headers
Add new comment