LibreOffice-Suite-Base/C2/Create-reports/Khasi

Time	Narration
00:00	Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”
00:03	Ha kane ka jinghikai, ngin ia pule kumno:
00:07	Ban shna ia ka “report”. Ban Select, Label bad Sort ia ki report fields.
00:12	Jied ia ka report layout bad jied ia ka jait report: static lane dynamic.
00:19	Na ka bynta kane, to ngin ia peit ia ka nuksa jong ka “Library” database.
00:27	Hangne, ngi lah buh ia ki jingtip shaphang ki books bad members ha kane ka Library database.
00:36	Ngi don ruh ia ka “table” ban khmih ia ki books ba la ai sha ki members.
00:42	Ngi lah pule kumno ban shna ia ka “form” bad queries ha ki jinghikai kiba hashwa.
00:48	Shwa ban pule kumno ban shna ia ka “report”, to ngin ia pule shwa kaei ka report?
00:56	Ka report kadei kawei pat ka rukom ban sei ia ki jingtip na ka database, kumba long ka “query”
01:05	Ngi lah ban customize ia ka layout, ka dur bad jinglong jong ka khnang ba kan long kaba suk ban pule lane print ha ka kot.
01:14	Ia ka “Report” lah ban pynmihna ka database “table” lane queries.
01:21	Ki lah ruh ban don ia baroh ki fields ha ka table lane ha ka query lane tang ki kynhun jong ki field ba la jied.
01:32	Kidon ar tylli ki bynta jong ka report- “static” bad “dynamic”.
01:38	Man ba plie ban peit ia ka “Static report”,
01:42	Kan sa pyni barabor ia kajuh ka data kaba don ha kapor ba shna ia ka report.
01:48	Ia kane la tip ruh kum ka snapshot.
01:52	Hynrei ka “Dynamic report” ka pyni ia ka data ba dang shen na ka database, man ba plie ban peit ia ka.
02:00	Te, mynta, to ngin ia shna ia ka sample report.
02:05	Ha ka ‘Library’ database,
02:08	To ngin nion ha “Reports” icon ha ka panel ba sha kadiang.
02:12	Ha ka panel ba sha kamon, to ngin nion ha ‘Use Wizard to create report’.
02:18	Kane kadei ka opshon kaba suk bad ba kloi ban shna ia ki report.
02:24	Mynta ngi iohi ia ka window kaba thymmai kaba la khot ruh ka “Report Builder” window
02:31	Bad ngi iohi ruh ia ka wizard ryngkat bad ki 6 tylli ki step ba la lis ha ka liang ka diang.
02:39	Ngin ia peit ia ka wizard ban shna ia ka report kaba shong nongrim halor ka query kaba ngi la shna ha ka jinghikai kaba hashwa.
02:47	'History of books issued to the Library members’.
02:51	Ngi don ha ka “Step 1 – Field Selection”.
02:56	Ngin ia pynbeit ban buh ia ka tynrai jong ka report data hangne: da ka table ne query.
03:05	To ngin ia jied ia ka “query: ‘History of books Issued to member” jong ngi na ka drop-down lis kaba hajrong.
03:14	Mynta ngi iohi ia ka lis jong ka available fields na ka query ha ka liang kadiang.
03:21	Ngi kwah ia baroh ki field ha ka report jong ngi; te ngin shu nion beit ha u khnam ba don ar tylli uba phai sha ka liang kamon.
03:30	Mynta to ngin nion ha u “Next” button ban leit sha ka step kaba bud.
03:35	Step 2. Labelling Fields.
03:39	To ngin type ia ka descriptive label ba harum ha ka label text-box kumba la pyni ha ka dur.
03:50	Te, to mynta ngin nion ha “Next” button.
03:55	Ngi don ha ka “Step 3 – Grouping”.
03:59	Ia kane la pyndonkam man ba ngi donkam ban group ia ki data da ki set jong ki fields ba ngi la jied.
04:05	Kum ka nuksa- ha ka report jong ngi, ngi lah ban group ia ka data da ka “Book title”.
04:12	Lada ngi leh kumta, ngin sa iohi ha ka report jong ngi ia ka book title nangta baroh ki member kiba la ai ia kine ki kot.
04:22	Nangta ngin sa iohi ia ka book title kaba bud, bad kumta ter ter.
04:27	Ia mynta, to ngin ieh ia ka report jong ngi ha ka rukom kaba suk.
04:31	Te, ngin ia nion ha u “Next” button.
04:36	Mynta, ngi don ha ka ‘Step 4 – Sorting Options’.
04:41	To ngin ia sort ia ki data ha ka chronological order.
04:46	Bad nangta sort ia ka da ka Book title ha ka ascending order.
04:52	Na ka bynta kane, ngin ia nion ha “Sort by” drop-down box
04:58	Bad nangta nion ha “Issue Date”.
05:03	Nangta ngin nion ha ka drop-down box ba ar
05:08	Bad nangta nion ha u “Book Title”.
05:12	Mynta, to ngin nion ha u “Next” button.
05:16	Step 5.- Choose Layout.
05:20	Ngi lah ban customize ia ka dur bad jinglong jong ka report hangne.
05:25	To ngin nion ha “Columnar, single-column” layout lis.
05:31	Phin iohi ba ka “Report Builder” ba shadien ka lah pyn thymmai ialade.
05:36	Ka pyni ia baroh ki label ha ka liang ka diang bad ki fields ba iadei sha ka liang kamon.
05:43	To ngan jied ha ka “Columnar, two columns”.
05:48	Sa shisien ka window ba hapoh ka lah pynthymmai ban pyni ia ar tylli ki column layout.
05:54	Ha kane ka rukom, ngi lah ban jied ia kano kano ka layout kaba ka “Base Wizard” ka ai.
06:02	Ngi lah ruh ban pynkylla ia ka hadien katkum ka jingdonkam jong ngi.
06:07	Ia mynta, to ngin nion ha ka item ba nyngkong – ‘Tabular’
06:12	Bad nion ha u “Next” button.
06:16	Te, ka step ka ba khatduh – ‘Create Report’.
06:20	To ngin ai ka kyrteng ba jrong ia ka report jong ngi hangne: “Books Issued to Members: Report History”.
06:30	Mynta to ngin pynwandur ia ka report jong ngi khnang ba ka report kan ai ia ngi barabor ia ki data kiba thymmai na ka database.
06:38	Na ka bynta kane, to ngin nion ha “Dynamic Report” opshon
06:45	Kumba ngi kwah barabor ban ioh ia ka data ba thymmai, man ba ngi plie ban peit ia ka report.
06:52	Te, ngi la dep bad ka “Report” jong ngi. To ngin nion ha “Create Report now” opshon
06:59	Bad khatduh nion ha u “Finish” button.
07:05	Mynta ngi iohi ia ka window ba thymmai bad kane kadei ka “Report” kaba ngi shna mynta.
07:12	Phin iohi ba kadon ia ka field label hajrong, ha “bold” font bad ki data badei la lis ha ka rukom tabular
07:24	Bad phin iohi ba ka lah sort da ka “Issue Date” field ha ka ascending order kata, chronologically bad nangta da ka ‘Book Title’ ha ka ascending order.
07:38	Da kumne ngi lah shna ia ka chronological report jong ka kot ba la ai sha ki “Library” members.
07:46	Ha ka jinghikai kaba bud, ngin ia pule kumno ban pynkylla ia ka report jong ngi.
07:52	Hangne ki kam na ka bynta jong phi:
07:54	Shna ia ka report jong baroh ki kot ha ka library bad group ia ki da ki “Publishers” jong ki.
08:01	Baroh ar ki “Publishers” bad “Book titles” dei ban long ha ka ascending order.
08:07	Pyndonkam ia ka “Columnar, Single-column” layout.
08:11	Da kane ngi la poi sha kaba kut jong kane ka jinghikai halor ki “Reports” ha ka “LibreOffice Base”.
08:17	Ban kyllum lang, ngi la pule kumno:
08:21	* Ban shna ia ka Report
08:22	* Select, Label bad Sort ia ki report fields
08:25	* Jied ia ka report layout
08:26	Bad * jied ia ka jait report: static lane dynamic.
08:31	“Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project, la kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
08:42	Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org.
08:48	Kham bun ki jingtip halor kane kidon ha ka link harum.
08:51	Ia kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad ma nga u Pdiangburom na Shillong nga pynkut ia kane. Khublei shibun ia ka jingsnohkti lang jong phi.

Contributors and Content Editors

Pdiangburom, Pratik kamble