Description

The Simple Table allows you create a table wtih a dynamic number of columns and rows based off the keys in your data source.

Video recorded using: Ignition 7.9

Transcript

(open in window)

[00:00] Let's take a look at the simple table component. So far we've only used the standard table. The standard table's focused on a dynamic numbers of rows with static columns. However, the simple table allows us to easily create a grid with either the rows or the columns being dynamic. Let's begin by taking the simple table and dropping it onto our report and the simple table also has a data key. We need specify a data source for it to use so let's go to the key browser, we'll drag and drop data down to the data key. Now I'd like the simple table to show each piece of equipment as well as the total amount of downtime occurrences and the average duration of each occurrence. I want this broken down per piece of equipment. To start, we'll come up to our key browser. We'll take the equipment key, we'll drop it in the upper left-hand corner. It's important to note that this top row is a header row. It's a special type of row and you can see in the property inspector there is currently one header row. You can add more or you can set it to zero to remove the header row. The header row is special in that the symbol table will add a new column for each value in the equipment key. Just to show you what that looks like, let's take a look at the Preview mode and each piece of equipment has it's own column. You also have two blank columns here. That's because the symbol table has two blank columns, so we can go ahead and remove those. Let's go ahead and set columns down to one and then let's get rid of that last row, as well, so we'll set this to two. Next let's go ahead and take our count key. Remember for count to show up here, we need to set Show Calculations to true. We'll drag that to the second row and then we'll expand our duration key. We'll take the average and we'll drop that on the bottom. If we take a look at this in Preview, it looks about right. It would be nice if we had a header onto the side here just to say what each of these rows represented. Let's do that next. We'll come back to design and we'll select the simple table and we will come down to the header columns property. We'll set this to one. Let's put some text in here. We'll type DT Count. This one here we'll do Average Duration. We can go ahead and format these a little bit, too. Let's do red text there. We'll add a gray background, sure, why not? We'll do the same thing for our Average Duration. Let's go ahead and resize that since it's being drawn a little off the report. We'll come over here, just squeeze that down a bit. That looks better. You can see with the simple table you can very quickly add a table inside of your report.

You are editing this transcript.

Make any corrections to improve this transcript. We'll review any changes before posting them.