1 00:00:01,300 --> 00:00:04,089 a local taxes 2013 sheet or lose in this video 2 00:00:04,089 --> 00:00:07,730 I'm gonna show you how to I'm at a subir por 3 00:00:07,730 --> 00:00:11,309 into a manger for if that's the right terminology so 4 00:00:11,308 --> 00:00:14,699 for the pylon for the link below the video to do them a sex the website and 5 00:00:14,699 --> 00:00:16,429 download access 2013 6 00:00:16,429 --> 00:00:19,948 the B-twenty and if not 7 00:00:19,949 --> 00:00:24,740 in a boo 8 00:00:24,739 --> 00:00:28,649 prior the report I have is for 9 00:00:28,649 --> 00:00:32,159 cast and forget to print preview 10 00:00:32,159 --> 00:00:36,319 you can see we got some empty space found here and what I wanna add into 11 00:00:36,320 --> 00:00:36,738 that 12 00:00:36,738 --> 00:00:40,468 is report booking details by guests up 13 00:00:40,469 --> 00:00:44,140 I am however 14 00:00:44,140 --> 00:00:47,619 I'm gonna do that logo feeling it's gonna look 15 00:00:47,619 --> 00:00:51,320 a bit strange because there's going to be a white space but but do anyway 16 00:00:51,320 --> 00:00:54,340 a consumer report best activity traffic to lay out for you 17 00:00:54,340 --> 00:00:57,800 and click in the 18 00:00:57,799 --> 00:01:01,509 bottom most part it proper to design the he 19 00:01:01,509 --> 00:01:04,890 and click in the bottom most empty cell 20 00:01:04,890 --> 00:01:08,560 range insert below insert below 21 00:01:08,560 --> 00:01:12,400 and I'm select 22 00:01:12,400 --> 00:01:15,920 quicken the no actually Bama so in the detail section select 23 00:01:15,920 --> 00:01:18,978 row and merge now we've taken it to 24 00:01:18,978 --> 00:01:22,219 is click on report booking details by casting just drag it 25 00:01:22,219 --> 00:01:25,829 to hear weekend 26 00:01:25,829 --> 00:01:31,420 could really work so well if it done 27 00:01:31,420 --> 00:01:35,259 more it's time for me which is as an exit places so fear just click on a 28 00:01:35,259 --> 00:01:36,109 click on the 29 00:01:36,109 --> 00:01:39,819 that opaque square here and a straight 30 00:01:39,819 --> 00:01:45,798 into where we want to be minister to suck okay 31 00:01:45,799 --> 00:01:49,490 sOooo action us 32 00:01:49,489 --> 00:01:53,339 paldon casick 02 and I'm 33 00:01:53,340 --> 00:01:57,368 report the first two okay so we've added 34 00:01:57,368 --> 00:02:00,489 the I booking details subir por 35 00:02:00,489 --> 00:02:03,658 in the ones doing at the moment displaying every single 36 00:02:03,659 --> 00:02:07,359 booking detail for every single guest 37 00:02:07,359 --> 00:02:11,989 because we haven't specified link between the two if 38 00:02:11,989 --> 00:02:15,900 reports so drop into that we should be fine click anywhere 39 00:02:15,900 --> 00:02:19,730 in the summer for and then click on that Luke Ross here 40 00:02:19,729 --> 00:02:22,859 press f4 started detente 41 00:02:22,860 --> 00:02:26,739 and pay we need to link the guest by the firm 42 00:02:26,739 --> 00:02:30,099 the guest activity report a case study from the book your fault 43 00:02:30,098 --> 00:02:34,949 click on the ellipsis is actually worked out for those two fields can 44 00:02:34,949 --> 00:02:39,039 should be linked so per se que and now we've done that 45 00:02:39,039 --> 00:02:42,840 I am if we go to Print Preview 46 00:02:42,840 --> 00:02:46,110 Rican see the 47 00:02:46,110 --> 00:02:50,680 this guest I'm checked in this state checked out on that day 48 00:02:50,680 --> 00:02:53,689 and this explains the situation and 49 00:02:53,689 --> 00:02:56,780 charge benign the cost but we haven't 50 00:02:56,780 --> 00:03:00,128 of a white space the so now looks pretty enough 51 00:03:00,128 --> 00:03:03,628 sought miss do with that 52 00:03:03,628 --> 00:03:10,628 I am us through nests moved to hope the tail section down a little bit previous 53 00:03:10,969 --> 00:03:12,009 to do that and 54 00:03:12,009 --> 00:03:18,649 to sign the 55 00:03:18,650 --> 00:03:23,439 that's number one I am speak a little bit what space there 56 00:03:23,439 --> 00:03:27,599 the next thing I think actually if we're going to do this property were gonna 57 00:03:27,599 --> 00:03:28,389 need to 58 00:03:28,389 --> 00:03:33,259 go to for booking details by gesso enough to reduce somewhat 59 00:03:33,259 --> 00:03:36,859 so we need to do units take the check out a 60 00:03:36,860 --> 00:03:40,820 we're going to need to try can put it below check in date we have to do 61 00:03:40,819 --> 00:03:41,639 something with 62 00:03:41,639 --> 00:03:47,589 what we've called cost and free choice 63 00:03:47,590 --> 00:03:54,590 you not go to report view checkin checkout 64 00:03:54,759 --> 00:03:58,810 okay so the the concept is correct for the execution is bad because 65 00:03:58,810 --> 00:04:03,110 cover for former 66 00:04:03,110 --> 00:04:07,390 grid line style poem put mu transparent 67 00:04:07,389 --> 00:04:11,339 click on cost grid lines tho poem 68 00:04:11,340 --> 00:04:15,560 solid and just tractor 69 00:04:15,560 --> 00:04:21,089 so more or less covers the entire page I'm not quite good at designing view 70 00:04:21,089 --> 00:04:24,199 all that in okay so 71 00:04:24,199 --> 00:04:27,680 less 72 00:04:27,680 --> 00:04:31,439 also Turner trying to do so pillow 73 00:04:31,439 --> 00:04:36,040 cakes a save and close to now let's try report guess the activity 74 00:04:36,040 --> 00:04:39,660 knowing lines that 75 00:04:39,660 --> 00:04:45,350 Print Preview the 76 00:04:45,350 --> 00:04:49,890 it's not 77 00:04:49,889 --> 00:04:54,930 it's not a classic not a classic by any means 78 00:04:54,930 --> 00:04:58,340 the strip it down a bit more this all this is just 79 00:04:58,339 --> 00:05:01,859 forming an who depends on how 80 00:05:01,860 --> 00:05:08,860 funny you all about where you wanna see in your folks 81 00:05:10,290 --> 00:05:14,450 but missed just make on law stuff to get it looking nice 82 00:05:14,449 --> 00:05:21,449 K 83 00:05:21,569 --> 00:05:25,899 I'm opposed to 84 00:05:25,899 --> 00:05:29,879 and forecasting to the Print Preview 85 00:05:29,879 --> 00:05:33,589 I want everything we can to 86 00:05:33,589 --> 00:05:37,569 its the scattered at the port of 87 00:05:37,569 --> 00:05:41,240 on the for 88 00:05:41,240 --> 00:05:44,918 up booking details broadcast 89 00:05:44,918 --> 00:05:49,219 transparent now for go to print preview you get this 90 00:05:49,220 --> 00:05:56,220 what is that too in there and lost time 91 00:05:58,290 --> 00:06:01,780 from miss if the something with this ports 92 00:06:01,779 --> 00:06:05,269 talk around online shown up staff 93 00:06:05,269 --> 00:06:11,099 occur to the state one must look to the basically done 94 00:06:11,100 --> 00:06:18,020 so the actual way of getting the I'm sup report into the main report was my show 95 00:06:18,019 --> 00:06:20,439 you about three hours ago but has since then been 96 00:06:20,439 --> 00:06:24,889 formatting so if you stayed with me expected see something amazing 97 00:06:24,889 --> 00:06:29,550 I'm well be disappointed but there they go there is the 98 00:06:29,550 --> 00:06:34,910 report I am those the details at the guest is 99 00:06:34,910 --> 00:06:38,150 the basic details have any bookings the guest has attended 100 00:06:38,149 --> 00:06:43,959 there's a huge amount of white space not really much we do about that moment 101 00:06:43,959 --> 00:06:48,439 I'm so those as the reform we're gonna be looking at is a pretty next video how 102 00:06:48,439 --> 00:06:49,478 to put that into 103 00:06:49,478 --> 00:06:52,459 he actually Davis ok thank you for watching incident