Kevin7

Summary

In this transcript, the focus is on enhancing data reports using List & Label, a tool by TimeLine ERP. The discussion begins with handling datasets, emphasizing SQL syntax validation to catch errors quickly. Sorting and grouping are advised to be done at the data source for optimal performance. The session demonstrates creating a report with a form generator, offering insights into configuring table layouts, formatting columns, and inserting expressions correctly. Tips on using layers for conditional formatting and simplifying translation processes within a report are shared. Additionally, there's a hands-on approach to customizing page layouts, from headers to footers, ensuring consistency and professional design. The goal is to create reports that are not only functional but visually appealing and efficient.

Highlights

• Understanding the importance of SQL syntax validation for error checking 👨‍💻
• Debating whether sorting should be done in the dataset or report module 🤔
• Demonstrating step-by-step process of using the form generator to create a report 📑
• Exploring the use of conditional formatting using layers in List & Label 🌈
• Discussing methods for consistent report formatting across an organization 📊

Key Takeaways

• Always validate SQL syntax to catch errors early on 🛠️
• Perform sorting and filtering at the data source for better performance 🚀
• Utilize the form generator for a structured report design 📝
• Use layers for managing visibility conditions effectively 🎨
• Keep report designs consistent with company standards through templates 🏢

Overview

The transcript covers a detailed guide on using List & Label to enhance data reporting. Starting with the basics of SQL syntax validation, it stresses the importance of early error detection to streamline the reporting process.

It also highlights the optimal use of the form generator to design structured, efficient, and visually appealing reports. Emphasis is placed on the significance of sorting, grouping, and filtering at the data source for improved performance.

Moreover, the transcript explores using conditional formatting via layers, allowing for dynamic visibility management depending on specific report needs. These insights aim to ensure that all reports maintain a professional, consistent look and functionality.

Chapters

• 00:00 - 02:00: Introduction to Dataset Designer The chapter titled 'Introduction to Dataset Designer' involves working with a dataset designer tool. The process begins by clicking on 'load' to open an item list. The next step is to click on the 'preview' option, which, given the correct SQL syntax, will display the results.
• 02:00 - 04:00: Creating and Expanding Dataset The chapter discusses the process of identifying and fixing SQL syntax errors by using a preview feature in a dataset creation tool. It highlights the importance of keeping sorting, grouping, and filtering operations within the data source to maintain efficiency and accuracy.
• 04:00 - 06:00: Using Preview and Form Generator The chapter covers the usage of the Preview and Form Generator tools. In this session, the speaker discusses why data set servers perform faster than report generators. They encourage ordering data within SQL to optimize efficiency. A walkthrough on opening a data table, ordering items, and selecting fields to organize data is also provided.
• 06:00 - 08:00: Layout and Report Customization This chapter focuses on layout and report customization, highlighting an interactive process where users can make changes and preview them before finalizing. The discussion includes dealing with items that have null values, indicating potential areas that need attention or further customization.
• 08:00 - 10:00: Advanced Features and Functions The chapter introduces a simple data set that will be expanded step by step. The process will be performed in the data set designer, rather than by a developer, due to the usefulness of the preview function.
• 10:00 - 12:00: Grouping and Sorting Data In this chapter titled 'Grouping and Sorting Data', the process of beginning a report is discussed. The chapter illustrates the initial steps required once you have your data source ready. Specifically, the focus is on utilizing the reporting tools by accessing the form generator or TFG, which resembles the systems used in Enterprise SF. This tool aids in organizing the data into a new list and model, which is a critical first step in the data sorting and grouping process.
• 12:00 - 14:00: Layers and Appearance Conditions This chapter introduces how to navigate reports in Timeline Nail. It begins by mentioning the ability to view existing reports and provides instructions on creating a new report. The process involves clicking on 'new report' through a green plus icon or by pressing F2. Following this, a label opens where an item list can be selected.
• 14:00 - 16:00: Finalizing and Saving the Report The chapter focuses on the final stages of preparing a report, which includes checking the content for accuracy, ensuring that all necessary information is included, and making any final adjustments. The importance of properly formatting the document is highlighted, with tips on how to effectively organize information. Once the content is reviewed, the process of saving the report in various formats is discussed, emphasizing the need to choose the right format based on the intended audience and purpose. The chapter concludes with advice on conducting a final review to catch any lingering errors before the report is officially completed and distributed.

