Kevin10

Summary

This article provides a comprehensive overview of the Kevin10 video transcript, detailing the intricacies of using the Master data module in the software. The process involves creating reports and handling data tables using SQL tools and report generators. Designed for users familiar with PowerBuilder, this transcript highlights some of the confusions and solutions pertinent to using Kevin10, demonstrating how features are managed differently such as selecting items, creating datasets, and configuring report outputs.

Highlights

• Learn to navigate the Master data module with ease. 📚
• Discover how to create and manage item reports efficiently. 📝
• Understand SQL tools better for handling datasets seamlessly. 🛠️
• Gain insight into arranging visual reports; perfect for personalized layouts! 🖌️
• Master how different reports and tables can be linked dynamically. 🔗

Key Takeaways

• Kevin10 makes handling master data modules easy! 🎉
• The process of creating datasets is straightforward once you get the hang of the SQL tool. 💾
• Users familiar with PowerBuilder might find some elements confusing but manageable. 🤔
• Creating item reports become simpler with Kevin10's table management. 📊
• Even the visual arrangement in reports can be controlled, adding more flexibility. 🖼️

Overview

Kevin10 by TimeLine ERP offers a fresh look at handling master data modules, something every data aficionado might find exciting yet challenging. While many users, especially those coming from PowerBuilder, might face a learning curve, Kevin10 provides intuitive tools to manage and maneuver through datasets efficiently.

The video transcript dives deeply into creating reports using the powerful SQL tool and report generator. It walks users through setting up data tables and managing them to create comprehensive item reports. While some steps may seem intricate at first, users are reassured by the endless customization possibilities — be it setting vertical alignments or adjusting containers to perfect data representation.

Overall, Kevin10 proves to be a robust tool, bridging gaps for users transitioning from other software. Its careful attention to dataset arrangement and report generation ensures that users not only understand data better but also present it in the most coherent way possible.

Chapters

• 00:00 - 01:00: Introduction to Mod Items The chapter 'Introduction to Mod Items' explains the concept of mod items, emphasizing their utilization. It addresses confusion particularly faced by Power Builder users regarding context sensitivity. The chapter clarifies that there's no need for users to select what a mod item is, as it functions as a master data within the system 'Dore AR'.
• 01:00 - 07:00: Form Generator and Dataset Designer This chapter covers the process of utilizing a form generator and dataset designer. It demonstrates using item master to import and save data, select print options, and preview the document. This includes some music playing in the background during the demonstration.
• 07:00 - 17:00: Creating and Configuring Data Tables The chapter titled 'Creating and Configuring Data Tables' provides a step-by-step guide on how to create and configure data tables using a form generator. It highlights the process of populating columns with specific items, including using the mod item from the item master module. The chapter also instructs how to navigate the interface by clicking on buttons or points to look for specific items.
• 17:00 - 23:00: Creating a Report in Form Generator In this chapter titled 'Creating a Report in Form Generator,' the discussion revolves around using the interface to create a report. The user is guided to find a specific item, denoted as 'cck,' and to customize it by giving it a name, such as 'mastera item Master.' This indicates setting up a primary or master item. The user then takes an action on this item, likely selecting it from a list where it's marked with an 'M.' The brief interaction suggests a tutorial step in navigating and customizing form elements within a software application.
• 23:00 - 31:00: Adding Titles and Footer Lines The chapter "Adding Titles and Footer Lines" likely discusses the process and methods for including titles and footer lines in a document or project. Although the associated transcript "this is item" does not provide extensive details or context, it suggests that there might be a segment or item focused on introducing or explaining these elements within the chapter. The reader can expect guidance on formatting, positioning, or the importance of titles and footer lines in documentation.
• 31:00 - 43:00: Formatting and Styling Reports The chapter titled 'Formatting and Styling Reports' explains how to enhance the visual appeal and readability of reports by using various formatting and styling techniques. It touches upon aspects such as setting vertical alignment and using specific tools or options to adjust the appearance of certain sections of the report, although the full detail is obscured by placeholders like 'click here or here.' The summary indicates that the chapter is likely about utilizing formatting tools to improve reports but lacks specificity due to incomplete information.

Kevin10 Transcription

