1 00:00:10,000 --> 00:00:15,000 Friends today, I will tell you how to create a report. 2 00:00:16,000 --> 00:00:27,000 Or how to feed your realtime data or your graph data to your Excel file. 3 00:00:28,000 --> 00:00:29,000 For that purpose. 4 00:00:29,000 --> 00:00:34,000 I just go to my diagram window over here. 5 00:00:35,000 --> 00:00:36,000 Just right click. 6 00:00:37,000 --> 00:00:45,000 You have to install report generation toolkit to do your live view or here. 7 00:00:45,000 --> 00:00:53,000 As you see, I have different tool or you can say different nodes related to report generation. 8 00:00:53,000 --> 00:00:56,000 Like over here I have my office report. 9 00:00:56,000 --> 00:00:57,000 What specific? 10 00:00:57,000 --> 00:00:59,000 Excel specific. 11 00:00:59,000 --> 00:01:02,000 So today I will tell you Excel specific. 12 00:01:03,000 --> 00:01:07,000 So for that purpose, first you have to create report. 13 00:01:07,000 --> 00:01:12,000 I just locate, create report. 14 00:01:14,000 --> 00:01:16,000 Then you have to. 15 00:01:17,000 --> 00:01:20,000 Go to first. 16 00:01:21,000 --> 00:01:24,000 Your loop because I want to. 17 00:01:27,000 --> 00:01:34,000 Data or feed data many times as many as my loop runs. 18 00:01:34,000 --> 00:01:37,000 So I just use why loop over here? 19 00:01:38,000 --> 00:01:39,000 So. 20 00:01:40,000 --> 00:01:46,000 You have to now go to your Excel specific over here. 21 00:01:47,000 --> 00:01:51,000 You have to use Excel set cell alignment. 22 00:01:52,000 --> 00:02:00,000 That is an Excel set cell alignment that is in Excel format. 23 00:02:00,000 --> 00:02:02,000 Just drag and drop this. 24 00:02:06,000 --> 00:02:07,000 Okay. 25 00:02:07,000 --> 00:02:08,000 Just connect this. 26 00:02:14,000 --> 00:02:17,000 Or here you have to set the format. 27 00:02:18,000 --> 00:02:21,000 Which type of report you want. 28 00:02:21,000 --> 00:02:23,000 So I just create a constant over here. 29 00:02:24,000 --> 00:02:25,000 Over here we have three. 30 00:02:26,000 --> 00:02:27,000 Types. 31 00:02:27,000 --> 00:02:28,000 XHTML. 32 00:02:28,000 --> 00:02:29,000 Word Excel. 33 00:02:29,000 --> 00:02:36,000 Right now I'm working with Excel, so my report type is Excel over here. 34 00:02:36,000 --> 00:02:46,000 Now I just go back to my report Generation Toolkit, or here I want to use append table to report. 35 00:02:48,000 --> 00:02:54,000 Append able to report, as you see, just drag and drop. 36 00:02:55,000 --> 00:02:56,000 Connect this. 37 00:02:59,000 --> 00:03:11,000 This will take data from other variables like you have temperature, you have pressure, you have flow, 38 00:03:11,000 --> 00:03:16,000 you have current, you have voltage, etc. It will feed it to this part. 39 00:03:17,000 --> 00:03:19,000 And over here in the. 40 00:03:20,000 --> 00:03:22,000 Excel set sail alignment. 41 00:03:22,000 --> 00:03:24,000 We have different formats. 42 00:03:24,000 --> 00:03:26,000 So over here, I just. 43 00:03:28,000 --> 00:03:31,000 Create content over here. 44 00:03:31,000 --> 00:03:33,000 Create constant over here. 45 00:03:34,000 --> 00:03:40,000 So when you go to your help, as you see horizontal alignment, vertical alignment. 46 00:03:41,000 --> 00:03:45,000 So in this case, I just put, let's say center. 47 00:03:45,000 --> 00:03:51,000 So my horizontal and vertical, both the alignments are center specific. 48 00:03:52,000 --> 00:03:56,000 So now I just go to. 49 00:03:57,000 --> 00:04:04,000 Attend, able to report or here you have different formats. 50 00:04:04,000 --> 00:04:05,000 So first. 51 00:04:06,000 --> 00:04:08,000 I just create. 52 00:04:09,000 --> 00:04:10,000 Constant. 53 00:04:12,000 --> 00:04:13,000 For this one. 54 00:04:15,000 --> 00:04:22,000 For Colon because I just want a table in which first we have serial number. 55 00:04:22,000 --> 00:04:24,000 In the second, we have temperature data. 56 00:04:24,000 --> 00:04:27,000 In the third, we have pressure data. 57 00:04:27,000 --> 00:04:29,000 In the fourth, we have floated. 58 00:04:29,000 --> 00:04:30,000 So let's say. 59 00:04:32,000 --> 00:04:32,000 Just. 60 00:04:34,000 --> 00:04:35,000 Drag this. 61 00:04:41,000 --> 00:04:45,000 So I just increase the size. 62 00:04:47,000 --> 00:04:49,000 So first one is my. 63 00:04:50,000 --> 00:04:51,000 Serial number. 64 00:04:52,000 --> 00:04:53,000 Okay. 65 00:04:54,000 --> 00:04:57,000 Second one is my temperature. 66 00:05:03,000 --> 00:05:04,000 It is my pleasure. 67 00:05:07,000 --> 00:05:09,000 And fourth is my flow. 68 00:05:10,000 --> 00:05:10,000 Let's see. 69 00:05:12,000 --> 00:05:14,000 Okay, so this is the heading. 70 00:05:15,000 --> 00:05:20,000 Now you have to go to the next part in this. 71 00:05:20,000 --> 00:05:22,000 You have to save your report. 72 00:05:23,000 --> 00:05:28,000 So to save your report, you just go to advance. 73 00:05:29,000 --> 00:05:36,000 Or here you have a report option which will use. 74 00:05:38,000 --> 00:05:39,000 Clear report. 75 00:05:40,000 --> 00:05:45,000 Which is used outside and you have to save report to file also. 76 00:05:48,000 --> 00:05:49,000 So save report. 77 00:05:50,000 --> 00:05:51,000 This one. 78 00:05:52,000 --> 00:05:54,000 You have to drag. 79 00:05:54,000 --> 00:05:57,000 So I just move it over here. 80 00:05:59,000 --> 00:06:00,000 Just connect this. 81 00:06:01,000 --> 00:06:04,000 It will save your report. 82 00:06:04,000 --> 00:06:13,000 And if you want to dispose your file, you can also do that using. 83 00:06:18,000 --> 00:06:20,000 Dispose. 84 00:06:21,000 --> 00:06:23,000 This one using this function. 85 00:06:24,000 --> 00:06:27,000 It will dispose your report also. 86 00:06:28,000 --> 00:06:29,000 So this is. 87 00:06:30,000 --> 00:06:37,000 These are the four or you can say one, two, three or five. 88 00:06:37,000 --> 00:06:41,000 These five are the main building block of every generation. 89 00:06:42,000 --> 00:06:47,000 So I just also create the labels for this. 90 00:06:48,000 --> 00:06:51,000 Visible items labels OC. 91 00:06:54,000 --> 00:06:57,000 So over here, as you see, labels are also visible. 92 00:06:57,000 --> 00:07:03,000 Now I want to feed the data to this append table. 93 00:07:03,000 --> 00:07:07,000 For that purpose, I just create data. 94 00:07:08,000 --> 00:07:13,000 So first, let's say I have random numbers. 95 00:07:14,000 --> 00:07:17,000 I just use this random number. 96 00:07:17,000 --> 00:07:18,000 You can use this also. 97 00:07:18,000 --> 00:07:22,000 It will generate 0 to 1 and it will generate according to your limits. 98 00:07:22,000 --> 00:07:24,000 So I just use this one. 99 00:07:24,000 --> 00:07:28,000 And over here I just make it clothing type. 100 00:07:28,000 --> 00:07:34,000 So upper limit for my temperature is, let's say, 60 degrees Celsius. 101 00:07:35,000 --> 00:07:41,000 And the lower limit for my temperature is, let's say ten degrees Celsius in my location. 102 00:07:42,000 --> 00:07:45,000 It is not going below ten degrees Celsius. 103 00:07:45,000 --> 00:07:47,000 Right now I'm creating a demo. 104 00:07:48,000 --> 00:07:56,000 So now you have to convert this data into stream because right now it is in DB. 105 00:07:57,000 --> 00:08:00,000 So format into string we just use. 106 00:08:02,000 --> 00:08:04,000 In the strings. 107 00:08:04,000 --> 00:08:06,000 Format into string. 108 00:08:06,000 --> 00:08:10,000 Okay, so I just drag and drop. 109 00:08:10,000 --> 00:08:11,000 Connect this. 110 00:08:14,000 --> 00:08:16,000 Because this will generate the data. 111 00:08:16,000 --> 00:08:22,000 And if you are dealing with real time data, you have to connect this. 112 00:08:23,000 --> 00:08:26,000 Or you can replace this one with your real time data. 113 00:08:26,000 --> 00:08:31,000 Like you can use data assistant and in the next video. 114 00:08:31,000 --> 00:08:33,000 I will continue with that also. 115 00:08:33,000 --> 00:08:38,000 So now this is my, let's say, temperature data. 116 00:08:39,000 --> 00:08:44,000 Then you have to also format this string. 117 00:08:44,000 --> 00:08:51,000 So you have to select how many decimals you require in this case. 118 00:08:51,000 --> 00:09:02,000 So the format is percentage got to F and if you want to check or here in the detail help, you can get 119 00:09:02,000 --> 00:09:03,000 the data also. 120 00:09:05,000 --> 00:09:07,000 Which format is used. 121 00:09:09,000 --> 00:09:11,000 So over here, just drag and. 122 00:09:13,000 --> 00:09:15,000 Like over here. 123 00:09:15,000 --> 00:09:18,000 This is the format you can use. 124 00:09:22,000 --> 00:09:24,000 That is interesting. 125 00:09:26,000 --> 00:09:26,000 Then 126 00:09:29,000 --> 00:09:29,000 just. 127 00:09:29,000 --> 00:09:32,000 I just closed this because I need. 128 00:09:33,000 --> 00:09:35,000 Three types of data. 129 00:09:36,000 --> 00:09:49,000 So I just drag and drop over here and my pressure data will go from zero to, let's say, under Pascal. 130 00:09:50,000 --> 00:09:53,000 And my low data. 131 00:09:56,000 --> 00:10:00,000 Is again, let's say 0 to 100. 132 00:10:00,000 --> 00:10:03,000 So again, you have to use formatting to string. 133 00:10:06,000 --> 00:10:08,000 Just connect this. 134 00:10:11,000 --> 00:10:15,000 And the format is again same. 135 00:10:16,000 --> 00:10:20,000 Now you have to create, build, add a function. 136 00:10:21,000 --> 00:10:25,000 Because we want to combine all these data. 137 00:10:26,000 --> 00:10:27,000 Listing. 138 00:10:28,000 --> 00:10:30,000 So I just use four. 139 00:10:30,000 --> 00:10:35,000 So first one is my serial number that will come from my iteration. 140 00:10:38,000 --> 00:10:41,000 That will come when you come from my creation. 141 00:10:41,000 --> 00:10:47,000 It is not connected directly because I need again formatting to string for this also. 142 00:10:51,000 --> 00:10:51,000 The format. 143 00:10:53,000 --> 00:10:55,000 So we're here right now. 144 00:10:55,000 --> 00:10:57,000 The data is converted into string. 145 00:10:58,000 --> 00:10:59,000 This is my serial number. 146 00:11:00,000 --> 00:11:03,000 This is my temperature data over here. 147 00:11:03,000 --> 00:11:04,000 This is my. 148 00:11:05,000 --> 00:11:06,000 Sure, Rita. 149 00:11:06,000 --> 00:11:08,000 And this is my Florida. 150 00:11:08,000 --> 00:11:10,000 Now, I want to just. 151 00:11:11,000 --> 00:11:13,000 Insert into an array. 152 00:11:13,000 --> 00:11:16,000 This data I want to insert into an array. 153 00:11:16,000 --> 00:11:18,000 For that purpose, I just. 154 00:11:21,000 --> 00:11:25,000 Go to array insert into an array. 155 00:11:26,000 --> 00:11:27,000 Just connect this. 156 00:11:29,000 --> 00:11:30,000 Okay. 157 00:11:30,000 --> 00:11:32,000 And now you have to. 158 00:11:33,000 --> 00:11:35,000 Connect to the edge of. 159 00:11:39,000 --> 00:11:43,000 Your value replace with shift registers. 160 00:11:46,000 --> 00:11:46,000 Now. 161 00:11:47,000 --> 00:11:50,000 The data will go from. 162 00:11:52,000 --> 00:11:59,000 One place to another place means when first time loop runs, it will get the data again. 163 00:11:59,000 --> 00:12:04,000 When a second time loop runs, it will store the data over here and third time it will. 164 00:12:05,000 --> 00:12:08,000 And then it will store data one by one. 165 00:12:08,000 --> 00:12:14,000 So in the case of separators over here, we have the initial data. 166 00:12:14,000 --> 00:12:16,000 So I just create constant. 167 00:12:16,000 --> 00:12:18,000 And right now I have two data. 168 00:12:19,000 --> 00:12:24,000 So you trace this and this data that. 169 00:12:26,000 --> 00:12:28,000 Is generated by inserting into string. 170 00:12:28,000 --> 00:12:31,000 It will go to the append file. 171 00:12:31,000 --> 00:12:34,000 So over here, this is a row header. 172 00:12:34,000 --> 00:12:42,000 In this case I need not require any header and I just connect this data over here. 173 00:12:42,000 --> 00:12:44,000 Control you. 174 00:12:45,000 --> 00:12:46,000 Minimize it. 175 00:12:46,000 --> 00:12:54,000 So right now, the program is ready and I just put some delay inside this. 176 00:12:55,000 --> 00:12:56,000 Let's see. 177 00:12:57,000 --> 00:13:01,000 Create constant 500 milliseconds after. 178 00:13:02,000 --> 00:13:07,000 500 milliseconds data will feed it to our system. 179 00:13:07,000 --> 00:13:12,000 So right now I also create file. 180 00:13:13,000 --> 00:13:18,000 But also so over here, create a control over here. 181 00:13:18,000 --> 00:13:21,000 It will give me the file path. 182 00:13:22,000 --> 00:13:28,000 And right now Broken Arrow is there because my loop is not connected. 183 00:13:29,000 --> 00:13:32,000 Gusto button when I have to stop this. 184 00:13:33,000 --> 00:13:38,000 So it is now the program is ready. 185 00:13:38,000 --> 00:13:41,000 So I just check it is working or not. 186 00:13:42,000 --> 00:13:43,000 Or. 187 00:13:45,000 --> 00:13:46,000 So over here. 188 00:13:47,000 --> 00:13:51,000 And to drag this over here, you have to. 189 00:13:54,000 --> 00:13:57,000 Just read your file. 190 00:13:57,000 --> 00:13:59,000 Or just feed your Excel file. 191 00:14:00,000 --> 00:14:01,000 So I just. 192 00:14:03,000 --> 00:14:05,000 Create an Excel file over here. 193 00:14:05,000 --> 00:14:07,000 You have to just give the path. 194 00:14:08,000 --> 00:14:10,000 So over here is my data. 195 00:14:12,000 --> 00:14:18,000 And I just need to set the pot over here. 196 00:14:18,000 --> 00:14:21,000 So just open it. 197 00:14:22,000 --> 00:14:25,000 Desktop and the data Excel file is there. 198 00:14:26,000 --> 00:14:27,000 Click okay. 199 00:14:27,000 --> 00:14:30,000 So when I hit don't run button. 200 00:14:31,000 --> 00:14:35,000 Data is filtered through my Excel file and it will. 201 00:14:37,000 --> 00:14:39,000 Automatically open my Excel sheet. 202 00:14:39,000 --> 00:14:45,000 As you see, I just close this as you see serial number temperature pressure and it is horizontally 203 00:14:45,000 --> 00:14:48,000 centered and vertically centered. 204 00:14:48,000 --> 00:14:51,000 So it will generate the data. 205 00:14:51,000 --> 00:14:53,000 So as you see. 206 00:14:55,000 --> 00:15:03,000 If you see this is automatically generated in the case of your real time data if you want to. 207 00:15:03,000 --> 00:15:05,000 Slate or. 208 00:15:06,000 --> 00:15:14,000 If you want to change anything inside it, you can do it in the front, not front panel in the block 209 00:15:14,000 --> 00:15:14,000 diagram. 210 00:15:15,000 --> 00:15:18,000 So this is how my program works. 211 00:15:19,000 --> 00:15:22,000 So let's say I want to stop the program. 212 00:15:25,000 --> 00:15:26,000 When I stopped the program. 213 00:15:27,000 --> 00:15:31,000 It will also dispose my Excel sheet over here. 214 00:15:32,000 --> 00:15:36,000 Let's check data stored in the file. 215 00:15:41,000 --> 00:15:44,000 This one when I again hit on run button. 216 00:15:44,000 --> 00:15:46,000 It will disclose this data. 217 00:15:46,000 --> 00:15:51,000 No data is fitted to my Excel files right now. 218 00:15:51,000 --> 00:15:52,000 93. 219 00:15:53,000 --> 00:15:56,000 Total 93 times my loop runs. 220 00:15:56,000 --> 00:15:57,000 Let's check again. 221 00:15:58,000 --> 00:16:00,000 When I hit on a run button. 222 00:16:03,000 --> 00:16:05,000 And I again you don't run button. 223 00:16:08,000 --> 00:16:09,000 As you see. 224 00:16:11,000 --> 00:16:13,000 I just closed this. 225 00:16:19,000 --> 00:16:20,000 Let's close this. 226 00:16:23,000 --> 00:16:26,000 So now I want to again hit on Ron button. 227 00:16:26,000 --> 00:16:30,000 Total 93 data is fitted to my Excel sheet. 228 00:16:30,000 --> 00:16:31,000 Let's check. 229 00:16:36,000 --> 00:16:40,000 So right now I just want to stop over here. 230 00:16:42,000 --> 00:16:47,000 And let's check how much data is there inside the Excel sheet. 231 00:16:50,000 --> 00:16:58,000 Every time you need another report, you have to just change the file. 232 00:16:58,000 --> 00:17:05,000 But right now, only 24 times my luguentz not 24 total 22. 233 00:17:05,000 --> 00:17:12,000 Because over here is my iteration from 0 to 22 means total 23 times my loop runs. 234 00:17:12,000 --> 00:17:20,000 So this is all about how you can generate a report using leg view and using report generation tool. 235 00:17:22,000 --> 00:17:22,000 Thank you.