1
00:00:00,180 --> 00:00:08,179
Well, today we are going to explain reports.

2
00:00:08,179 --> 00:00:20,179
If you want to print a query or if you want to print a table, you can do it from the LibreOffice base.

3
00:00:20,179 --> 00:00:26,179
So you must create a report in order to print these data.

4
00:00:26,179 --> 00:00:40,679
Nowadays it's not so necessary because we usually send the files, but in any case it's a good idea if we know how to print our work.

5
00:00:40,679 --> 00:00:52,979
So, as you have in Forms, you can have two different ways to do the reports.

6
00:00:52,979 --> 00:00:58,979
You can create a report in Design View or you can create a report using the Assistant.

7
00:00:58,979 --> 00:01:02,979
Obviously, it's easier if you use the Assistant.

8
00:01:02,979 --> 00:01:12,980
What we usually do is, firstly, we use the Assistant and then, with the Design View,

9
00:01:12,980 --> 00:01:21,980
change the things that we want.

10
00:01:21,980 --> 00:01:26,980
So we are going to begin using the Assistant.

11
00:01:27,700 --> 00:01:31,040
I click in Assistant, and it's more or less the same

12
00:01:31,040 --> 00:01:34,799
that we have already set, we have already have

13
00:01:34,799 --> 00:01:37,640
in Queries and in Forms.

14
00:01:37,640 --> 00:01:41,299
You have a formula, the first thing that you should do

15
00:01:41,299 --> 00:01:46,299
is choose from what, from which you want to create

16
00:01:46,299 --> 00:01:50,739
from which you want to create your report,

17
00:01:50,739 --> 00:01:54,739
for example, this table, client's table.

18
00:01:55,799 --> 00:02:00,799
Then you must choose the fields, as always,

19
00:02:00,900 --> 00:02:02,159
and maybe all of them.

20
00:02:04,280 --> 00:02:09,280
Next, in this case, you have the different fields here.

21
00:02:09,280 --> 00:02:18,800
a difference the difference fields here you can do grouping if you want

22
00:02:18,800 --> 00:02:24,800
a group the the the fields when you want for example a group client

23
00:02:27,840 --> 00:02:28,719
enterprise

24
00:02:28,719 --> 00:02:47,990
and name of contact, for example, and here you can always do the order, ascending or

25
00:02:47,990 --> 00:02:54,110
descending, taking into consideration one field, for example, we are going to do ascending

26
00:02:54,110 --> 00:03:31,860
this one, the client code, just one, just two times, now you want to, it's your choice,

27
00:03:31,860 --> 00:03:44,539
you must choice if you want tabular, columnar, or in blocks, level above, or in blocks, level

28
00:03:44,539 --> 00:03:52,699
left what you want is it's landscape or portrait as you want we're going to choose for example portrait

29
00:03:53,740 --> 00:04:04,060
um in blockslaveslave for example and then next we must to to give a name to our report

30
00:04:05,180 --> 00:04:12,539
and finish well here you have if you want to create the report now or you also can modify

31
00:04:12,539 --> 00:04:19,100
the report I have created so this is the result this is the result of your report

32
00:04:19,100 --> 00:04:29,300
maybe it's not what you want because here is you have the client and then the

33
00:04:29,300 --> 00:04:38,660
difference the difference the difference data of the tables maybe you you want

34
00:04:38,660 --> 00:04:50,160
change those time changes so as we have already done in the forms but here is

35
00:04:50,160 --> 00:04:56,980
easier because in forms we can do a difference operation we can add it

36
00:04:56,980 --> 00:05:04,420
macros in order to do processes in a report you can't do any processes

37
00:05:04,420 --> 00:05:10,540
because it's just to print, so it's the result of something, you can change

38
00:05:10,540 --> 00:05:16,180
anything, you can change for example if you want to add it

39
00:05:16,180 --> 00:05:22,160
a header, yes for example if you want to add a header you can change it a

40
00:05:22,160 --> 00:05:34,610
header, and add it for example, insert for example page numbers or date and time

41
00:05:34,610 --> 00:05:51,620
for example or the change the footer so for example you can change

42
00:05:51,620 --> 00:05:58,579
the format you can change the format of the chain or the page you can change for

43
00:05:58,579 --> 00:06:07,120
example the size of papers, you can change the... it is portrait of landscape,

44
00:06:07,120 --> 00:06:18,250
margins, the background for example if you want to change the color, you can

45
00:06:18,250 --> 00:06:26,370
change for example the content in the page header if you want to

46
00:06:26,370 --> 00:06:33,910
added something, well, you have the page number, you have added it in the page

47
00:06:33,910 --> 00:06:42,649
header, page number, but you, for example, if you want, you can insert,

48
00:06:42,649 --> 00:06:50,529
well, here I have also reports color, for example, you can add it if you

49
00:06:50,529 --> 00:07:27,029
want a charge, Imagi, Testbox for example and in Testbox clients or maybe

50
00:07:27,029 --> 00:07:40,750
different structures or functions or the name of what you want to do to having

51
00:07:40,750 --> 00:08:15,480
the font for example you want to change the font or what you want

52
00:08:15,480 --> 00:08:23,399
or in a footer the same if you want to add it for example in the footer you can

53
00:08:23,399 --> 00:08:46,440
add it or delete or insert report header and footer or for example I'm going to

54
00:08:46,440 --> 00:09:04,149
try to insert here date well you also have macros if you want to run a macro

55
00:09:04,149 --> 00:09:15,399
here but indeed what you want for example we are going to do insert here

56
00:09:15,399 --> 00:09:36,500
the date and the date it's the height of footer breakdown is transparent or no

57
00:09:36,500 --> 00:09:59,820
for example the color of the footer you can change the color of the footer what

58
00:09:59,820 --> 00:10:16,419
you want to print or well the main idea is that you can change something for

59
00:10:16,419 --> 00:10:27,940
example if you choose here this is the content for example you can change the

60
00:10:27,940 --> 00:10:45,899
font you must change something in order to know a small training of this

61
00:10:45,899 --> 00:10:52,960
it's not important because in this level the only thing that you have to know

62
00:10:52,960 --> 00:11:00,940
that reports exist and how to do a report and reports are not so important

63
00:11:00,940 --> 00:11:13,899
nowadays because just only to to print something and it is the end of office software the next is

64
00:11:13,899 --> 00:11:15,159
a magic