Print Self Formula with airSlate SignNow

Print self formula

for this video we're gonna learn how to use the quick report editor to change things we're gonna move our database to a Mac first we'll exit for D then we'll copy our first database onto a file exchange and then we'll switch to a Mac on the Mac will find the file that we transferred on Windows exchange which is actually a package whose contents can be displayed the contents contain the structure the data the index files and so on to start an application on the Mac you can drag either the 4d base file or the four DB file like you do on Windows let's drag the file onto an instance of 40 B 13 on startup without any conversion whatsoever taking place we'll see the window as we programmed it with the possibility of seeing all the technicians all the interventions and so on the main interest in establishing a database is to store data for the moment we've done this by displaying data on-screen in a form that was predefined by the programmer however in many cases your users may want to adapt their data extractions the particular needs not specified in the specifications or on an ad-hoc basis the quick report editor quickly meets this need you can use it to display data from the current selection in other words the results of a previously performed query you can open the quick report editor from the toolbar or by programming it we're gonna copy the contents of the query button and insert it into the report button while replacing query with QR report QR report technicians character one true true true which takes five parameters the table name the document name or a compressed character one so that it displays the standard quick report editor then three more parameters that we're going to set to true the first allows hierarchical navigation using relations the second allows for a wizard and the third lets you perform a complimentary search and the quick report editor of course we're also going to adapt the technicians table we click on the technicians button all then report the screen consists of four areas the top part with a menu bar toolbar and a gray rectangle for configuring the columns the green area where you can choose the table perform a query set the report type or open the wizard the fields column for the selected table and the column for sort orders to quickly produce a report double-click on the names of the fields they will appear in the upper part then choose print preview either using the button or from the file menu on Mac awareness print previews are automatically done in PDF and on Windows they are an XPS to choose the sort order drag one or more fields to the sorting area you you'll notice that a subtotal row is displayed in the area for each sort criteria that you add in subtotal rows you can add summary calculations by right-clicking on the intersection where the row and column meet to go further using this editor we're going to change pages and display the list of interventions we can perform a search before using the quick report editor but we can also do so directly from the editor the calculation that we're going to perform concerns a number of interventions made by technicians for a given period so first we're going to search the interventions for the desired period for example December 2011 intervention dates past 1 1211 intervention dates before 31 1211 in the query we get 314 records out of 11,000 732 now we double-click on technician initials added to the upper part of the screen an object if we print the form as it now stands we'll get a list of 314 records for December 2011 but what we want is to get the number of interventions for each technician so first of all we need to sort by technician by dragging the technician initials field into the sort area a subtotal line is added to the upper part of the screen where we can add calculations we also drag the object field as the second sort criteria which lets us get the distribution of interventions per technician a second subtotal is also added printing will give us the same list as before but sorted by the specific criteria since we have not indicated anything the subtotal rows they do not appear on the screen to count the number of interventions just right-click on one of the columns in the technician initial subtotal row and choose count when it's printed this row now appears with the number of interventions for technician 44 interventions for the same technician we can do the same thing for the object subtotal row and we get 10 training sessions then 9 and so on for a total of 44 interventions for the technician you the detail rose don't really concern us we can right-click on the title of the detail row to hide it only the subtotal rows are printed to indicate that the body is hidden its row is filled in with a gray grid during printing we can see the distribution but since we have hidden the detail row we can no longer see which technician and which object go with these values to find out we can just type the hash symbol in the subtotal rows let's begin with the technician we can now see the name of the technician next to the number of interventions we can do the same with the object first click second click hash when we print it we can see that it now corresponds to what we wanted the number of interventions divided by the type of intervention and with a total of each technician the quick report editor is a powerful tool where we can add modify columns perform program calculations and then send the resulting reports not only to a printer but also for example to a disk file you a system dialog box lets you name your file and choose its location we find the export and if we open it with a text editor or a spreadsheet the information is all there