• 00:00 - 00:30 choose from here mod what item here and now you can use it and the very confusing part for power Builder users is Contex sensitive or not no you don't need to select what is mod it mod item is our Master data Dore AR it's this modu item master
• 00:30 - 01:00 so my LL import save and now I can go to item Master select print and that's my weot my have weot print preview [Music]
• 01:00 - 01:30 can we repeat this yep of course inside the form generator we need to fill this column with Mod item that's a item master modu so you can click on these buttons this points and you can look for item and
• 01:30 - 02:00 find here cck and you can give it a name yes mastera item Master okay now I see the first on the the M for can we yes select one
• 02:00 - 02:30 this is item
• 02:30 - 03:00 master I don't know description what you see click here or here I don't a blue or and you can also set the vertical alignment
• 03:00 - 03:30 I don't I don't know mode item means item master or what in this mod how do you know it in power you have to see the menu after up content you yeah just give me a way to to find it you can get to it will be added in
• 03:30 - 04:00 formul table there's a menu editor T and there you can click your menu and there you can see that's mod item behind this entry yeah maybe we will get white click a name inside this context menu like in power build timeline where I can see oh it's double
• 04:00 - 04:30 it's not necessary but now you know how he knows how to find it because it's a little bit confusing yeah of course the names are different business part of I think mod info art mod web CRM those names aren't intuitive in
• 04:30 - 05:00 yeah okay next one now what we want to create is um item Master report so I want a single page with the data from one of my items
• 05:00 - 05:30 I've created a new item called LL training or you can choose an existing item and I added some parts to the parts list and also some is it right U plan routing routing plan okay I added some of these for so I just want something like this here
• 05:30 - 06:00 like a stum blood we will check how it looks so I can see some Header information like my description for the item and I can also see my putting fan and my parts list and even if I select a photo I think even the photo is shown so
• 06:00 - 06:30 yeah there it is so we want something like this it's the same way we will we need to start with a data set so first of all I will close everything and start in the beginning I go to the main menu to tools
• 06:30 - 07:00 SQL tools data set designer TDS and open it I don't know why but it opens me the last data set I've used we don't want that we want a new one so how that can be achieved [Laughter]
• 07:00 - 07:30 we can use it that's not no no we will do it by ourselves okay we start with the empty data set and start creating some tables so um oh I will do this in English and maybe you can try to do this so I'm just giving you these three
• 07:30 - 08:00 containers and maybe you can select you can write the S select behind it as a small practice one data you have three right yeah you have three different data sets no that's one data set with three different data tables and each data and each data table but an only SQL select yeah so we got three SQL selects
• 08:00 - 08:30 but that's a big Advantage which isn't possible in power Builder power Builder we need to do this with nested reports to have multiple and here we can do it in one data set so this one should go to Art this one should go to STL C and this one should go to Apple Apple you don't need to fill those but just
• 08:30 - 09:00 let's try do uh just select the first one the first active which in which of this ones you want to how them
• 09:00 - 09:30 together but we will also need here and you need an argument so in the upper right corner you can set an argument set to up number and that's a string and you can use it exactly like a retrieval argument and with the help of the art number you can find right AR
• 09:30 - 10:00 right by yourself I do to
• 10:00 - 10:30 B
• 10:30 - 11:00 for
• 11:00 - 11:30 for
• 11:30 - 12:00 for for
• 12:00 - 12:30 [Music]
• 12:30 - 13:00 change
• 13:00 - 13:30 okay
• 13:30 - 14:00 I start with my data set first container the item because I have written it here the data table for update which I don't need it suggested me already the right table so I want just everything out of out and I can reduce this to out
• 14:00 - 14:30 part number like this one exactly like ret weal argument so double point in front of it you yes it was defined in here in the data that's an argument and if I didn't if I Define it down there you can't Define it here yeah I could I could also
• 14:30 - 15:00 oh I think this was buggy let me check oh now it works in 123 it doesn't work so yeah okay okay yeah you can set it here okay and now this isn't updated and it's still there I can't Ed it
• 15:00 - 15:30 okay we will go on with the second data table parts list so we got sdl P but for the white link we need our table Apple you want everything from and we need to
• 15:30 - 16:00 set Apple do number the same like number and we got a status that must be one positive for putting plan parts list that's why why I need Apple first number the join set
• 16:00 - 16:30 automatically equals oh I think the join isn't set correctly is it it's just empty so check your join
• 16:30 - 17:00 okay we will do the same was the last data table was theing one one
• 17:00 - 17:30 now we do the rooting plan I select everything from Apple Aro I take some names from the database makes it a bit easier and we also need app the same expression where Apple
• 17:30 - 18:00 number and check your drawing if this set correctly that's okay lost lost yeah where in space parts
• 18:00 - 18:30 list we got three data tables right yeah okay I believe in do you have the first one item that it's just table Yeah wear Clause where number
• 18:30 - 19:00 yeah okay number okay second second one sdl po STL Po and out also with a
• 19:00 - 19:30 so I won't join there yeah need on I'm not getting number in Target F yeah click that please Target Field
• 19:30 - 20:00 up Target fi S field up
• 20:00 - 20:30 what no is an error or something else in Target table I'm not getting here uh yeah you don't have anything in here and maybe delete this joint right click delete and create a new one
• 20:30 - 21:00 and you should have I took a for table there the a for table then you in the wrong data table then we need this one here roting P there you got up
• 21:00 - 21:30 to plan
• 21:30 - 22:00 okay now third third data set thir table Target table yeah I I think I'm done with that perect and where expression what
• 22:00 - 22:30 finished okay so if we've done
• 22:30 - 23:00 everything right we can check our preview save of course and now we can insert here a value for our argument in my example I can use my l training you can use the Microsoft mouse or something
• 23:00 - 23:30 else any item you got in your database you click on retrieve and now you can see the first table the first data table that gives us the item Master then we can switch to the parts list so I can see the core positions of my parts list and you can check the rooting plan and it all looks good so we got three different SQL selects different results all regarding
• 23:30 - 24:00 this argument so it should look like can show me the in the ret inside theet table the 40
• 24:00 - 24:30 It's s one
• 24:30 - 25:00 that's a voting plan
• 25:00 - 25:30 second we
• 25:30 - 26:00 and you switch to another press
• 26:00 - 26:30 it doesn't do anything does do anything [Music]
• 26:30 - 27:00 right
• 27:00 - 27:30 bre down break down
• 27:30 - 28:00 but you fix it you okay
• 28:00 - 28:30 yeah okay okay can we slowly go on I I think get the options here Escape Escape go and from the other one also
• 28:30 - 29:00 check here you did not you did not save it click save I'll have to yes
• 29:00 - 29:30 item okay and now now you have okay go on okay we will change the module to the form generator again we jump into the TFG nice not retriving
• 29:30 - 30:00 data did you click on rece r r no it's okay okay we will create a new report TFG we select our DS item or D item Master whatever you call it and we are back finally
• 30:00 - 30:30 okay first of all I will save L at Master okay so we got different options we can work
• 30:30 - 31:00 with listen La as a free form so we only got one item so we can work with drag and drop like I've shown before we can drag and drop something from the left to the right if we want to see the data in it we have to set an argument so I will close list and label and it creates a new line with my item Master but now I can also gives them the
• 31:00 - 31:30 argument so if you got any item enter the op M here and I will reopen with a blue arrow and now I can directly see my previe you put it without braet arum yeah without quote or because it's
• 31:30 - 32:00 already a string can we do that once yep save your report close it and now you should be in the form generator again select your vote with the item Master list with the item master and now you can fill in the argument which is given to the report to the
• 32:00 - 32:30 value will be don't know choose any item you got in your database just if you got the demo database you can take item 0.210 70 or 1,000 a Microsoft mouse something depends on your database I've created a new item called l
• 32:30 - 33:00 no it's the retrieval argument isn't save and lab add some fields and you
• 33:00 - 33:30 [Music] yes that's why we need thisable argument so I can show again I select here the item and we can drag and drop the item number up number we can drops the PS one fre can drop some PS two fre
• 33:30 - 34:00 can drops a text to it directly have it in what did you
• 34:00 - 34:30 add I just drag and drw some columns on the right to the left from I okay we will add it now okay so this is probably my master data so only got one R so that's not a problem but we can't do this with a parts list or the rooting time because we got multiple
• 34:30 - 35:00 WS so to show this multiple WS we need the report container again so we select the report container stretch it here exis we select the table again and now we can choose whether we want the parts list first or the rooting
• 35:00 - 35:30 plan first doesn't matter so I would choose the parts list first no how how you went there I inserted a weot container okay yes table you canect your part l and then part list yeah and now we can
• 35:30 - 36:00 start with I think we got a PO in there we got an number in there we got Che that some parts list Post Number item number we can also take the quantity quantity
• 36:00 - 36:30 unit how many of them and maybe maybe the L num never mind just select some column but watch out they all need to be from the parts list okay so if we got this we can select preview
• 36:30 - 37:00 and yeah we got our first container pretty easy okay so we also want the rooting plan so um there are different options if you're
• 37:00 - 37:30 working with Time menu 12.4 you can create multiple report containers but if you work with t new 12.3 it's not possible to create multiple containers where you can only have one container so we all are working with yeah we just we could create another container but I want my rooting plan directly under my parts list so I select
• 37:30 - 38:00 the weot container and there I got the option append an element and if I click on that I can select the table again and now I can choose the rooting plan and do the same for the rooting plan or the Alo the App G cut number bets one bets
• 38:00 - 38:30 two what also I can choose TR te yeah just some columns and if I confirm I will have the rooting plan directly under my parts list and if I go to the preview then I can see
• 38:30 - 39:00 post do you have sure are you
• 39:00 - 39:30 sure Che item yeah of course if you want to move this
• 39:30 - 40:00 afterwards and switch it you can select one and [Music] select foree
• 40:00 - 40:30 okay so we want a bit of space between
• 40:30 - 41:00 those tables before yeah exactly so we select the second element and
• 41:00 - 41:30 column count distance before so we can set it to 10 mm we want SE in the layout preview but in the
• 41:30 - 42:00 preview [Music] have separate coner also okay what is the difference if I have or I have for example if you got your project in a landscape mode and you want on the left side the parts list and on the white side the rooting plan you
• 42:00 - 42:30 can't do this with only one container so you need two containers and that's new in listen lbel 20 before listen lbel 20 here it was only possible to have one container and you have to do everything in a single container if you have two container you can drag and drop to make one oh I don't think that it's possible but I never tried and um it's something like um if you would do it like this that you got a
• 42:30 - 43:00 container here and another here and you got a very long parts list and the container doesn't grow so if you want to use one page for both and it should be dynamically um you need this in a single one if they are in single then if part list is long enough it will get stretched automatically no it will yeah if you got one container
• 43:00 - 43:30 it stretches like the container size so example I will minimize it to this size so now you can see I got two pages it will only take the space from the container from the report container and what if part list is more than one page go right to the next go to next page yeah okay
• 43:30 - 44:00 so now you got the pr
• 44:00 - 44:30 you should use int so you can't type anything wrong uh how do you manage to make one container inside the
• 44:30 - 45:00 other yeah you were talking so now that was your chance append on element click on report container click on append
• 45:00 - 45:30 so now we can style it a bit change the headers do something senseful not using our cryptic database names
• 45:30 - 46:00 the container and then from the left side objects an element click on WE container and there you got an icon called aent element
• 46:00 - 46:30 fore fore speech speech speech
• 46:30 - 47:00 can I set the property of container setting Auto stretch to stretch yeah if
• 47:00 - 47:30 needed yeah do this okay it's possible to change um for example on the second page where you don't have a header that the container grows a bit so that it's on the second page and all following Pages a b bigger okay so now we want also a topic for our so I will start with a rooting plan just
• 47:30 - 48:00 double click on it and go to the header line of the rooting plan and if you select the line definition in here if you select the line definition and click on new and the line definition you will get this response just confirm it and you now got a second
• 48:00 - 48:30 row and inside this second row you can create another column for example in text so we will chose a second line select a new text column and we can statically WR theing plan for example and the second line can also be moved to
• 48:30 - 49:00 the top so we got first the rooting plan and then we got the headers for the columns so maybe we can call this here the title and these here are subtitle add us column headers or whatever and now you can see we got a small title in
• 49:00 - 49:30 here we can also change the width of it so if you zoom in select it press control and stretch it so you got a title for your table
• 49:30 - 50:00 there's also another option you can also bind the title to the table name so if you change this to default rooting plan you maybe want this title to change also so we can use a variable for this for example
• 50:00 - 50:30 LL current container item so it refers to the name of my object okay so this is Now default rooting plan and if I change it here it will also change in my preview
• 50:30 - 51:00 you can try this for the parts list to so we can also copy that makes it easier we go to the header line we select the title say copy and paste it into the header line of the parts list and move it up okay and now we got the second title also for
• 51:00 - 51:30 that's big for
• 51:30 - 52:00 to
• 52:00 - 52:30 [Music] fix the first table becomes big the second table will come to the next page right it's like to simulate two
• 52:30 - 53:00 pages okay can I go on no I couldn't add the title you couldn't add the title
• 53:00 - 53:30 why head Al line select a folder and just click on the P line definition okay did that okay confirm you did that already then you got an empty folder right
• 53:30 - 54:00 no no you are currently in the bo head you need head line okay Y no you don't need to that just click on me no yeah line definition confirm I was selecting this and you don't need
• 54:00 - 54:30 to okay and you can yeah exactly create and there you can a new text cover y already and there you can anything like I already red it it's not that no
• 54:30 - 55:00 it's just a folder it's not a visual component and then you can type LL without quot just LL yeah current container current c yeah container item the second yeah the second item yep see
• 55:00 - 55:30 let's Okay no you can copy it to okay tells
• 55:30 - 56:00 me like your expression yeah course okay we will go on so um I want maybe I want the sum so I need a F line for both for the parts list maybe for the quantity I don't know and also for the rooting plan I want the fter so I double click on rooting plan
• 56:00 - 56:30 and select the third tab called f line and I will confirm this and now I can create another text column inside the yep and there we can use an expression like sum and then
• 56:30 - 57:00 [Music] our rooting plan dot te or I think my first column was TR a start up time and we can create another column exactly the same just with a different column boting plan. te okay so we got this F align with two
• 57:00 - 57:30 sums in it and I want these to be wide aligned if I problem firm we will have two new columns in
• 57:30 - 58:00 here two new cells and if you press control you can move them separately to the end I to here we go
• 58:00 - 58:30 I will open it again line sums sum for rooting plan TR and te maybe you got different columns something else y select both yes and set the alignment to the right
• 58:30 - 59:00 some and maybe you also want another FR a grid line a stronger grid line at that one so we can choose dark
• 59:00 - 59:30 line this this colums on the first underneath the first columns yeah and if you press control you can move them separately without moving okay the
• 59:30 - 60:00 Cs above or you can move it to the right we will do the same for the parts list so double click on parts list select food [Music] line confirm create a new text column some of parts list
• 60:00 - 60:30 dot I think I got m in there and set the alignment to the right confirm now I can see the sum now I have to move it with a control room this this place one one one one four so if I
• 60:30 - 61:00 want this uh if I want another column so that it looks quite good then I need to insert an MP color that stretches it's like a column spam so how can I sorry go ahead how can I issue a for format okay you can if you're in the
• 61:00 - 61:30 expression editor you can choose number format so for example I will cut this and select a nice format and I can can I edit back for yeah of course if you don't want any okay we just got for
• 61:30 - 62:00 okay great first I will create a second column so that it looks roughly the same so I will create just an empty column just for having this
• 62:00 - 62:30 okay one time on
• 62:30 - 63:00 and now make some right how did you have to insert empty okay a
• 63:00 - 63:30 space today I saw Co [Music] expression this one yeah do you need space no no the dark
• 63:30 - 64:00 the dark line yes the good line okay select the columns and fot line select clst PR control and there you got a frame you can click on frame you can pick color like 42 it's
• 64:00 - 64:30 black you can choose a width like 0.5 and then click twice on this icon the top order we move the top border and inert top border then strong line
• 64:30 - 65:00 I make it B
• 65:00 - 65:30 we can also use our template again so same procedure as the last
• 65:30 - 66:00 report click on Project includes and there you can include your template for example we got a template here fore
• 66:00 - 66:30 you highlighted a bottom line of
• 66:30 - 67:00 container yep that was a f I think you exp but I was select the fine select those colum and then you got a property called frame and there you can pick the color like is wonderful and set with and now you can
• 67:00 - 67:30 remove this top border by deactivating this toggle and activating it again and now it replac it it with mys
• 67:30 - 68:00 [Music] know Enterprise reports I think we got one in Sol that was redoing and redesigning those reports
• 68:00 - 68:30 and already what do you want so you that no he asked it to do something with with label and both said if you want you can make a set off default report from Enterprise and he said oh great idea yeah it would be
• 68:30 - 69:00 funny he started he already started made some reps I don't