Kevin7 Transcription

• 00:00 - 00:30 so maybe we should work with the data set designer I will click on load and open my D item list and now we can click on the preview and if we got the correct SQL syntax then you will see the result here
• 00:30 - 01:00 that's important for finding errors if you got any error inside your SQL syntax and it's not correct you will directly find out if you click on preview yeah do you think that a sort should be inside the data set or on yes good question uh sorting grouping every kind of this filtering all always in the data source
• 01:00 - 01:30 not in the weport because the data set server is faster than the weport generator it close the data and ordering it after it so if you want to order your list do it inside the SQL we can do it I will open the data table again for items and click on order byy and just drop a field like maybe bet one
• 01:30 - 02:00 after that that's two those the sending okay we can click on preview again save changes yes and we got a lot of items with null values here but never mind okay
• 02:00 - 02:30 that was the first very simple data set I think and we will expand this data set step by step so this is just the first example um I would say we will do this in the data set designer and not in the developer because of this preview function we will need it more it will be easier with uh with a preview
• 02:30 - 03:00 okay now we got our data source so we will start our report so we can go to tools and click on form generator TFG that will open a new list a new model looks like SF in Enterprise
• 03:00 - 03:30 so we can see the reports which are already included in Timeline nail but we can also create a new report with a green Plus or F2 we click on new report create a new report with a green plus and select our item list after that this label should be open
• 03:30 - 04:00 stand
• 04:00 - 04:30 for spee spee spe
• 04:30 - 05:00 [Music] yes us on
• 05:00 - 05:30 device okay no no not
• 05:30 - 06:00 fore spe [Music]
• 06:00 - 06:30 have it English look
• 06:30 - 07:00 [Music] [Music] not not here not here develop yeah I think C right
• 07:00 - 07:30 add table Pro
• 07:30 - 08:00 I made the and I close this [Music] one not blue just
• 08:00 - 08:30 all the time so if you didn't save I think I Sav if you saved then uh you will have an entry or call like time [Music] stamp can we go on yes
• 08:30 - 09:00 please okay so um what we can see is listen label first of all we will save so click on save as and give it a name it's a time stamp so just call it LL item list I will call it LL so I can find it better because it saves zort into the standard path and not into the custom path by default maybe we should change
• 09:00 - 09:30 this okay a few words for the surface of this label on the right side you can see variables and Fields so variables are filled once and fields are filled inside a loop a pointing Loop so if you just want your first um your first item you can drag and drop fields on the right side to your paper and what
• 09:30 - 10:00 you can also do you can drop more than one field inside another field so you see it creates something underneath so that's one that's two is null I think just as example so um we also got the possibility to filter this list I think that's pretty cool you can find as long
• 10:00 - 10:30 as you know the column you can find it very quick you can only see with the icon if it's a string value or number value or date or something else we've got the possibility to zoom that's also something that is missing power builder then we got the main whb with some yeah you can select you can also set to zoom you can insert different
• 10:30 - 11:00 objects the main object is a we Port container you will use it later and you got some project options so like the design scheme or the possibility to set the paper to landscape portrait you also have some options here variables stuff like this you can also
• 11:00 - 11:30 um activate quid lines stuff like this okay um over the paper we can see the ruler also on the left side and if we need a help line we can click on the ruler and pull it out so we can create a guideline yeah we can create a grid
• 11:30 - 12:00 for our controls later so maybe you need um something if the printer can't print on the outside so you can set a grid here or something else if you want them to disappear just pull them out or inside the ruler again
• 12:00 - 12:30 it's more like a grid a helping grid you can dock controls do a good so that's okay these are called the guidelines in design and every graphic program has them to you can actually use them to make your own layout Nic how they are different from margin they just virtual line so can
• 12:30 - 13:00 yeah exactly so so if you create a rectangle for example it will dock SN yeah it will depend on how is the zoom but yeah it snaps and if you you can move the line and it just moves but you can also hold control and move the line and the objects all objects that are snapped to it will move with
• 13:00 - 13:30 it so that makes us pretty easy to change aort later okay on the left side we got our objects so this should be empty if we insert something like a rectangle we will see here a new object rectangle and underneath we will find the properties of it so if I click on the rectangle or
• 13:30 - 14:00 select it here we can see the rectangle properties in here and I've click on the background we can see see the project properties okay I will delete this and yeah
• 14:00 - 14:30 now we can start with our item list so I set the squid in the pl do I have a option of custom paper size uh yes of course you can select project not sure if it's layout regions and you can say if it's A4 A3 yeah you you can also
• 14:30 - 15:00 change let check not means custom yeah if I press control key on my Mac it doesn't move the snap object it just moves the the line but I SN some text there some item number so not rectang so
• 15:00 - 15:30 press control just control yep just control and move it which you selected custom uh not yet I selected and have to check I don't have it def in English is yeah I think it's not juste envelope
• 15:30 - 16:00 I also have to check have to do this we already done this at custom doesn't have it you're special
• 16:00 - 16:30 [Music] no paper size we will cheex those later I will see you have we can do this I'm not sure right now okay so we will just start with our A4
• 16:30 - 17:00 paper can again this step with question don't need it now okay so we will select insert in the r and create a report container in that report container as I said that's the main control so we will pick it and stretch it over the paper and now we can choose if we
• 17:00 - 17:30 want a table a cross TB a chart or gun CH that work we container [Music]
• 17:30 - 18:00 works okay we select we select table and now we can choose our data source so we select our items go on and now we got a picker for our columns so we can see the art table in here and
• 18:00 - 18:30 we can drag and drop or we can select multiple columns and uh switch them to the column side to the right column side and um you can also filter this so we want vs one vs two ZB article F car and
• 18:30 - 19:00 maybe quantity number me number how can I change it do you plan to to have a change the number dis the value behind that's why I selected okay can I change it if I want to add the new col
• 19:00 - 19:30 yeah so now we get the table and if you click on preview at the bottom side you will always already get an item list some pages
• 19:30 - 20:00 so I forgot to mention we got three different views we got the pure layout that's a bit minimalistic and we got the layout preview that's mix part of the layout and the preview and the thir VI a preview itself so you can't edit anything inside the preview you have to choose the layout preview okay so what we're going to do is um we delete the second the third column
• 20:00 - 20:30 the bets 2 because we want the bets two underneath the ads one so we can see in our object list there's a report container inside the report container there is one table called items and we can double click on it we can also double click here and we get this
• 20:30 - 21:00 window so the table we've created got a header line and the data line is something like inside the power Builder the different uh bands the different layers so a header section and a data section so now we can start deleting that's two and I also have to do this inside this data line that's two and
• 21:00 - 21:30 delete as soon as I confirm you will see the result if I delete the head data it will be shifting so that's something it's not a it's not a fixed table so you can move those columns here
• 21:30 - 22:00 so you're moving the header section and the detail section but it's also possible to move only one cell if you hold control then you can move only one cell and not the whole column so I will rearrange my columns a bit then I got a bit more space for the
• 22:00 - 22:30 bets but if I resize bets one then support become smaller in your case it's line what should I drag should I drag from the header or from the line it doesn't matter in the vertical line between B one and so forth should I drag to make it bigger on the line level or on the header level it doesn't matter it doesn't matter but support in my case it's only if you
• 22:30 - 23:00 press control then you can change the withd of a single cell I don't want to do that I want that that support remains in the size that it has so when I drag that one to the right so what become smaller if you drag this one here like this yeah exactly and the zoo Port yes like this so how can I prevent that start from the right
• 23:00 - 23:30 no there's um also an option for it so uh I think it's let me check file options and there you got something like object work space this one column with modification
• 23:30 - 24:00 affects the next column contrl M if you deactivated then the others will move instead of getting smaller and you can activate and deactivate this option with control L yeah sometimes you need yeah okay so now we want the bets to underneath B that's one so again I just double click
• 24:00 - 24:30 on my items and now we have to choose a data line and the second column that's bit one we want to add the BS too so just double click again you will get an editor for it we do it a bit smaller resize it a bit
• 24:30 - 25:00 maybe you can see better okay so we got here item bits one and what we want to do is we want uh CHR 30 that means line break and then we want items do bets to in here we got intelligence so that helps a lot also if you're
• 25:00 - 25:30 inside a function you will see the description of the function and the parameters screen number whatever and an example so for all functions will get a bit of help and if you're not sure what the function is doing you can also press F1 and I think we don't have the English help the helpl line blah blah blah could not
• 25:30 - 26:00 be found yeah oh it's same okay is it called t m maybe this works y okay
• 26:00 - 26:30 so yeah I think it's a j we need to English one too where where you renamed it uh inside CT 12.4 and then there is a cmll
• 26:30 - 27:00 2000. chm t menu and I we named it to 200 we have to put the correct file okay 2001 the next sorry okay so first of all we just have the German mod can you say again what's the CH that's just a line break it's like in power Builder 10 and 30 new
• 27:00 - 27:30 line I think this is better than till yeah okay so will check Take N null and that's a point we will see a lot of values which are completely null so um same as in power Builder if one value is another the whole expression becomes null so we have to
• 27:30 - 28:00 change this we have to check for it I double click on items I go to data line select my expression items bets one bets two and now I will delete it and why completely new because intellisense will help me so we can check with a simple if and there's an expression is null or empty
• 28:00 - 28:30 items that's one WR an empty string otherwise take items that's oneing you use both both kind of uh yep Ying you can use a single one or a double code doesn't matter it will also tell you directly if your expression is correct if you see the this blue information one and now we
• 28:30 - 29:00 can put a plus in here to add another string I will press control and enter to jump into the second line and we will do this again for bets two if is Another Empty items bets two do nothing or print nothing otherwise print uh sh 30 and the items get
• 29:00 - 29:30 two that's it be nice if they had a name for this ch
• 29:30 - 30:00 L there is a special sign I think you can go to text and said yeah Line Feed and then you got this paragraph symbol from word and you can insert this and this would also work but you can find it on your keyboard so it doesn't make sense to use it
• 30:00 - 30:30 isre if it's correct you can see the the blue circle was information yeah okay so some words for the editor you got different functions in here you got numerical functions mathematically functions functions string functions and also
• 30:30 - 31:00 terine functions so if you expand them you will see some of our timeline functions like stuff like this if you're searching for anything you can also use this pter and maybe you would need a wild card so you can use a
• 31:00 - 31:30 star so for example some you won't find some I white a big S you can't find it
• 31:30 - 32:00 that's called I'm I'm not sure why he can't find this
• 32:00 - 32:30 one this maybe it's only showing function okay anyways you can expand them and satate inell SE
• 32:30 - 33:00 begin yeah but starts with some but I think it's only um list label search as for scen for functions that are returning a string value because I'm in a string field yeah I can find this one that's a bit strange
• 33:00 - 33:30 okay and will work see there no sum I don't know okay we will check our preview and now we can see we have some expression that were empty now they are filled
• 33:30 - 34:00 again okay we can start some formatting from the table itself so we can set for example the article F car and the me number to the white so from the white side you see the properties regarding those selected
• 34:00 - 34:30 columns can select them both yeah you can select multiple and set the alignment to White and also in data line select those and align them to the white now they're white aligned the should not be or I think it should be white we don't
• 34:30 - 35:00 use it in time I know we always Center the header but I don't think that this is white we can we can change the header line to to the center never mind they can be different mhm okay I I need I forgot to add unit
• 35:00 - 35:30 column so how can I now okay you will add another column so we can use this wizard if you want to for adding a new column but you can also insert a new column here add a new column it could be a text a picture barcode something else so usually it's a text where you can
• 35:30 - 36:00 write something else uh what do we want text so that's a static text for the header line and now listen label ask me if all other columns should be a bit smaller so that the column fits and also I need a data line I can do it the same I click on add new text and here we got
• 36:00 - 36:30 items. text okay everything else should be a smaller and now you can see we have an additional column in here with a text in it we Ed in second line it's um it depends on what is selected if you select this folder and
• 36:30 - 37:00 use the wizard then you will create another Ro if you select a column and set the wizard then it just adds no he always adds a second line can I drag yeah you can drag it the first
• 37:00 - 37:30 so if I want to insert a new field do I have to insert in C in header and also in the data or just in head yes in head and dat the condition matches that then I will display yes or no a
• 37:30 - 38:00 buet yeah of course that's what I've shared you can add codes pictures checkboxs dat graphic tortes charts inside the P looks weird but possible yeah of course okay we got our table now we see the me number doesn't help us so we want to see
• 38:00 - 38:30 the real name it would be stti otherwise it's pce or something else meter be so we have to extend our data set questions yes if I added a new How can I the corresponding column header you have to
• 38:30 - 39:00 add it separately this paper doesn't add added on both sides what do I have to add in header I don't have to a column I have to add some text right yeah just insert text yeah and then it opens his response when you click that and then you write the text down there within quotes so you can call
• 39:00 - 39:30 this item number by the way is it to local yeah of course we have top no no no we can company
• 39:30 - 40:00 swe blood okay I will delete my text I don't need to TT in here but yeah we can all also translate I need your help I believe
• 40:00 - 40:30 I think I will be a person who will bother you a lot I addit this later okay but that's in the header section and not in the deta section no oh just double click okay and now you can press control X or select y yeah to data line and there you can insert it control
• 40:30 - 41:00 V T and now you can move it down to that yep so data line and header line both has to be taken here yeah exactly so now you need a header line with a description but you can also copy makes it easy thank you
• 41:00 - 41:30 okay um we can translate it here but we don't have a language number inside our art table but uh we can help I mean the yeah but how you find out which language I I propose to make the language part of the report that we want to create for invoice where you have the language in the document in the link and
• 41:30 - 42:00 then you can select wait a bit I'm in this matter but I want to see it the right context but what we can do we can set a variable called uh language and we can set here something like zero for German or one for English or two you have access to the system like local local system no no so I need
• 42:00 - 42:30 this variable yeah but I can use it inside the whole report so I just need to change this variable we don't actually need the system language we need the language of the business partner of the do the report which the language in which you you want to to write in the customer and that you have in or you can take the user language but if you got a variable you
• 42:30 - 43:00 can select the header line and you can use our function tier translate and select language as number and the string that translates from the database from the repository y EXA should be not item number already yeah yeah
• 43:00 - 43:30 [Music] right yeah I can select article and what you was it one I'm not sure engl English and I'm not sure how it's called but usually you can see it directly it
• 43:30 - 44:00 works okay we will also do this later in a invoice or offer or something else okay now we want our quantity description
• 44:00 - 44:30 [Music] [Music] can we go on okay so I have list and label so we see a new entry in here where our report
• 44:30 - 45:00 and our data source matches we can click on save so that this line is already saved and now we need to extend our data set I already put the data set designer open otherwise open it again tools to data set designer TDS can actually press on the blue it in the
• 45:00 - 45:30 form generat it not always works sometimes the data set is empty after that if you use a blue arrow it's a bug I still got so yeah usually you can also use this blue arrow it's it's entered in the back TR yeah so open open with three points and now we need
• 45:30 - 46:00 another table so I will add another table me or me SP regarding on what you want to do yeah that's our it's reported should I sorry I think it's nor okay I added another table I will select
• 46:00 - 46:30 the column I will need it's a b column and I need a join between those tables so I click on joints in the upper right corner other click on the left side and I will get an inner join I can change this to the left outer join if I want to but I'm connecting from table
• 46:30 - 47:00 art me number to the Target table me Target Field number basically you write a very good data set you need and you arrange the things on the form the way you want
• 47:00 - 47:30 that's it that's yeah what you do the joints inside inside the tubs I have more than one place where I think click on corner so you didn't make you haven't made the tables on the main mask you made only
• 47:30 - 48:00 one table no we only got one data table
• 48:00 - 48:30 yeah can you click once again join please [Music] yeah thank [Music] you um you can s multiple data tables with the same table inside that would be
• 48:30 - 49:00 possible but you can't add the same table twice with an like power power will rename them automatically with anore aore B if you need the same table twice but it's currently not possible inside the design
• 49:00 - 49:30 um we will see later the second inv we six makes it very EAS you got different stat it's better than power you got only one select yeah and you always need to or select first or something that it works okay we've added it here
• 49:30 - 50:00 so what's important if you click on DB Fields lower and you scroll down to the end then you can see all the columns also from table me the bets and you will see here the alas so how it's called and because we have already have bets one and Bets two in our item we
• 50:00 - 50:30 should rename this because otherwise we have bets bets one and Bets two that could be a bit confusing which kind ofs yeah exactly you don't know which kind of bets so I will rename that to me bets and also sets are cap to me bets I'm not really sure what the caption is doing the allas is enough [Music]
• 50:30 - 51:00 yeah hidden [Music] feature I don't know why we can drop this okay new feature so later if you create an
• 51:00 - 51:30 invoice or an offer it's important because we got those tables like um Le ZK LK and they all got a column called FS that makes confusing so just rename it to a user container that's is a
• 51:30 - 52:00 okay we will go back to our B generator click on LL item list a blue arrow in front of LL item list and L label opens again and if everything is right we should have a new column [Music]
• 52:00 - 52:30 bit bits yeah so now we can exchange the last column I will double click on the we ports container go to the data line again double click on my Expressions on my expression for the items m e number and we place it with me P now I can see the description
• 52:30 - 53:00 [Music]
• 53:00 - 53:30 okay what we did unit yeah it's a how we add that how we add that just double click data line yeah and then the items
• 53:30 - 54:00 me number we have have changed to me PS oh okay how double click okay and items okay okay now you want to to have a headline for our we Port we want a page
• 54:00 - 54:30 count maybe a date so I will reze this stuff I go to insert select the text and create a headline called my items name is from and now I want the current date so I
• 54:30 - 55:00 just can click on date format select a nice format which I want for example this one and double click on it and it will automatically add this to my string expression in
• 55:00 - 55:30 text like it by the string choose a date format double click so as you can see the function name contains a dollar sign that means that the return value is a string so you got multiple functions some with
• 55:30 - 56:00 a dollar sign and some without the dollar sign so you can directly see this will return a string value and with a plus you can add two separate strings and yeah it got two parameters called now and so form out itself back in power okay now we got a headline we can choose a big of f for it and make it C I
• 56:00 - 56:30 got just a minute you can Center it error datee string is not properly and okay how can you the
• 56:30 - 57:00 text Si um you can double click for example I will do this and you can double click on the text and you will get some properties for the text itself and there you can play is it possible alignment
• 57:00 - 57:30 appear have to make smaller yeah I think it's not possible in here but we got some other controls like the report container where you can vertical line okay if it's a single text you can't
• 57:30 - 58:00 okay now we need another text for our page so I will scroll down take a bit more space
• 58:00 - 58:30 and same procedure inser a new text just here in the lower right corner and now we can say Page Plus the function page sign bracks plus total
• 58:30 - 59:00 pages so you can see here a expression it says zero because at this point of time this label doesn't know how many pages will be printed so it's just a dummy page one of
• 59:00 - 59:30 yeah uh theard container itself got a footer got a footer line you have groupings yeah it's set this page number inside the um have I would use a text box because it's like
• 59:30 - 60:00 uh the option in power Builder slide directly above if you insert a fter line in here it's directly after the last data line so it jumps to the top maybe yeah exactly so I use simp text box we can test VI soon as it loads all pages you can see here the result
• 60:00 - 60:30 P to
• 60:30 - 61:00 display yeah of course you got appearance condition mhm where you can set form where you can
• 61:00 - 61:30 sayal one and have page how you need that um for each control you have an property called appearance condition okay where you can set it to True always show to never show false or you can set a condition like in power Builder like page like H equal one it's only on the
• 61:30 - 62:00 page condition I cannot
• 62:00 - 62:30 page as of the page two it still consumes just scoll down
• 62:30 - 63:00 you mean that it itself on the second page yeah that's possible we will do it later [Music]
• 63:00 - 63:30 oh then I choose character 10 instead of 30es what is the difference I think one line and new line okay so if I want to if I want to uh display footer text only at the bottom of report on last page yeah same way same way you
• 63:30 - 64:00 select the control you set the appearance condition to formula and there something called last page last page okay yeah because that is dynamically you don't know what is the last page it's not like page if page equal to page count also yeah that's also possible you can also say page five total pages okay that will work the
• 64:00 - 64:30 same or just use last page there are different ways okay so also for those um appearance conditions we can also use so-called layers we got three layers in every project you can extend those layers layers by yourself so you can see there is already a base layer a first page
• 64:30 - 65:00 layer and a following Pages layer so you can select an item right click and set assign to layer first page and you can see behind the first page there's a condition called page equals one and now you can see this rectangle is a bit of yellow so you can directly see okay this is for the first page only and if you go to preview you can only see it on the first
• 65:00 - 65:30 page so it doesn't mind even if you set this here to True always show the layer got a higher [Music] priority so and it's colored and you can also extend those layers and create an own layer definition own layer this is my layer and a condition
• 65:30 - 66:00 if fail to you something like this or I don't know maybe can we Define last page layer uh I think last page is one of the only thing uh things that is not working with a layer but we can test I'm not sure I didn't try this in system label 20 that changed so we can give it a colorr visible okay we got a last page
• 66:00 - 66:30 layer now I set my [Music] H2 oh it's working it's working check yeah it's working how did you add lay just right click and select layer
• 66:30 - 67:00 definitions just a mean how I created a layer so that's pretty cool you can you got different colors directly see oh this is first page only this is last page or you can only you can also differ between different document types of our invoice you created last P help uh right click layer definitions and then you can here create a new yeah
• 67:00 - 67:30 canf the good L the good L doesn't you can't check all the layers the layers is you check okay then you won't see the controls okay you can see everything for the last P yeah it's cool if you got a report for
• 67:30 - 68:00 offer an invo delivery note something else you can uncheck and directly see all regarding controls okay can you repeat a bit dis description of all base page is detail page basic layer the base layer say
• 68:00 - 68:30 something about that the base layer is just everything which isn't on the other layers base layer is always true it's always okay don't no condition okay condition so if you create a new object it will be in Bas layer yeah okay oh because I think I
• 68:30 - 69:00 have wait maybe because of the order it's important how
• 69:00 - 69:30 so it will take the first activated layer if I deselect the base and the last page layer and create a new object that got the first page layer makes sense
• 69:30 - 70:00 how is the function to to know the last page last page with dollar or without without uh do you want to show a text I I want to make a layer with page equal with last page last you can just choose
• 70:00 - 70:30 last page and Bre it this function already yeah no you don't need easier y make page equal with total [Music] Pages work page dollar sign equals total pages sign doesn't work doesn't work as a condition we try
• 70:30 - 71:00 that page dollar page dollar without page doar page dollar it is not working it's never it's never true never true two strings just use
• 71:00 - 71:30 page okay that was the first example I think that was pretty easy shouldn't be a problem any questions
• 71:30 - 72:00 now yeah always layer yeah assign layer and then you can choose one and suppose suppose we have two kind of header or two kind of footer suppose our report is a group by article group and when group is modified changed I want to repeat one
• 72:00 - 72:30 header not not on every bit will yeah later oh we can do a grouping that's a good idea so we can extend this and uh you have to do this inside the weot container not outside but we can do it yeah okay we will do a grouping that was a good idea first uh I will rename my objects because currently it's not important but later maybe I need you need one just
• 72:30 - 73:00 rename those objects my title my page have user F okay okay we double click on our table items and now we also have a group head and a group router that's worthly the same like in power Builder so you can speci ify an unlimited number of groupings so
• 73:00 - 73:30 just press okay and now you got a group p and we can call it um I don't know I want to grouping like a phone book so first I want all items beginning with an a then with an B with a c and so on let's make our SQL order by group in SQL we don't need just we can group inside here just to show I think
• 73:30 - 74:00 everyone can so we got a group header I've just renamed this folder and now we can create a new text color in which we can use um the grouping and we can use left here a string like items x
• 74:00 - 74:30 one okay from the beginning double click on table items then choose group header just confirm this for okay and now you can create a new text column where you can use the function left dollar sign where you can put in the string like our that's one and the
• 74:30 - 75:00 number would it make sense to group up M maybe because we have ordered the SQL okay by bets one and Bets two I will choose bets one and Bets two okay so this function will give me the first character of my bets one I will copy this Mark it copy
• 75:00 - 75:30 okay and now I already I also need to set this inside this grouping definition so there's a wet field called the group by and also I will need this expression in here and then say of name doesn't matter just for me a
• 75:30 - 76:00 name okay I'm sorry no which is good by this expression and a text
• 76:00 - 76:30 card can we do it one second please okay sorry double click on items go to group wait wa it's hard to listen and to do in same time you are always one step okay and confirm
• 76:30 - 77:00 okay now you can insert in your text color there you can put in with intellisense left dollar sign items bets one and you want the first character so the second parameter number of characters this one I will copy this I
• 77:00 - 77:30 copy confirm okay and select the folder the group folder and also insert the grp P expression with the same can do make an upper first that's there
• 77:30 - 78:00 that's that's a good idea an uppercase yeah you can also use an upper in it that's better so I will change this in both sides confirm this and check my first values are null
• 78:00 - 78:30 so we don't have a grouping here but then it starts here maybe I should change the color it starts with the numbers and later I also have some characters yeah change the backround yeah if you want to change the color theme for everything the easiest way to is to select the project and change the design scheme to something like I think
• 78:30 - 79:00 City Cruiser is colorful yeah that makes this better it's easier to see and we can [Music] also make it a bit bigger so bottom if I want [Music] anything else not I have to specify
• 79:00 - 79:30 article yeah I did that other words you have 10 groups for one yeah yeah now I want to modify what I did as a group header y click and then what
• 79:30 - 80:00 I okay I will increase the font size just a bit to see it better 16 item size
• 80:00 - 80:30 and I will this column a bit bigger like this for
• 80:30 - 81:00 okay we can set another property just a small thing double click on your
• 81:00 - 81:30 container item on your table select the group header and I think you can say set this option break before can see here if the group line is printed a page break or column break is Tred before you can set those to yes so every group will start on a new page which looks a bit
• 81:30 - 82:00 better what was that same inside the group header those folder right before yes
• 82:00 - 82:30 so I won't see group header over there along with title the group header with the title No in the list of the start Green Line yeah okay well the next is again page break
• 82:30 - 83:00 H and the component this these are what component list item list below project below project they are what they all are what components components of a report no yeah exactly of the we container I cannot see the header of group there oh you can see in the layout preview you just need to zoom it's not filled because our first group is n is empty
• 83:00 - 83:30 okay if you modify your SQL and um filter those null vales out or sorting them out then you will see it here inside the preview otherwise it's a bit small okay okay I have language and don't
• 83:30 - 84:00 it's they based on the on the name so from the first one the last or it listen label 18 no no it's 20 okay maybe you need to switch inside this layout group it SS after the okay you can change the language inside U so this
• 84:00 - 84:30 module if you set this to English you will have the English list okay you want to buy if you got the grouping inside SQL you wouldn't have another result so you wouldn't see anything you would have
• 84:30 - 85:00 multiple lines can depends on the grouping you can group in SQL or group you can group in you cannot control the layer because it won't see SQL like base I think it's a grouping in s just so again do not do grouping in s do the grouping here I think it's it would be faster in SQL the performance would be
• 85:00 - 85:30 better but for the handling that's not good depends on more that you have that you necessarily need in SQL but do not do any grouping do not do any filtering in SQL oh of course filtering and ordering is better thanl it's faster okay it's faster but then you cannot control it yeah you have to modify the
• 85:30 - 86:00 data set you can also do the ordering inside this we also get a got a filter and the sort order but it's not as fast because it's retrieving the data set and then start ordering it and so it takes tce time one report one time I but best looking not fast yeah you can also reorder it here for okay article group
• 86:00 - 86:30 asending or something else okay so I think now you know how the grouping works and for example we can also copy the grouping and um just do another grouping for the next two just characters for example so you can have as I said an unlimited
• 86:30 - 87:00 number just yeah or otherwise you can right click copy and paste so um I will deactivate this gr before otherwise we have too many pages and change the color yeah maybe we should change the color yeah
• 87:00 - 87:30 maybe we can make this appear wet or something like so we have a group for a we got a and a space I think that's a space and then we got A3 A5 a so can I remove internal
• 87:30 - 88:00 lines lines a good lines yeah Green lines okay you can just select all press shift and select all okay and then you got a property for it called frame you can push those buttons and set it to num okay and then you don't have good lines and what if I want water line okay I it's okay we can yeah it's
• 88:00 - 88:30 the same way back if you want water lines just conf frame and set set it to outline then you have out very nice here we
• 88:30 - 89:00 go and pretty should we take a sub report not directly take up something like a sub report but it's not the same like a nested Report with arguments and stuff like this only with visual visual components goog will also do this we'll we'll we don't need a sub report in this but you've got other possibilities we'll you will show us how to do that of
• 89:00 - 89:30 course so the last thing that we can do is to include another report so if you're working at a customer you will have the problem that all lists all we ports should look like the same so maybe you always want a company logo in
• 89:30 - 90:00 the upper