Home

Donor manual

1. Region OrderYear _ a gt Another subtle hint is the spacing in the Grouping window with Group1 no longer being indented iliii Column Groups TO ne Column Groups ye ee Co This exercise assumes that you have completed Exercise 7 The images show the Gauge from Exercise 7 but is not required to complete this lesson just the core Tablix Modifying the Tablix to Enhance Functionality To modify the Tablix perform the following steps 1 2 Open the report SalesbyRegion_Ex7 rdl you previously created Delete the OrderYear sub group Delete this group to add it as a second grouping at the end of the matrix and not as a sub grouping within the matrix To do this select the drop down menu to the right of the OrderYear sub group name Ez in the Grouping window thenselect Delete Group For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Region Add Group Add Total Delete Group Group Properties Figure 37 Delete OrderYear group 4 Select Delete group and related rows and columns in the Delete Group dialog box Delete group options Delete group and related rows and columns C Delete group only Your Tablix will now resemble the following figure Total 12 345 00 aan el
2. All Projects SLAF Coormnators gt a El Choose municmalitias No Selection Project Sector Project Type Save Selected Municipalities Documents Concept Note Selected documents Study General Propect Ce Prefeasibmty Study Preliminary Project Feasibility Study fan sectors all types Delete Investment Value im mil Euros i weim Total number of projects by sector and type with investment value stabistics List of all projects sorted by municipality This report displays project documentation for SLAP propects This report displays financial sources for SLAP projects List of all projects sorted by municipality This report displays project documentation for SLAP projects This report displays financial sources for SLAP projects This reports displays overview of projects Choose sector level or minimum points for projects Choose template SLAP 2 0 Information Syst Select storing method SLAP Scoring Methodology Select a project level all Levels Select min pomts 0 100 io ooo List of different investment needs for the projects Total Project Cost Project Preparation amp Permitting Design Tander and Contract Civil Works Equipment amp Machinery Construction amp Supervision Start up Technical assistance List of all project submitted in SLAP information system This report displays SLAP coordinators data For detailed info
3. Ar SLAP 2 0 Information System User manual TABLE OF CONTENT 1 MG 2 1 Introduction to SLAP 1 MG 2 2 SLAP Access 1 MG 2 3 SLAP Filtering and Reporting System 1 MG 2 4 Custom Report Creation 1 MG 2 5 Project Data Input For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Introduction to SLAP The SLAP has been developed as a joint project of the SCTM Standing Conference of Towns and Municipalities and the MISP project Municipal Infrastructure Support Programme funded by the European Union and managed by the Delegation of the European Comission to the Republic of Serbia The SLAP project has started in 2006 and it was launched with the aim of helping the municipalities in infrastructure project development During the 3 years of its existance first within the MIASP project and later within the MISP project the SLAP has been constantly developing and changing adapting to the needs of the municipalities relevant ministries as well as of the association of donors As a result of these changes today we have a modern fully automatic information system SLAP 2 0 which we believe will play a significant role in municipal infrastructure project development in the future SLAP is as we have already mentioned an information system more precisely a web application wit
4. Hew Table or Matrix Choose the layout If you choose to show subtotals and grand totals you can place them above or below the group Stepped reports show hierarchical structure with indented groups in the same column Options Preview Show subtotals and grand totals Region Blocked subtotal below Orderfear Total Blocked subtotal above Stepped subtotal above Expand collapse groups Cancel Figure 9 Select the Visual Layout Type 2 Click Next to proceed to the Style selection 3 Select the style For the purpose of the exercise we use the default Ocean style From the wizard screen it is possible to modify the colors and the fonts even after wizard is complete For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual New Table or Matrix Choose a style Styles feature different fonts and color schemes but do not affect the basic layout You can customize the style after you finish the wizard Preview Styles Corporate s Region Forest Generic Order ear Total oat Slate Figure 10 Select a Color Style 4 Click Finish to complete the wizard and view your new report Your report will look like the following figure For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project
5. b From the Group Properties dialog select the Visibility page c Set When the report is initially run to Hide d Select the Display can be toggled by this report item check box and select Region1 from the drop down list The 1 is important as in the list where Region1 AND Region both appear and Region is the instance from the first Tablix e Click OK 13 To run your report click the Home tab and click the Run or press F5 Other than a few formatting properties such as colors and size the two Tablix report items are the same For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org SLAP 2 0 Information System User manual Accessoanes Bikes Components Total 15897306 9833 45000716 7241 7220537 9250 68178501 0324 Europe North Pacific Total Sub Category1 Total Total Total Total 320970 8725 681086 9944 1626645466 11647244155 Total 13636196 4470 37436536 6641 67405907604 57615325 6715 Total 355739 6391 1147986 3374 113491 5624 1617219 5359 Total 1584398 0247 5793102 7282 203791 0536 7581291 8065 15897306 9833 450607167241 220537 9250 661 6561 6324 Figure 45 Completed Tablix tl Save your report to the server To save your report on the server perform the following steps 1 Click the Report Builder icon then select Save As 2 Select the My Reports folder if present on your
6. click on the Proceed anyway button E G pe wg The site s security certificate is not trusted Pou were fe cee bs ere eg be eee ede g eet te eed bo ey et ed ee Pr pee ee ee eee ple Thee maj eee eed Hee ere fa gee to er dees cit Ste Gog heen cee ely ete ep ee a ey bag la de eg pet ee ee Tee ba Ber pried paiay i pis ees pea tee eg orate barbies hee chee cr Figure 1 6 Google Chrome The computer screen with the Security Alert popup window For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual If you are not sure how to solve the problem with the Security Certificate you should contact a person in charge of the IT support in your Municipality This is necessary only with the first access to the SLAP system while every other attempt to log in will be simple For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual In case you accessed the SLAP system successfully you will see the front page of SLAP which is given in the figure 2 0 On the top of the page there is a welcome message and below it you will see the log in window In order to access SLAP it is necessary to have a user name and
7. or both and choose values to display Data expands across the page in column groups and down the page in row groups Use functions such as Sum Avg and Count on the fields in the Values box Available Fields H Column groups Product Categor SubCategory Crdervear OrderQtr SalesAmaunt Territory Region E ee ee Order vear Row groups E Values ProduckCategary SumtSalesamounth SubCategory Figure 8 Arrange fields in the Wizard to Specify Groups and Values If you drag a field to the wrong location you can fix this by dragging it from one definition box to another or to the white blank space in between them to remove it 2 Click Next to continue Selecting the Layout and Colors 1 Select the visual layout For this exercise use the default Blocked subtotal below layout We recommend clicking the other options to understand the options available with the wizard based on the preview For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org SLAP 2 0 Information System User manual The Expand Collapse groups checkbox builds the report with group headers and totals shown but the detail rows will be hidden by default However the report will show symbols on the groups to allow you to expand and see the detailed rows while running or previewing the report E Bikes Mountain Bikes Foad Bikes
8. you will e View your report from Report Manager using Internet Explorer This exercise assumes that you have completed Exercise 4 Viewing the Report from Report Manager To complete this exercise follow these steps 1 Open Internet Explorer and type in the URL to the report manger of http localhost Reports then press ENTER 2 Click My Reports to open the folder 3 Click the SalesbvResion ex4 report or the name you Saved it as Fal SalesByRegion ex4 Iwew Your report looks like the way you saw before when you ran it inside Report Builder 2 0 E Report Manager Windows Internet Explorer provided by SSRS Report Authoring Sele i T E JAn R Pages Folder aspx S 4 xX fe Searcl pi ey 5 ie ir air Report Manager a H mn Fh Page GF Tools Home My Subscriptions Site Settings Help T SOL Server Reporting Services tl P F Hone p 2 Search for o B Properties Ci New Folder New Data Source 4 Upload File Report Builder Show Details D My Reports 0 Users Folders Use this folder to store personalized reports Figure 15 Report Manager For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System S Report Manager Windows Internet Explorer j oj xj go X http localhost Reports Pages Report aspx ItemPath 2FMy Reports 2FSal
9. KODMCHMLUM 2 OCHOBHE MHOpMauH je O Npajecty El i Moofinemut n mataa Koja ce Baen npojeKar E 2 KODHCHUH Mpojexta 3 OMHE NDOJEKTA HEPOBE MOKAUHJE H T IABHHK KOMNOHEHTH 4 Nase pesay Nath MpOJEKTa H KOPMCTH OA MCTOr 5 Dpeyevieno speme Tpajae a npojeera 6 NoTpeGa 2a aCMeTeHUMIOM Moh MENTE Kaen GM ce yHEnpe AMO paseo npojerTa 3 ODYWTS HO ExDHOMCHIA MHAKKATODH OD eHba Y HOME Ce NPOjeKaT passoja i AP uwTBeHO eKOHOMOKM MH AMKATOpM paseoja ONLUTHHE A 2 POAMUUHH NAROA Of sarahweaua 9 POAMUEH HASH 3a SELUTHTY KHBOTHE CpeaMHa 4 CT athe NPOJEETHE AOKYMBHT ALM je 1 CTaHe NDOJEKTHE AOKYMeHT ALi je EJ i CrygMja 2 Pevepanhu Npojecar Mactep MNaH A 3 peta AHA Cry nja ONpaBAaHaTTA 4 Haejh Npojekart E a CTYAM a HOBOALHEOCTH 6 Chase npojexar F TeHAeptKa JOCK MeHT aL ja For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual The SLAP questionnaire consists of 170 questions divided in 17 groups 1 Basic information about the institution which developed the project 2 Basic information about the project 3 Socio economic indicators about the environment of the project development 4 Project documentation status 5 Project frame 6 Physical components of the project 7 Project users 8 Other expected positive effects 9 Project costs 10 Logical frame matrix 1
10. clicking certain questions one can see the answers given by the municipality By clicking the Show report button one can download a PDF questionnaire filled with data Below the table containing project versions there is a forum dedicated to the project which can be used for communicating with the municipality as well as with other donors Ojasen B 1 OCHOBHE MHCbODMaLMje O MHCTHTYUM JA Koja je pazarina npojekaT 1 Hass Mpeanarava npojexra I 2 Tpeanaray npojecta Bd 3 AApeCa EB 4 Ocofa 3a KoHTaKT 5 Octane vecopmaunje Ocobe 2a MOHTaKT i 6 OMUTHHE KOpMCHMLM 2 OCHOBHE MHCbOopMaLM je o npojexty 1 Mpo nemh 4 mTaa KOjiMa ce Gaern npojeraT 2 KOPU MpOjeKTa 2 3 ONC NpOjekTa HerOBe nokayhje n TaBHx KOMMOHEHTH 4 nas Psy NTaTH NPOPeKTa H KOPHCTH O4 MCTOr 2 Ope 4E4heHO speme Tpajarsa npojeetTa 6 NoTpeGa sa acveTeHuMjom koji MeNMTe Kako OM ce yHanpeano paseo npojerTa 3 ODYWTSGHO EXDHOMCHA MHAKKATODH OKDeHba Y KOME Ce NPOjeKaT passoja i APWuwTBeHO KOHOMOKM MH AMKATOpM pazB0ja ONLUTHHE 2 POAMUHM NAROA Of sarahweaua 9 TOAMUHEH HASH 3a SELUTHTY KHBOTHE CpeaMHa 4 CTAA NPOJEETHE AOKYMBHT ALM je 1 CT a8 NPOJEKTHE AOKYMeHT ALi je E 1 Cryaja 2 PexepanHv Mpojerat Mactep Mnax 3 NpetxogHa Cry nja OnpaeAaHociu 4 Haejh Mpojekat 5 CTyAM a HEDA bue0CTH 6 Chase npojexar Ej F TRHASpCKa AOKVMeHT all jA For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko
11. instead of the actual Axis Numbers Value Axis Properties Axis Options A set number formatting options Labels Label Font Category Default sample Number 312 345 Currena Major Tick Marks Percentage Cienki Decimal places iD Minor Tick Marks custom Use 1000 separator Line i E Showzeroas Negative numbers 5 English United States Show symbol after value F Include a space Current regional settings English United States a Figure 23 Value Axis properties Dialog For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 3 In the Value Axis Properties dialog box select the Number pane and select the Currency category 4 Set Decimal places to 0 5 Select the Use 1000 separator check box 6 Select the Show values in check box then select Thousands from the drop down list 7 Torun your report click the Home tab then click Run or press F5 Note the X Axis and the currency format tl Save your report to the server To save your report to the server perform the following steps Fy el at 4 W 1 Click the Report Builder icon then select Save As 2 Select the My Reports folder if present on your local server 3 Enter the file name SalesbyRegion_ex4 rdl Chart Wizard an
12. manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual B Yea ae Untitled Microsoft SOL Server Report Builder _ x Home Insert view kd a A ri Merge ay a a a i Split Run Paste a 1123 8 gt 28 24 sont ta Align gt Views Clipboard Eob E Paragraph E F Number Layout New Edit aa Built in Fields Hi Images i eee r DataSource a E areca ota eaten ruse eecnat estat eetsuetuuineeennatactanaeiatuesmuteecenl Action ES Dataset l E Alignment sE ProductCategory Totals Indent ZZ SubCategory Wl Eor Spaceafter BE Ordervear SpaceBefore Orderotr bs E 5 ales _ Text lign Right E SalesAmount i poe f l z Font E Territory ezian l Color E black E Region i i Font Arial 10pt Def LineHeight General ToolTip Lists ListLevel o ListStyle None Localization E Calendar Default Bica Tamia I Numerallanque E Productcategory i Region Numeralvariant 1 SubCategory 3 Ordervear ail ValueLocID El Number Action Specifies an action associated with the report item Actions include a jump t Shy No current report server Figure 11 Completed Wizard Notice your data source and data set in the Report Data window on the left As you click on the each field in the grouping window it is sel
13. municipalities Sector Name Business Incubator kragujevacsiap Economic Transport TR ALrcireass park Kragupevacsiap Eeorarmn Energy EH Project Tithe Project Owner Eraqujevacsiap Econom Transport TR Local roads bajinabastasiap Ecormomic Transport TR Municipal Solid Wast mnidjjashap Enviromental Ca mannii Pesidental Care vlasotencesiap Social eldenes isabled ets RC viasotinceslap Sacial Sport SP bace ap Enviromental Wastewatoar Wil Shared Bussness bebaneslap Ecoramic Sarvices B5 When you find the project you wish to know more about click the name of the project and the following will be displayed Business Incubator Please choose a template SLAP 2 0 Information Systu Use scania Report Sconng system SLAP Scorng Methodology Version numbor Date enpatod Date modii Sigil ie i Ropar 27 10 2008 06 46 27 10 2008 08 46 Show Report Hore you can add tome comments or questions about this project All of your comments will be visible to project owner Enter your text and press Add button Enter n w post For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual By clicking the number of project version one can access the SLAP questionnaire for the given project containing the answers provided by the municipality Also by
14. preview just like the wizard did Click the Design Tab or press F8 to switch back to Design mode 10 To hide the subgroups but allow the user to toggle them on select Group Properties for Subcategory1 from the Grouping Window ProductCategory1 Region SubCategary1 C Ordervear1 Add Group Add Total Delete Group 11 In the Group Properties dialog box select the Visibility category a Set When the report is initially run to Hide option b Select the Display can be toggled by this report item check box then select ProductCategoryl1 The 1 is important as in the list where ProductCategory1 AND ProductCategory both appear and ProductCategory is the instance from the first Tablix c Click OK For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Group Properties General Change display options Page Breaks Sorting When the report is initially run Show Filters oe gt Show or hide based on an expression Variables Advanced EJ Display can be toggled by this report item ProductCategoryl Cancel Figure 44 Group Properties setting the toggle item 12 Repeat the same changes to the OrderYear1 subgroup a From the Grouping Window select Group Properties for OrderYear1
15. the first page of the electronic questionnaire click on the Save button in order to save the inserted data and continue with further insertion When you do this the table with all the project of the selected municipality which are in the SLAP system will appear on the screen Figure 3 2 If you just started inserting data into the system only one project title will appear in the table For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual SLAP 2 0 Onjanure ce HucdbopmMalllHonn cucTem Cnncaxt CEHA Baus 9 Haran Mpapeier a Haim tektopa Janira RIMOTHE CpenaHe Peraomanicit OOTP Smt CabeTe Janitiitte apote C Seis Umer Gpare Sanimi MHBOTHE CpeqnHe IO WACTS Boge JaITHTA MHBOTHE Cpenhne Maractparns Lesoron SALUT A MHBSTHE CPELHHE Dd jektat peTion An Hor VPA ABA TEDCTUM OTNARGM JAMTHTA KMHBOTHE CPELAHE SSUTHTE MEBOTHE CpenwWe Figure 3 2 Inserting Data Project list To continue with data inserting click on the desired project title in the table When you do this you will see the table with all the questionnaires in the SLAP system at the moment there is only one electronic questionnaire SLAP 2 0 Information system PPD and you can select the questionnaire you wish to fill in by clicking on its title Figure 3 3 AN SLAP 2 0 Cam rre ce HndopMalno
16. to scale Distance from scale Outside Width 5 Figure 33 Resizing the Pointer For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 3 Select the Pointer Fill category and do the following a Select the Solid option for Fill Style b To select the color click the function button at the Color drop down list E e Linear Pointer Properties Pointer Options Set pointer background fill optio Acton iin is 7 77 Fill style Pointer Border Solid SEA TA Gradient C Pattern Pick cobor Color L White L Figure 34 Pointer Fill Style and Color To relate the color with the position of the guess perform the following steps 1 Inthe Expression dialog enter a formula that supplies the following logic for pointer color Red SalesAmount lt five million Yellow SalesAmount gt five million but less than fifty million Green SalesAmount gt fifty million a Delete the default White entry b Copy and paste the following formula into the expression editor iif Sum Fields SalesAmount Value lt 5000000 red iif Sum Fields SalesAmount Valu e lt 50000000 yellow green 2 Click OK For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager
17. you will get similar message as when the web site is not available This message differs depending on the browser which you use therefore we cannot give its full contents here but in one part of the message you will be offered to continue with the access to the web site SLAP despite the risk In Internet Explorer it is enough to click on this link and click yes on the question do you want to ignore the potential risk while in Firefox there are few more steps since the browser requires from you to create an exception rule for the given web address SLAP system address If you use Internet Explorer the SLAP inaccessibility message insecure access is given in the figure 1 0 To access SLAP click on Continue to the website YS Conificate Errori Navipation Blocked Microsoft Intereet Cxoploror provided by SEGO E itp ep ee Mi Lae jes Fpp lane Ol Ae a fe Certiicate Error Maragation Boched x l Vie o ad j Bilem aith Lis wet itm P noe T pyb i i i i a Ly CLA I ae af oot UEL I L inthe carta ti per gered i r We recommend that you chose this webpage and do not continuc to this website c Figure 1 0 Internet Explorer The computer screen with the error message For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org JAT If you use Mozilla Firefox the SLAP inaccessibility mess
18. 06 98 Figure 55 Tablix with the Filter Applied 4 Change your filtering by simply selecting different parameters and clicking View Report Repeat this a few times and view the results tl Save your report to the server To save your report on the server perform the following steps 1 2 Select the My Reports folder if present on your local server 3 Enter the file name SalesbyRegion_ex9 rdl For more information reference the following SQL Server 2008 Online topics Filter Equation Examples Reporting Services For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Project data input Municipalities RDAs If you belong to this user group a neccessary condition for access to the SLAP system and getting a user name and a password is to submit to the SLAP Manager documents on appointment of a SLAP coordinator signed and endorsed by the Mayor You may submit an original copy of the document or send it by fax to the Standing Conference of Towns and Municipalities on a fax number 011 3221 215 After that the SLAP Coordinator in your Municipality will get the user name and password by e mail The user names have the following format MunicipalityNameSlap for example the user name of the Municipality of Ada is Adaslap the user name of the Municipality of Back
19. 1 Indicators 12 Premises and risks 13 Institutional frame 14 Financial sources of the investment 15 Financial sustainability 16 Providing environment protection 17 Arrangements on implementation All the questions from the seventeen mentioned groups belong to one of the three questionnaire levels First level is eliminatory and its purpose is to filtrate the projects which are adequate for SLAP access Second level of the questionnaire consists of the questions which aim to identify the projects suitable for financing the feasibility study Third level of the questionnaire consists of the questions which aim to identify the projects suitable for financing project implementation Filling the questionnaire You dont have to answer questions in the SLAP questionnaire according to their number but you can skip the questions if you don t know the answer to some of them It is not necessary to answer all the questions first time when you enter the data If in one working day you answer 10 questions next time when you log in SLAP you can continue to type from the point where you stopped last time You don t have time limit to answer all the questions If you make a mistake while answering the question you can answer it again and enter the correct answer This regards the situation when some physical component of the project changes during the project development and when it is necessary to answer again the question regarding the c
20. 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System Exercise 1 Getting Started and Getting Familiar with Report Builder User manual In this exercise you will e Launch Report Builder 2 0 RB2 e Get started with a blank design surface for creating a new report e Review the various key areas of the RB2 user interface UI Launching Report Builder 2 0 To launch the Report Builder perform the following steps 1 On the Start menu click Programs then click Microsoft SQL Server 2008 Report Builder 2 0 2 Click Report Builder 2 0 Report Builder 2 0 launches with a blank report as shown in Figure 1 _ _ FN loom Untitled Microsoft SQL Server Report Builder lat 04 SIL EE TCE gt do Merge EE ta lit Run Paste a A A A i eF we HE 13 7 3 E so za Sp nee H Niewes Gipbeant a Align Number Layout co Built in Fields gr Parameters Jj Images i DataElementh Click to add data DataElementS Attribute m Zl DataSchema POSI aN DataTransforr Table or Chart E General Matrix Author Description Width E Localization DescriptionLo amp ExecutionTime Language El Other AutoRefresh 0 ConsumeCor False CustomPrope E Page Backgroundc Automatic karoun
21. AP system you will see on the screen the list of all the projects for which you had started filling in the SLAP questionnaire figure 3 12 If you want to continue with data insertion for some of the projects which you have already started click the name of the project and if you want to start a completely new project click the button New project Hacnop mpojekta Hazne cerktTopa BomocHabmerame Joylteena HHbpactpyeTypa Hoen npojekaT Figure 3 12 SLAP Questionnaire Repeated access to the Questionnaire If you decide to continue filling in the questionnaire for the project you have already started the system will ask you to choose the questionnaire you want to fill and you should choose the same questionnaire as last time figure 3 13 Hsabepute YORTHAK 34 BAN Oo peat CLAN 2 0 Hadopmanuonn crete DTT For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual After this you will see all the versions ot the project on the screen figure 3 14 In the table you will see all the versions of your project If you want to continue filling in the version you have allready started click on the ordinal number of the version in table e g Version 1 The versions which have already been published cannot modify but you can click New version in the table In that
22. After typing your answer in the selected box it is necessary to save it by clicking the button Save After this you will get the system message that your answer was saved figure 3 8 and then click the button OK After this go back to the SLAP questionnaire by clicking the button Back 1 1 Hass peguarava npojexra Microsoft Internet plo er i Baw oarosop je cauyeoy x Figure 3 8 Inserting Data Saved answer You will see again the SLAP electronic questionnaire where the question you have just answered will be ticked green figure 3 9 1 OCHOBHE MHCOpMauMje O MHCTHTYUM M Koja je paserna npojeKar Haske Npeanarava npojeKnta pe Anarad npojektTa 40peca Ocoba 3a KOHTAKT Octane WHboOpMauUlje Ccobe 3a KOHTAKT OLWTMHE KOPHCHHL H 2 OOVWTBEHO EKOHOMCEM HHAMEATODM OKP KEHA Y KOME ce NpOjeKaT pazeoja p 1 QOYLUTEEHO EKOHOMCHH HHAHKATOpH paze0ja ONLUTHHE gt 2 OSM npo Of sara heada Figure 3 9 Inserting Data Answered question For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual After this you can go to the next question e g question 1 2 figure 3 10 LJ i peniaraa mpojekra Dona pocymeat Cayyeal Save Figure 3 9 Inserting Data Answered question Unlike the previous question The name of project p
23. Build a query to specify the data you want from the data source CP Edit As Text Ey Import Database view Selected fields H dbo H 0 HumanResources H Person H Production H Purchasing H 0 Sales Relationships Applied filters Operator Value Parameter Query results Help Figure 6 Query Designer 2 Click Edit as Text to switch the query designer to text mode 3 Select all the query text below copy it and paste it into the query editor At this point we suggest you execute the query to ensure everything is working you can verify this by seeing rows populated in the results pane at the bottom To execute the query press J For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org ANA re eo SLAP 2 0 Information System User manual AAAS Design a query Build a query to specify the data you want from the data source Edit As Text E Import Command type SELECT PC Name AS ProductCategory PS Name AS SubCategory DATEPART ivy SH OrderDate AS OrderYear O DATENAME qq SH OrderDate AS OrderOtr SUM SD UnitPrice SD OrderQty AS SalesAmouht sales SalesTerritory Name AS Territory Sales SalestTerritory Group AS Region Production ProductSubcategory AS PS JOIN Sales SalesOrderHeader AS SH JOIN Sales SalesOrderDeta
24. Creation of a Tablix to Match Exercise 3 Wizard Tablix In this exercise you will e Manually create a Tablix similar to what you used the Matrix wizard for in Exercise 2 This exercise assumes that you have completed Exercise 3 You can also build this on top of later exercises though your images will look different with more objects Alternatively you can create new report and repeat Exercise 3 again Manually Creating a Tablix Similar to Matrix Wizard To manually create a Tablix similar to Tablix in Matrix wizard we use the report created in Exercise 2 SalesbyRegion_Ex3 rdl While this exercise creates a new report using the report from Exercise 2 will enable you to compare the two versions After opening the report follow these steps 1 Insert a new tablix below the existing one 2 Create some blank space below the existing Tablix 3 From the Insert tab of the Ribbon select Matrix then select Insert Matrix 4 Resize the new matrix below the existing one Your report in design mode will look similar to the following figure Click to add title egion Total ub OrderYear Catei SubCategory Sum SalesAmc Sum SalesAn ETU 6 Sum SalesAn Sum SalesAn Sum SalesAn Execution lime Figure 43 Empty New Tablix 5 From the Report Data window do the following a Drag the Region field to the Column Groups area of the Grouping window b Drag the OrderYear to the Column Groups area of the Grouping wind
25. Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 3 Run your report Go to the Home tab then click the Run button or press F5 Sales by Region Product Sub Category Category A 3 331 s i S oa Ei piita E s3 s a D 31 3 1 80 CS Oe TENETE A 15 897 306 98 45 0600 716 72 7 220 537 93 63 176 561 63 Figure 36 Previewing the Completed Gauge with Colored Pointers tl Save your report to the server To save your report on the server perform the following steps 1 Click the Report Builder icon and then select Save As 2 Select the My Reports folder if present on your local server 3 Enter the file name SalesbyRegion_Ex7 rdl For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 8 Modify the Tablix to Show Two Parallel Dynamic Groups In this exercise you will Modify the Tablix report created in Exercise 3 and enhance its functionality Enhance the functionality by moving the OrderYear sub grouping to be displayed as a new adjacent column thereby enabling a second independent dynamic group within a single report item something new for SQL reporting Services 2008 The group brace symbols are a visual indication of what we will be changing TO Region
26. Data Source x Look in E Recent Sites and Servers Recent Sites and Servers http localhostireportserver My Documents My Computer Items of type Data Sources reds smdl Cancel i Figure 4 Browse Server to Data Source 2 Double click the LocalAdventureWorks shared data source you previously created Select Data Source Look in La http Hlocalhostireportserver T My Reports Users Folders Recent Sites Local dyventurew orks and Servers Figure 5 Select Your Data Source 3 Click Next to move to the Query Design step of the wizard Specifying the Data Set Here the data set is generated from a custom query that returns sales data including ProductCategory SubCategory Product and Year It follows that the next step in the wizard is to create a query or a data set for the matrix To streamline the process perform the following procedure 1 Copy and paste the query instead of building a query manually For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual With the new Query Designer in Report Builder 2 0 you can explore the schema of your data source to make it easier to build queries You can also import the query syntax from a file using the Import functionality _ New Table or Matrix Design a query
27. EEEE ERN jl ro Manoao Min d ie 15 897 306 98 45 060 716 72 7 220 537 93 63 175 561 62 Figure 32 Previewing with the Gauge The report now has the visual aid of the gauge to make it easy to understand the relative sales performance of the different categories Take it one step further and using an expression alter the gauge so the gauge pointer color depends on the sales amount itself At this point we should also make the pointers larger for better readability For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 1 Right click the pointer then select Pointer Properties d an PT bb i a T d ee e eK ee Me Ne e Te a Me T o a4 S31 poi Seu ET Ele Fee ee ee O EAEAN rE Arrr OEI TFE eee ed eee A Clear Pointer Value Delete Pointer Gauge Pointer Properties 2 Inthe Linear Pointer Properties dialog box select the Pointer Options category To enlarge the pointer for easy viewing do the following a Set the Width of the pointer to 15 b Set the Length of the pointer to 30 Set pointers type style and placement options Pointer Fill Value poinber Bornier Sum SalesAmount Shadow Pointer type and style options Pointer type Marker Marker style Wedge Placement and size options Placement relative
28. HH cHcTemM pop me FHyabeprrTe YORTHME Sa BA DpopkAT Haas VOTH a CHAN 2 0 Hndepwannonn cxeten III Figure 3 3 Inserting Data Questionnaire selection After this if you insert data about the certain project for the first time click on the New version button Figure 3 4 and you will open the page with the SLAP questionnaire Figure 3 5 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Or SLAP 2 0 Information System User manual Note All the steps that you made until now are just the preparation for inserting data in the SLAP By clicking the New version button you will access the SLAP questionnaire and start inserting data on your infrastructure project answering the questions in the electronic questionnaire The SLAP questionnaire has three scoring levels These levels are marked by the icons with level number in front of every question EJ All the questions from the first level are mandatory while at the second and third level questions the number on the icon is yellow A A If you do not answer some of the mandatory questions you will not be able to publish your project O6jaar E 1 OCHOBHE MHCDCOMaLIM je O MHCTHTYUM JA Koja je pazenna npajekaT 1 Hass Mpeanaraua npojexra T 2 Npeanaray npojecra El 3 AApaca 4 Oco6a 3a KOHTAKT 5 Octane vxcopmauje Ocobe 2a KOHTAKT Ea 6 OMUTHHE
29. P 2 0 Information System User manual e The Export button on the Run ribbon includes various options for export formats Document Map sg Parameters AML file with report data CSV comma delimited TIFF file Acrobat PDF file MHTML web archive Excel Word Export Menu e Try the run time Zoom functionality on both the Ribbon and the lower right status bar 3 To switch back to design mode Click Design or press F8 4 To save your report to the server do the following IEN a Click the Report Builder icon 5 then click Save As b Double click My Reports in the folder list c Enter the file name SalesbyRegion_ex3 rdl d Click Save Save As Report Look in La http Mlocalhost reportseryver e My Reports an Users Folders Recent Sites and Servers If you are unable to see My Reports perform the following steps to save the report a Click Recent Sites and Servers in the left panel b Double click http localhost reportserver c Double click My Reports For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual If My Reports was not enabled on the server you can save to the root of your report server d Enter the file name SalesbyRegion rdl e Click Save Save As Report gq X Look in E htto localhos
30. Stalevski by e mail darko stalevski skgo org JAT SLAP 2 0 Information System User manual SLAP Custom Report Creation For creation of custom reports in SLAP it s necessary that you re familiar with the Microsoft SQL Server 2008 Reporting Services applications and sample data This document provides step by step instructions for building several types of custom reports using Microsoft technology The document focuses on the new SQL Server 2008 Report Builder 2 0 application Before You Begin Estimated time to complete this lab Objectives Basic Exercises 1 5 30 Minutes Advanced Exercises 6 9 45 minutes After completing this lab you will be able to Launch the new report designer application Report Builder 2 0 Create a data source and a data set Design a new report using Report Builder 2 0 Preview your report from the application and from Report Manager Enrich your report using the richly format able text box Enrich your report using a chart Enrich your report using gauge Enhance your Tablix and create two dynamic column groups Add end user power by adding dynamic filtering Required Environment This lab requires the following Microsoft SQL Server Reporting Services Report Server for publishing reports Microsoft SQL Server 2008 Reporting Services Report Builder 2 0 http www microsoft com downloads details aspx familyid 9F783224 9871 4EEA B1D5 F3140A253DB6 amp displaylang en Micr
31. a Palanka is Backapalankaslap etc The passwords for access have the following format slapXXXX word Slap four figures and an exclamation mark for example slap1234 or slap3953 etc When you enter the user name and password you should click on the Registration button in order to access the SLAP system Note unlike most web sites pressing the enter button after entering the user name and password will not have a successful registration as a result When you log in the SLAP system for the first time the screen will look like in the figure 3 0 TSLAP 20 Cetus nes pia a Peale ri Di pe ye Ge ce To b a d F DF epe T ta 210 0 er ee cece ep HAm SLAP 2 0 eee HicbopmMauHonn cucrem U denjo beli se nalazi salik svth peopekete vee optie koji se tbrenuvtne halaz u SLAP w Ubelike elite a unesete podathe mekom od veoh projekata idiknite mi em ma ime propekta u tabali Hone pce ae Erri if start GJER BeodFtaes sag ia JA mgg it ki Danna IE Hoah Excel SA suar 20 cm Figure 3 0 Inserting Data New project To start entering data about your infrastructure projects you should click on the New project button When you do this the following will appear on the screen Figure 3 1 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Or SLAP 2 0 Informat
32. a Set to Return a Unique List of Sales Regions In these steps we will create a new data set or query to a list of regions We will then use this region list to enable users to select what regions to filter To complete this task follow these steps 1 Open the report SalesbyRegion_Ex3 rdl previously created in Exercise3 If you do not have it rerun the wizard Exercise3 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 2 Inthe Report Data window right click the Data Source and select Add Dataset Report Bata New Edit X fj Built in Fields el Parameters aj Images Pa r Delete HP Data Source Pro Figure 46 Adding a Dataset 3 Inthe Dataset Properties dialog box select the Query category and do the following a Click Add to add a filter b Enter Name as regionlist c Set Data Source to LocalAdventureWorks or whatever you have named your datasource d Select the Text option for Query Type and enter the following query string in the Query field Select Distinct Sales SalesTerritory Group AS Region from sales SalesTerritory ee Choose a data source and create a query Parameters Fields Name regionlist Options g Filters Data source Local dventureW orks Query type Text Table Stored Procedure Query select
33. a password HTobpogomnn y HH opmagnonn cuctem CJLAIL Oraj CHCTEM Ipyoka PasneuHre YOINYTE H HAQ OpMaLHje panmtHHTHMI t TENOBHMA KOPHCHHKA Of KOjHX CY HERHMA He OIKOJHH KOPHCHHHKO HME H JIOSFIRIF A MionHMe Bac Oa YHECETE HCMPabHo KFOPHCHHYEO HME H MOSHHEN Tipnjaka Ha cneTest KopHcHukO rme JlosHHka NpHjae a Ako CTE OMUTHHa peTHoHalHa areHinya Koja Capahyje Ca OMMTHHOM HJIH Dpyra HHCTHTYIH ja Koja jE SAHHTEPECOBAHA Ta IpHnoeH Ipobun mpojerta y CJLAI cuctem a HEMATE KOpHCHHYKO HME H IOSHHEy MolHMo Bac Ja KOHTaKTHpaTe MeHalepa cuctema CJLAII wa cnegehy agpecy darko stalevskium skgeo org Kako bHCTE TObHIH KOPHCHHYKO HME H IOSHHEY Aro IpeqcTaBibaTe MHHHCTapcTBo baHky JOHaTOpCKy ATeHIH Y HIH TENO SaHHTepecoBano JA HHHAHCHICKHM CPEJCTEHMA NOJPEH paseo HHPpPAcTPyETYPHHE IpojeKaTa YHje cy Wpobume omuiTHHe yHeme y CILAL cuctem a HEMATE KOpHCHHUKO HME HIH WosHHEy MomuMo Bac Ja KOHTaKTHpaTe MeHallepa cHcTtema CJLAL wa cnegehy agpecy darko stalevshif skgo org Kako bucTe JobHIH KopHCHHUKO HME H NoSHHEY YEQIHEO HE IPHMAalaTe HHJEQHO 0g HABETEHHE KATETOPH Ia A KEMHTE Da byneTe HHbopmucann o CJLAII CHCTeMy MomHMo Bac ga mpuTHcHete gyrMe H3pemrajy Kako bUCTE IPHCTYNHNH WopavHMa 0 HHDpPacTpyETYPHHM IpPoOjeKTHMa KOJH CE TPEHYTHO Hanase y basa CJA cuctema EKOHOMCEH mpojextH Ipojerru o XHEOTHO CpegqHHH CouMjanmHH MpejexTH MSEeWTajH IpuHTHCHHTe DyrMe Da bu cre penenu CJLAL ynutuur CHAN OATHHE There are fo
34. age insecure access is given in the figure 1 1 To access SLAP click on the blue link Or you can add an exception SLAP 2 0 Information System User manual Secure Connection Faker bm or Leen ee r cere The or Die a et One becuse amp el poe Eran Ce RS ee ee Bo ey Stir Ooo ea eee Ped n a ced ek ee ee ee eee r ed bee ee braj LS eee ee ee of fae See i eee ee pee ere ee Le teenies eed ee cam we ee ae Figure 1 1 Mozilla Firefox The computer screen with the error message After this two buttons will appear on the screen where you should click on the right button Add Exception Figure 1 2 g Secure Connection Failed k bm Myra n ee ar Cae TNF Phe cer Dobe a o ad DACA ie l r ree DF OG Sorby va or phog rie eee ee et ee The sou ie a ee ee ee ee oe ce ee eee fn l eee Pe ee Ao fae ee oe ee i en pet See er i kige ie od ee cam Sy age ee Ti RS SS ad eS Pa ee ro a r T cng oe F pees ee ce ji erg eg Pee es ee ial ana Femme jd Espi Figure 1 2 Mozilla Firefox The computer screen with the Add Exception button For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org JAT Then a popup window Add Security Exception will appear on the screen button Figure 1 3 SLAP 2 0 Information System User manual Click the Get Certificate ag
35. ageNumber of AT otalP ages Executed Figure 19 Chart Showing Field Areas Where You Drag From the Report Data Window In the previous Figure notice that there are three editing areas 8 Drag and drop fields from the Report Data window as follows e Drop data fields here Area for fields that represent the numeric measures in the chart In this example the data field would be the SalesAmount field which represents numeric sales data Drag this field into the data fields area e Drop series fields here Area for individual bars series within a category In this example if you want to see one bar for each year of sales within a category select the OrderYear series field Drag this field into the Series area e Drop category fields here Area for categories of data This area is represented by the A through F labels at the bottom of the chart In this example if all series bars should be grouped by Region drag this field into the category area 9 To change the chart title double click the title and enter Yearly Sales by Region 10 To change the vertical axis title double click the text box and enter Sales 1k 11 To remove the horizontal axis title right click the axis and clear the Show Axis Title check box 0 Region A Region C Region E Region B Region D Region F i Show Axis Title Ep Axis Title Properties Figure 20 Turn Off the Horizontal Axis Title For detailed information on SLAP 2 0 Infor
36. alogs when you right click an object For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Grouping i Row Groups This section enables you to manage the properties of all of your groups for Tablix report items table matrix list You can easily create groups using the window or dragging fields to the grouping window Server status in status bar Cp Current report server http fflocalhost rep This area reports the current report server connection status The server can be changed from the Report Builder icon menu and choosing Options Report Builder 2 0 supports zooming in design and run mode SOMIEXE MENHS ee E ee 7 RB2 consists of a rich set of context menus 7 for accessing almost every feature including S Add Page Header the virtual space around a Remove Page Footer the report ef Report Properties kto add data snap anes ne Design Surface Snap lines help align objects Zoom control in status bar For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 2 Pre Requisite Exercise Creating a Shared Data Source In this exercise you will create a shared d
37. an resize your columns wider so numbers do not wrap The ribbon allows you to toggle the design time view of placeholders from sample values to actual placeholder text Currency Flaceholders Sample Yalues 3 Click in the textbox at the top of the report showing Click to Add Title and enter a title Sales by region For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Select the word Sales you just typed in and use the Ribbon to format the font color to red Select the words by region and use the Ribbon to change the font size to 10 Click between the words Sales and by and press ENTER This creates a line break with the small text forced to a second line You can resize the title textbox and move the Tablix down The design view of the report looks like the following figure Sales by Region Region Product Sub ProductCategory SubCategory 12 345 00 a E 3 a Figure 14 Formatted Report Title Using Placeholders for Dynamic Text To use placeholders perform the following steps 1 4 Click in the textbox in the lower right corner of the page footer showing amp ExecutionTime This text box contains a Place Holder specifically for the built in field ExecutionTime which prints the time at which the report was executed on the re
38. ata source on the report server which can be used for multiple reports Utilizing shared data sources on the server allow centralized management of connectivity to data sources Creating a Shared Data Source To complete this exercise perform the following steps 1 Open Internet Explorer and type in the URL of the report manager of http localhost Reports or your server URL and press ENTER 2 Click New Data Source in the Contents page of the Report Manager as shown in the Figure 2 E Report Manager Windows Internet Explorer provided by 55RS Report Authoring Sele E ete eelgesl Pages Folder aspx 4 Xx E Searcl pir ai H co Page Ob Tools Home My Subscriptions Site Settings Help BOL Server Re ti Servi _ _ ae porting Services 7 cee g i Home earch for i Properties Sy New Folder New Data Source 4 Upload File 3 Report Builder Show Details La My Reports C Users Folders Use this folder to store personalized reports Figure 2 Report Manager 3 Onthe New Data Source page perform the steps e Inthe Name field enter LocalAdventureWorks e For Data Source Type select Microsoft SQL Server Enter the following in the Connection String Data Source localhost Initial Catalog AdventureWorks2008 e Near the bottom click to select Windows Integrated Security 4 Click Apply 5 Minimize Internet Explorer to return to it later to preview reports from the server For d
39. ation system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 10 To add total columns for each of the two column groups using the grouping window select Add Total in the drop down for Region then select After Repeat this step for the new group XO Delete Group Group Properties i 331 361 580 TPO Pee eeee Ree U J 12 345 00 12 345 00 12 345 00 12 345 00 12 345 00 Figure 41 Design View of the Completed Tablix with Parallel Dynamic Groups 11 To run your report click the Home tab and click Run or press F5 henn a Manundu o l 3 w 80 1 es nN ANON CN ae OO O M 15 897 306 98 45 060 716 72 7 220 537 93 68 178 561 63 42 308 575 23 25 869 986 41 68 178 561 63 68 178 561 63 Figure 42 Previewing the Completed Tablix with Parallel Dynamic Groups tl Save your report to the server To save your report on the server perform the following steps 1 Click the Report Builder icon then select Save As 2 Select the My Reports folder if present on your local server 3 Enter the file name SalesbyRegion_Ex8 rdl For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Or SLAP 2 0 Information System User manual Exercise 9 Manual
40. d Styles The Chart Wizard enables you to easily create charts The Chart wizard includes a list of pre defined chart styles to select from and it also guides you through creating data sets Sew Chart B p Choose a style Styles feature different fonts and color schemes but do not affect the basic layout You can customize the style after you finish the wizard Styles Preview Corporate Generic Mahogany Ocean Slate on oH BEBE hab T For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 7 Enrich Your Data Visualization Using a Gauge In this exercise you will e Add a basic horizontal gauge to the Report you previously created The gauge adds a visual queue regarding the sum of sales amount per category and the way they stack up to a desired goal of 80 million Remember the design time functionality to zoom in out which becomes more useful as your report gets larger and more complex This exercise assumes that you have completed Exercise 6 Adding a Horizontal Gauge to the Report To complete this exercise follow these steps 1 Open the report SalesbyRegion_Ex6 rdl created previously 2 To add anew column to the right edge of the Tablix right click the header and select Insert Column and then click Right If you do not see th
41. d local development strategy project documentation development level as well as commitment of the municipality to the project expressed through its own financial investment and provision of human and other resources for the project By filling out the second level of the guestionnaire the munisipality takes the first step in the process of application for funds for the feasibility study preparation The third level questionnaire contains information gained through the feasibility study information regarding legal framework of the project compatibility with Serbian and European regulations required permits like building permit and land ownership tender documantation impact of the project on establishment and improvement of cross border cooperation as well as numerous economic parametres By filling out the third level guestionnaires the municipalities apply for donations intended to be used for project implementation For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual The best scored projects from the SLAP system are presented in the regular quarterly meeting to the MISP Steering Committee which decides upon providing financial support for feasibility study preparation tender documentation preparation and project implemantation Currently there are more than 350 registered mu
42. dir Specifies the assemblies that the report references Figure 1 Creating a New Blank Report Using Report Builder 2 0 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org SLAP 2 0 Information System User manual If your screen does not have all the same windows open in RB2 in the Menu bar click the View tab and select all four items Home Insert View a Report Data Grouping v Properties V Ruler k Show Hide Exploring Key Areas of RB2 0 The following table describes several key areas of the Report Builder 2 0 User Interface Report Data Report Data This panel provides New rat access to create and use data sources data sets parameters and images all the key pieces of information you would want to use in your report creation Built in Fields Parameters whichSaleCrderID rs mvlocal adyventureworks B 69 salesorderheaders SalesOrderID Revision mher Properties Properties This panel lists and edits Body the detailed properties of the current report item textbox line and SO On or report section header footer and 0 H A H o hig Border Bordercolor Black BorderStyle Mone body BorderwWidth ipt Fill The most common EO H BackgroundCal No Color BackgroundImi Position Size 5 5iN 2 2 5N properties are also exposed in property di
43. distinct Sales SalesTerriton Group AS Region from sales SalesTerritory Query Designer Time out in seconds 0 ka Figure 47 Create New Query To Use Source The Parameter List For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org JAT 1 SLAP 2 0 Information System User manual In the Report Data window right click Parameter then select Add Parameter H 0 Built in Fields Ea Paramete hisses Add Parameter eee Region ai LocalAdventureWorks i l H E DataSetl _ g E regionlist Figure 48 Create a New Parameter 2 Inthe Report Parameters dialog box select the General category then do the following a Click Add to add a filter b Enter Name as whatregions c Enter Prompt as whatregions d Select Data type as Text then select the Allow Multiple Values check box e Select the Visible option for Select parameter visibility Change name data type and other options Available Values Default Values Name Advanced whatregions Prompt whatregions Data type Text E Allow blank value 7 F Allow null value Allow multiple values Select parameter visibility Visible Hidden Internal Figure 49 Parameter General Settings For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manage
44. e Delete Investment Value fan mil Euros Next time you want to select the same group of municipalities select USAID MEGA from the drop down list For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org AN re eo SLAP 2 0 Information System User manual e The next filtering criterion is the project documentation status or project maturity At the top right corner of the filter there is a field containing documents comprised under project documentation Technical Note Study General Design Pre Feasibility Study Preliminary Design Feasibility Study Main Design and Tender documentation Mune palities Selected Munscipalities Documents Selected documents gt Concept Note el Study General Project Dex Prefeasibility Study Preirinary Project y Feasibility Study s Choose municipalities no Selection Project Sector al sectors Saye Municipalities Project Typa an types Saver Delete Investment Value in mil Euros eetwvesf e 6It is possible to select any of the documents from the list that the filtered projects should contain It is also possible to select a greater number of documents whereas the final project list will show only those containing all selected documents Municipalities Selected Munscipalities Documents Selected documents gt Concept No
45. e Lee Lent dehla Liria Tau er abe fe err oe Pee ee Pe mia PM re al iher em nti ee ae ESS T Widi l mA e n Figure 1 3 Mozilla Firefox The computer screen with the Get Certificate button After this on the bottom of the popup window the Confirm Security Exception button will appear Click this button to se the font page of SLAP Fp aed Let deat Tipton Pau gee aes fe eerie eee Peete bores Pa ate A Pe tt m mh s mi er mml siber pailis en ico vt LEE MAE LE F P am Pia oo mes a Loan liis ei eg e e ee Ped ee Beragi r Lae re eo ee a ee i pei eas ae lik mn el dl eee ce ee eee ee r Pr ike ee ed Pe a Corre teary a come Figure 1 4 Mozilla Firefox The computer screen with the Confirm Security Exception popup window For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org A SLAP 2 0 Information System User manual If you use Opera the SLAP inaccessibility message insecure access is given in the figure 1 5 To access SLAP click on the Approve button Fpi m m fd be ea hr baa er e i u Pirm h paa m i n h g r l a a Figure 1 5 Opera Browser The computer screen with the Security Alert popup window If you use Google Chrome the SLAP inaccessibility message insecure access is given in the figure 1 6 To access SLAP
46. e headers click anywhere in the Tablix Delete Columns Column Visibility 0 12 24 Tablix Properties cuted amp Execution Time Figure 26 Insert a New Column For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Or SLAP 2 0 Information System User manual 3 Inthe Insert ribbon click Gauge and then click in the last cell of the newly added Total row of the ProductCategory group 12 245 00 12 245 00 12 245 00 amp PageNumber of amp TotalPages Figure 27 Insert a Gauge into the new column on the Total row The Select Gauge Type dialog appears 4 Select the first Linear type Horizontal then click OK Figure 28 Select Gauge Type For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org A SLAP 2 0 Information System User manual 5 To adjust the size of the Tablix and Gauge drag the row and column wider to view and to click on individual elements within the gauge such as the rectangular pointer and the scale of numbers The Tablix looks as below Total Ma a O O na LOrderYear SubCategory 12 345 00 12 345 00 12 345 00 12 345 00 12 345 00 Figure 29 Resize Gauge 6 To add the Data field in the Gua
47. ect Chart Type Line Shape Bar Area Range Scatter Polar cancel Figure 17 Selecting the Chart Type For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual amp PageNumber of amp TotalPages 6 Select the default column chart in the upper left corner then click OK da i The chart report item is now placed on the design surface There is no need to select a Data Source and Data Set because the report already has only one so Report Builder will have set it for you The Design Time view of your report will look like the following Total SubCategory Sum SalesAmount Sum SalesAn Sum SalesAmour Sum SalesAmo Sum SalesAn Chart Title MO Series 1 gt Series 2 Axis Title Executed amp ExecutionTime Figure 18 Chart Report Item is Created For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 7 To put the chart into edit mode double click the chart Your Chart report item now looks like the one below with the field areas visible Drop data Fields here Chart Title Drop series Fields E E a a A BCDE Axis Title CRE I eT Drop category fields here AP
48. ected in the Tablix The column and row selectors provide an additional visual cue of how elements are grouped For example if you click on ProductCategory in the Row Groups area you can see the grouping indicators such as below Grouping Indicators e Try the Zoom slider on the status bar at the lower right corner of the screen To run the report perform the following procedure 1 Click the Home tab and click Run button or press F5 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org ANA re eee SLAP 2 0 Information System User manual Your report will look similar to the following Figure 12 Completed Wizard with Expanded Accessories Product Group i gt i Refresh Fa Tooms Net Last Stop al Gio Parameters Product Category G Accessories Bike Racks 63771 6000 484045000 239437 2000 ciese O 10335 0000 39591 0000 64353 5989 18518 5710 46619 5800 392115 4294 106329 7638 6159 0000 5145 4260 246454 8464 158973060 9833 45060716 7241 7220537 9250 68178501 63274 9 16 2008 6 16 12 AM 2 Use the Expand and Collapse functionality in the Accessories group to explore the report For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLA
49. er Reporting Services 2008 introduced new Data Visualization functionality in the form of a richer chart report item and an all new gauge report item The Data Region report items such as Chart Gauge and Tablix are only allowed in the Report Body section and not in the Header and Footer sections This exercise assumes that you have completed Exercise 4 Adding a Basic Chart to Previously Created Report To add a Basic Chart to a previously created Report follow these steps 1 Open the previously created report SalesbyRegion4_ex rdl 2 To add a chart report item to the design surface below your existing Tablix do the following a Create some space at the bottom of your report by dragging the report body sizing handle down in the vertical ruler This will create a blank space below your Tablix and will be used to accommodate the chart 4PaqeNumber OF amp lo 3 Inthe ribbon click the Insert tab then select Insert chart under Chart The mouse cursor is now in Insert mode 4 Place the pointer to upper left corner of the new chart or drag to place and size the new chart For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 5 Click immediately beneath the lower left edge of the Tablix in the Report body The Select Chart Type dialog box appears Sel
50. esbyRegion v s x flivesearch OO z w be Report Manager fy D o me cP Page e Toos SQL Server Reporting Services Home My Subscriptions Site Settings Help SalesbyRegion User manual Properties J History Subscriptions id 4 fi of1 gt Pi 100 x Find Next Select a format x Expot A a Select a format XML file with report data CSV comma delimited Acrobat PDF file MHTML web archive f Product Sub Category Category 15897306 9833 45060716 7241 7220537 9250 68178561 6324 9 16 2008 7 55 13 AM Figure 16 Viewing the Report in Report Manager Note that the same export options in the Report Builder 2 0 application are available in the Report Manager as well as zoom and printing The Role Report Manager also enables you to assign permissions and create Subscriptions for reports and can automatically e mail the report results to required e mail aliases This report dispatch can even be scheduled for example every morning at 8 30 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 6 Enrich Your Report Using Charts In this exercise you will e Adda basic Chart to the Report you previously created We will manually build a simple chart rather than use the wizard to get a feel of modifying the report items SQL Serv
51. etailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 3 Table and Matrix Wizard Data Sources Data Sets and Building a Matrix In this exercise you will e Design anew report using the Table or Matrix wizard e Specify the report data source The data source to be used is the AdventureWorks sample database that you can download from Codeplex See references section at the end of the document e Specify the Report Data Set The data set is generated from a custom query that returns sales data including ProductCategory SubCategory Product and Year e Specify fields and groupings This exercise demonstrates how to create a report showing Product Category and Sub Category for the row axis and Region and Order Year for the column axis e Select report layout of style and colors This exercise assumes that you have completed Exercise 1 Designing a New Report Using the Table or Matrix Method To design a new report follow these steps 1 Open the Report Builder 2 0 2 Inthe new blank report click the Table or Matrix wizard link in the center of the screen The wizard walks you through creating a Table or Matrix The process includes the creation of the required data source and data set j Table or Matrix You can also access the wizard from the toolbar by se
52. ge click the Field Selector El inside the Gauge and select SalesAmount 7 Click the Gauge so field area is visible then click the LinearPointer area to see the field selector Drop data fields here ProductCategory SubCategory OrderVear OrderQtr Territory Region 8 To set the Scale Properties right click the scale and select Scale Properties Drop data fields here Sum SalesAmount Delete Scale Add Pointer Add Range Gauge Show Labels Show Major Tick Marks Show Minor Tick Marks Scale Properties For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 9 Inthe Linear Scale Properties dialog box select the General category a Set the Minimum scale to 1000000 one million b Set the Maximum scale to 80000000 eighty million Linear Scale Properties Change the value option for the scale Action Layout E Reverse scale direction Labels Fant Value and interval options Mumber Minimum Maximum Major Tick Marks 1000000 bi 80000000 Interval Interval offset Auta ike Auto Multiply scale labels by Border f Ej E Shadow Minor Tick Marks Fill Logarithmic scale options ry Logarithmic scale Figure 30 Linear Scale Properties Setting the Min Max Dark
53. h the aim of providing assistance to the municipalities within the territory of Serbia in infrastructure project identification and development as well as in application for international and national funds Those are first of all the European Union funds i e IPA funds then the European Bank for Reconstruction and Development funds Kfw funds From national funds there is NIP ECO fund etc Financial resources received from these sources are used for preparation of the feasibility studies as well as for project implementation The municipalities apply for the mentioned funds by entering data on their infrastructure projects into the SLAP The system has been designed to enable the municipalities to enter data independently through the internet while at the same time provides for the donors and relevant ministries an overview of all actual projects in the territory of Serbia and gives them a detailed insight into stage of their development The data are being entered into the SLAP by filling out an electronic questionnaire which contains three levels of information The first level is eliminatory and it reffers to the legal status of the project owner classification of the project according to to the sector or type basic concept of the project and the investment value The second level provides more detailed information on the project further insight into its main ckaracteristics and beneficiaries its foundation in national regional an
54. hanged component and to enter latest data It is important to answer all the questions of the level 1 marked by the icon If you do not do so you wont be able to publish the project For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual You answer the question by putting the mouse cursor on the question you want and after that question text changes the color in blue and shows the line which underlines the question figure 3 6 1 OCHOBHE MHDOPMauje O MHCTHTYUM 4 Koja je paserna npojeKart 1 Hane Dpeanaraya npojerta L 2 TIpeanaray npojekta ooo Agpeca 4 Ocoba 3a KOHTAET d 1 15 Octane wHobopmauje Ccobe 33 KOHTAKT 6 OMUWTHHE KOPHCHHLUH 2 OPyWTBEHO EKOHOMCEM HHAHKATOPH OpY KEHA Y KOME Ce NPOJEeKAaT paseoja p j 1 SpOYUTEEHO EKOHOMCHH HHA HKATOPH pasBoja ONLWTHHe gt 2 ogru npo Of sara heada After this click on the question you want and it will show up on the screen figure 3 7 SLAP 2 0 Qninearre ce HudbopmMalHonn cucTem mE om 1 1 Himo Wpewiaras opojecra ona soot O Cauyeaj Savg Figure 3 7 Inserting Data Question For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual
55. iiiaiiiiaien i ld 17 345 00 17 345 00 Figure 38 OrderYear Group Deleted 5 To add an adjacent group after Region right click the grouping window select Add Group then select Adjacent After Parent Group AddTotal J gt Child Group Delete Group Adjacent Before oe ee Adjacent After Group Properties Figure 39 Add Adjacent Group 6 Click OK 7 Select Group By OrderYear in the Tablix group dialog box For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 8 Right click in the new OrderYear column and add SalesAmount SalesAmount is added to the whole column ProductCategory SubCategory Ordery ear CrderQtr Territory Region Your Tablix will now resemble the following figure Fi H 531 i 80 C 12 345 00 Sum SalesAn 12 345 00 Figure 40 New Adjacent group The two group brace symbols are now alongside each other on the column headings Note Changed from 1 1 1 1 1 Sum SalesA mount Sum SalesAmour Sum SalesAmount 12 345 00 Sum SalesAn 9 Set all three Sum SalesAmount cells in the new a column to currency format by clicking each cell and using the currency button on the Ribbon For detailed information on SLAP 2 0 Inform
56. il AS SD ON SH SalesOrderiID SD S5alesOrderiID JOIN ProductCategory SubCategory Orderfear OrderQtr SalesAmount Territory Region Components Headsets 2003 g 2294 6722 Canada North America Accessories Locks 2003 Qi 60 0000 Central North America Bikes Mountain Bikes 2003 03 251449 7419 Central North America Bikes Road Bikes 2003 4 668325 2180 Southwest North America Clothing Wests 2004 gi 22649 2200 Central North America Components Chains 2004 gi 24 2880 Southeast North America Components Bottom Brackets 2004 O2 2300 1240 Southwest North America Hydration Packs 2004 O2 3128 9310 Northwest North America ae Ge el Figure 7 Text based Query Design in the Wizard 4 Click Next to continue to arrange the fields Specify the Fields and Groupings In continuation with the Report Builder wizard specify the fields and groupings in the following steps 1 To arrange the fields Column Groups Row Groups and Values do the following a Drag SalesAmount to the Values definition box b Drag ProductCategory and SubCategory to the Row groups definition box c Drag Region and then OrderYear to the Column groups definition box For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual New Table or Matrix Arrange fields Arrange fields to group data in rows calumns
57. inserted by the local self governments Besides that this kind of user may create its own project scoring system and its own reports e System administrator this type of user has all the privileges that other users have and the ability to create new and extend the existing questionnaires and scoring systems define new user groups create user names and passwords etc Depending on which user category you belong to by enterring the SLAP system you will get the access to different parts of this information system For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org AN re eo SLAP 2 0 Information System User manual SLAP Filtering and Reporting System Upon logging onto the SLAP 2 0 Information system with the user account type Donor or by clicking the Reports button if you have logged on as Administrator you will see the display as follows On this page you can access reports that are based on data entered on infrastructure projects by municipalities and regional development agencies Municipalities jada E Sleksandrovac Sleksinac dlibunar 4patin jdrandelovac Save municipalities Projacts summary Projects by MMuratipality Project Gotumentation Financial Sources Projects by Munsacipality Project Documentation Financial Sources Project Scoring Investment Overview
58. ion System User manual Ar SLAP 2 0 HlucopMalnwonn cucTreM LLE VHOCHTe MHPOpMaLpije BAWIEM HOBOM MpojeKTy Hacacn pateta Hatton opojerta Tpedecnopt TP FHeprij EH KOMWHM RAL e E Henyre on amuter aHanaja 2 ge Joran Anebi osa ARLE Canny In upper left box insert the project title in Serbian maximum 50 characters Similar to this insert the project title in English in upper right box The project title is inserted bilingually because it appears in all the reports generated from the SLAP system so that both domestic and foreign donors can understand the contents of the table This is the only data which should be inserted in two languages After inserting the project title select from the drop down list the project sector economic infrastructure social infrastructure or environment protection sector Then the project type should be selected You can select the project type by left clicking on the desired type and then on the right arrow If you did all this correctly you will see the selected project type in the white right box below the Selected project type Then to choose the project location select the desired municipality from the list or if the project belongs to more than one municipality choose the Multi municipal project option In further electronic questionnaire filling you can list all the municipalities which participate in the project After filling in all the boxes on
59. it is necessary to attach that document You can do this by clicking the Add document button and thereafter opens the window for document adding figure 3 11 NpoHahMtTe JOKYMeEHT H npegaj Te ra MOXETE NpesatTh Camo 1 FOKYMEHT NO MHATA ALOK YMeHTH Mopajy OHTA Mahr og 10MB Browse Mpegal Figure 3 10 Inserting Data General design Master plan For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org JAT SLAP 2 0 Information System User manual Click the Browse button in order to find the document you want to attach After you choose the document click the Open button Choose file TA 2 ixj Lokin O Dokumenth O a a M y R B c er i D mim uri ents Koncept projekta docx wi Studija docx generalni projekat amp Master plan docx Be sktop 2 May Documents a biy Computer oc a hly Kietna File name E enerali projekat amp Master plan docs Places a Files of type All Files Cancel Figure 3 10 Inserting Data General design Master plan After this click the button Submit and wait for a moment in order to finish document upload the period necessary for the document upload depends on its size After the document upload you will get the message from the system that you document was successfully submitted Click the OK butto
60. lecting Matrix Wizard from the Matrix Menu as well as the Table Wizard from the Table menu both in the Insert tab The icon in your new report disappears after you run the wizard the first time However you can re run the wizard at any time from the Insert ribbon 3 Atthis point you may briefly see the server dialog informing you the application is connecting to the server The new Table or Matrix Wizard dialog appears Select the existing data source connection LocalAdventureWorks and click Next For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual New Table or Matrix Choose a connection to a data source Choose a published data source or create a connection for use only in this report Data Source Connections Figure 3 New Table or Matrix Wizard If you cannot see the shared data source you previously created click Browse to find the data source on the server Specifying the Data Source To browse to your specific data source perform the following steps 1 Double click the server name http localhost reportserver For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Select
61. local server 3 Enter the file name SalesbyRegion_ex8 rdl For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 10 Use Query Parameter and Filter to Limit the Tablix Data In this exercise you will e Create a new dataset that will return a unique list of the sales regions e Create a parameter that will use the new dataset and will present the user the values to select from when the report is run e Create a filter on the tablix which will use the value s the user selects from the parameter to filter limit the data that is actually shown in the tablix after running when the report Filters are very useful for many scenarios such as including a single dataset for the report but you can also represent different subsets of the data using multiple data regions e g chart or tablix New dataset query to build Parameter uses the new dataset Tablix filter uses the selections list of possible regions to present the list of possible made in the parameter to egions to the user when they run r limit the data the tablix This exercise assumes that you have completed Exercise 3 You can also build this on top of later exercises though your images will look different with more objects Alternatively create new report and repeat Exercise 3 again Creating a New Dat
62. mation system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System The chart will look like the following figure User manual Drop data fields here Sum SalesAmount Yearly Sales By Region ordervear MS Order Year A DW Order Year B m ii T m wo Drop sees fields Region A Region C Region E Region Region D Region F it Drop category fields here Execution Time Figure 21 Chart Design 12 To run your report click the Home tab and click Run or press F5 15 897 306 99 45 060 716 72 TA Yearly Sales By Region 30000000 25000000 20000000 15000000 10000000 5000000 0 oie a oe 2 a oJ Figure 22 Previewing the chart The result should resemble the chart above Let s modify this chart further and format the sales numbers on the left X Axis for currency To format the Sales numbers in the X Axis for currency perform the following steps For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Nre eo SLAP 2 0 Information System User manual 1 Switch back to design mode by clicking Design or press F8 2 Right click the numbers of the sales at the X Axis then select Axis Properties To see the Axis Properties option right click on the Axis Title
63. mitting Design Tender and Contract Civil Works Equipment amp Machinery Construction amp Supervision Start up Technical Assistance SLAP Coordinators is a list of persons appointed by municipality to enter data into the SLAP information system If you have additional questions with regards to any project not covered by the SLAP questionnaire you can contact SLAP Coordinator Scoring System provides insight into the scoring methodology which partially defers depending on the sector Environmental Social Economic The last report is the SLAP questionnaire blank which can be downloaded by clicking the button Since the SLAP questionnaire is occasionally updated you can download the latest version here On the next pages you can see several examples of the SLAP reports Data in those reports are fictional and for presentation purposes only For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org r eo SLAP 2 0 Information System User manual By clicking the All projects button you will be directed to a page containing the list of all projects in the SLAP system These projects can be filtered according to sector and type as well as according to the municipality they belong to Choose a project in the table below by clicking on project title Sector Hame Type Name Municipality fan Sectors j E types l
64. n and then the SLAP questionnaire button in order to continue filling in the questionnaire M Norephyjem objaemupahe nogataka o npojerty Y 1 OCHOBHE MHCOpMaUMje O MHCTHTYUMjM Koja je pasBrina npojeKart blaf 1 Hazme Mpesynarasa npojektTa 2 IpeaAnaray npojektTa 3 AJpecaA 4 Ocoba 3a KOHTAKT C 5 Octane vHpopMaumje Ocobe 24 KOHTaKT EC 6 ONUTHHE KOpHCHHLH For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Now you have filled a part of the questionnaire and you answered several questions but your project i e your answers are not visible or available to other system users In order to officially public the data about your infrastructure project it is necessary to tick the box Confirm the publishing of project data on the top of the page with the SLAP questionnaire and after that click the button Publish figure 3 11 After this the data about your infrastructure project will be available for all the ministries organisations and donor association which use the SLAP information system At the end of a working day log off from the SLAP system by clicking the Sign out link in the right top screen corner figure 3 12 Nm SLAP 2 0 eT HudopMalnonn cerem Figure 3 11 SLAP Questionnaire Publishing data Next time when you log in the SL
65. nicipal infrastructure projects in the SLAP system with the expectation of having over 500 projects by the end of january 2010 SLAP supports project development from three different sustainable development pillars 1 Economic Infrastructure projects that foster economic growth and stimulate business employment transport renewable energy communication shared business services business estates incubators research technology and innovation tourism youth talent centre etc 2 Environmental Infrastructure projects that can improve the environmental quality in and around municipalities and the environmental health of the community air quality protection district heating water supply wastewater management solid waste management noise reduction etc 3 Social Infrastructure projects that can help redistribute fairly the fruits of economic success among all segments of the community especially the more vulnerable like the older disabled diseased or less able affordable housing housing care sport culture and heritage protection childcare center vocational schools residential care facilities for the elderly disabled etc Entering projects into the SLAP system currently represents the fastest way of providing funds for municipal infrastructure development in Serbia All the relevant ministries have expressed their interest in using the SLAP for identification of municipal infrastructure projects ready for financing regardless
66. nt value is to be entered into the left field and the highest investment value into the right one This allows for example filtering of all projects with the investment value between 2 and 7 million EUR Municipalities Selected Munscipalities Documents Selected documents Conc ept Note f eenera Project Desig Study jreasebility Study General Project Dey Prefeasibility Study Preiminary Project Bi on Feasibility Study Choose munracipalities No Selechon Project Sector fan sechors Saye Municipal t aes Projoct Type an types Save Delete Investment Value fin mil Euros ri lt ry lt T The filtering system has been designed to allow combining of various project selection criteria for instance one can select projects from a certain sector or of a certain type with a Feasibility Study or with the investment value of more than 6 million EUR Upon setting of preferred project filtering criteria it is necessary to initiate some of the reports applying the set criteria The first picture in this chapter shows the list of all reports available through the SLAP system For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Projects Summary Projects by Municipality Project Documentation Project Financial Sources Project Sc
67. o Stalevski by e mail darko stalevski skgo org For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager AN re SLAP 2 0 Information System User manual 10 Select the Number category then do the following a Inthe Category list select Currency b Set Decimal places to 0 c Select the Show values in check box then select Millions from the drop down list General Action Layout Labels Fort Major Tick Marks Minor Tick Marks Fill Border Shadow Set number formatting options Category Default sample Number 12345 Percenta ge Scientific Custom Decimal places F Use 1000 separator Show values in Millions E Show zero as Negative numbers 512345 5 12545 12345 5 English United States E Show symbol after value E Include a space Current regional settings English United States Figure 31 Currency Settings For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Or SLAP 2 0 Information System User manual 11 Click OK Total 12 345 00 FH 5 Sod Sie E E i 12 345 00 12 To run your report click the Run tab or press F5 The rendered report will look similar to the second figure Sales by Region Product Sub Category Category 31 31 i EET
68. of that if the projects are financed from the national or IPA funds For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual SLAP information system access Considering the fact that the SLAP is a web application a software that works via the Internet it can be accessed the same way as a web site by typing the relevant address in the Internet browser The address for SLAP 2 0 Information System access is https www slap skgo org It is important to mention that it is necessary to type complete address and not only www slap skgo org Unlike the most web sites SLAP uses secured connection for data security and for this reason its web address does not have the standard prefix http but https This is the reason why the Internet browser Internet Explorer Firefox etc cannot automatically assign the correspondent prefix therefore if you do not type the complete address you will get the message that SLAP is not available You may have minor problems with the first accession to the SLAP system depending on the Internet browser you use In fact the electronic certificate used for SLAP is self signed which is interpreted as a potential risk by some browsers and you will be warned that accessing SLAP may be insecure Naturally the risk does not exist though
69. oring Investment Overview All Projects SLAP Coordinators Scoring System SLAP Questionnaire Project Summary provides global overview of the projects in the data base their distribution by sectors and types of project as well as the investment value statistics The next page shows the layout of this report Projects by Municipality gives the list of all projects in the SLAP system data base where the projects are listed according to municipalities they belong to so it is easy to see which projects are being developed under each municipality which sector the projects belong to their type and their individual and total investment value Project Documentation provides insight into project documentation status the tables contains all accompanying documents and their current status not existing draft finalised approved Financial sources shows whether there are already secured funds for project implementation as well as their source EU grant Other grants Loans etc This report also provides information on financial gap Project Scoring gives a detailed insight into each project scoring Each column of the report represents a question from the SLAP questionnaire and the maximum score a project can have is given at the bottom of the column The table itself contain the score of each project Investment overview represents division of the total investment value into smaller segments Total Project Cost Project Preparation amp Per
70. osoft SQL Server 2008 Adventureworks Sample Database http www codeplex com MSFTDBProdSamples Release ProjectReleases as x Released 18407 For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Lab Scenario You are a report author for AdventureWorks a sporting goods retailer You have a requirement to develop a new report that displays product sales information The report is to be designed to show aggregated sales data using two level dynamic groupings on both the row and column axis You also need to create an advanced report that leverages some of the new design capabilities introduced with Reporting Services 2008 A Reporting Services 2005 table enables quick and easy groupings of basic data A Reporting Services 2005 matrix enables complex groupings of data including nested groups and inner static members within dynamic columns In Reporting Services 2008 a new data region called Tablix combines the table and matrix features combining the best of both Therefore the new Tablix functionality allows you to build reports that include the following e Multiple parallel row column members at each level e A mix of dynamic or static members on both rows and columns e Optional omission of member headers e Arbitrary nesting on each axis For detailed information on SLAP
71. ow below Region For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual H Column Groups Region1 6 From the Report Data window do the following a Drag the ProductCategory field to the Row Groups area of the Grouping window b Drag the SubCategory field to the Row Groups area of the Grouping window below ProductCategory i Row Groups ProductCategory1 7 From the Report Data window drag SalesAmount to the Data cell at lower right of the Tablix The new Tablix will look similar to the following figure Region Product Category sub Category Order ear 8 To add the totals after all of the groups in the grouping window click each of the four groups select Add total then select After Row Groups SubCategory1 Delete Group Group Properties Sum SalesAmount Sum SalesAvrri EMRE For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 9 Torun your report click the Home tab and click Run or press F5 The data is grouped as desired but it is difficult to initially view and understand it as there is plenty of information Hide the sub groups for the initial
72. port Type Executed before the amp ExecutionTime so the whole string is Executed amp ExecutionTime Expand the Built in fields list in the Report Data window and drag Page Number to the lower left corner of the report footer A new text box is created with the amp PageNumber place holder Report Data New Edit 2 Built in Fields Execution Time Page Number Report Folder Report Mame Report Server URL Total Pages User ID Language Gh aeaennasee a o amp PageNumber Click the right edge of the new textbox and resize the box to the right to make the textbox wider You can also use SHIFT Right Arrow to resize the box For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual aes gaa hs EE eee eet heer re T PPPE PEEPI PET EEEE perereyerer B PageNumber O Executed 2ExecutionTime 5 Inthe text box type of after the amp PageNumber place holder and from the Report data window drag Total Pages to the end 6 Select the text and make it bold You can make the selected text made bold by pressing CTRL B similar to Microsoft Office Applications na A irssnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn A A ceeds AT m S agoNumben of amp lotalPages a Executed amp Executionlime 7 To run the report click the Home
73. ps 1 Select the top edge of the Tablix right click it and select Tablix Properties Insert Column Delete Columns Column Visibility Figure 52 Open Tablix Properties For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 2 Inthe Tablix Properties dialog box select the Filters category then do the following a Click Add to add a filter b Set Expression to Region c Set Operator to IN d Set Value to whatregions Tablix Properties General Change filters Delete Expression Region Value whatregions Visibility Cancel Figure 53 Tablix Filter Settings 3 Click OK You are now ready to run your report and select the region from the parameter area 1 Torun the report click the Home tab then click the Run button or press F5 2 Select Europe then click the View Report on the right For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Figure 54 Selecting Parameter Values Your report will look similar to the following figure which only shows the Europe group 3 Switch back to the Design view Product Category Sub Category 15 897 306 98 15 897 3
74. r Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 3 Select the Available Values category then do the following a Select Get Values from query option b Select the Dataset as regionlist c Select Value field as Region d Select Label Field to Regionv 4 Select Allow Multiple Values category Report Parameter Properties General Choose the available values for this parameter Default Values Select from one of the following options Advanced None Specify values Get values from a query Dataset Value field Region Label field Figure 50 Parameter Available Values Settings You should now see your parameter as well as the new dataset listed in the Report Data window For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Or SLAP 2 0 Information System User manual H O Built in Fields S E Parameters H E DataSetl ES regionlist EE Region Figure 51 New Parameter and Data Set Listed in Report Data Window Create the Tablix FilterThe filter in Tablix enables the user to dynamically select different region s to filter on each time they run the report The user can then export the different views and in effect create a form of ad hoc query functionality To create a filter in Tablix perform the following ste
75. rmation on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org r eo SLAP 2 0 Information System User manual At the top of the page there is a system for municipal infrastructure project data filtering There are five different filtering methods criteria under the filter e Project filtering according to geographical area by municipalities allowing selecting of custom number of municipalities for which the data will be displayed in the report Murer peal ties Selected Munscipalities Documents Selected documents Ada Aleksandrowac mleksandrnoy ac Apatin Ba ka Palanka Prijepolje arandelovac y ES lakanat Choose municipalities No Selecton Projact Sector Saye Municipalrt mes Project Type Save Delete Ail secbhors an types Investment Value in mil Euros lt Inv lt It is also possible to save a list of selected municipalities and then to enter the selected name for instance USAID MEGA into the field following Save municipalities and press Save see below Munem palities Ada Alek sand roy ec Selected Munscipalities Documents Selected documents Aleksandrowac Apatin Ba ka Palanka Prijepolje Arandeloyac z Choose mumicipalitigs No Selector Project Sector ai sechors All types mis Saye Municipalities usap MEGA Project Type Sav
76. roposer where it was necessary to type the text in the correspondent box with this question it is necessary to choose one of the options by clicking the correspondent circle radio button After this as in the previous question click the button Save and then the button Back in order to save your answer and go back to the SLAP questionnaire After this you can go to the next question e g question 4 2 2 figure 3 10 This question refers to the project documentation more precisely it refers to the general design master plan For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual 4 1 2 Denepannn I pojerar Macrep IInan Hacnoe mas 100 zj HaTym max 10 AyTop a max o NA Halt PHHANKMSOBAHO QA00PGHO og CTpaHe npesnarava QO0DCHO Of CTPaHe OBNaWheHe HHCTHTYUMIe Dogaj J0KYMEHT Cayyeal oave Figure 3 10 Inputting Data General design Master plan Within the answer to this question as well as when you answer all the questions regarding the existance of some document type the document name title to see if the document is finalized and approved adopted by the project proposer and authorised institution Apart from these answers to the question about the existance of a certain document as an evidence of its existance
77. t reportserver My Reports There are no items in this list Recent Sites and Servers My Documents i My Computer Mame SalesbyRegion rd Items of type Reports rdi Cancel be Figure 13 Save As Dialog For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 4 Enhancing Your Report with Richly Formatted Text In this exercise you will e Enhance the look of your report by using rich formatting on a report title e Use place holders for dynamic text This exercise assumes that you have completed Exercise 3 Enhancing the Look of the Report To enhance the look of the report follow these steps 1 Open the SalesbyRegion_ex3 rdl report created in the previous exercises if it is not already open 2 Toset the sum fields to show currency format do the following a Click the upper left sum field the Sum SalesAmount under OrderYear b Hold down the SHIFT key and click Sum SalesAmount in the lower right corner to select all of the sum fields ry Sum SalesAmount Sum SalesAmoi ET ee Sum SalesAmour Sum SalesAmo Sum SalesAn c Click the currency format button So the ribbon You can also click and format each field individually When you run the report you will see the currency format When in design mode you c
78. tab and click Run or press F5 The placeholder now changes to actual values For example here the amp ExecutionTime placeholder is now a date and time By default the report layout appears in a small collapsed size If you expand several product categories and switch to the layout mode the page total reflects the increased number of pages To change the layout click the Print Layout button in the ribbon ea Print Layout Click Design or press F8 to return to Design view This exercise only gives you an idea of how you can enhance your report with the new text box and the ability to richly format your text Various combinations of static text such as Executed placeholders support for one to many lines numbered or bulleted lists paragraph alignment and the rich font formatting make the new textbox a powerful addition in SQL Server Reporting Services 2008 tl Save your report to the server To save your report on the server perform the following steps TN 1 Click the Report Builder oy icon then select Save As 2 Select the My Reports folder if present on your local server 3 Enter the file name SalesbyRegion_ex4 rdl For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual Exercise 5 View Your Report from the Server In this exercise
79. te General Project Desig Study Feasebility Study Genera Project Dey Prefeasibility Study Pre minary Project a E Feasibility Study Choose muracipalities Mo Selector Project Sector ai sechors lt Saye Municip alt mes Project Type as types Save Delete Investment Value in mil Euros fe Inn For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org AN re eo SLAP 2 0 Information System User manual e The next filtering criteria are project sector and project type There is an option of selecting only projects belonging to a certain sector to be shown in the report or only those belonging to a certain type within the sector Munecipalities Selected Munacipalities Documents Selected documents Ada Aleksandrovac Concept Note aj General Project Desig Aleksandroyac Apatin Study Aloksinac Ba ka Palanke General Project Ogi Prijepolje Frefeasibility Study i Preliminary Project m Arandelovac gt Feacibility Study Feaseblity Study Choose municipalities No Selection Project Sector fam sectors Save Municipalities fusain MEGA Project Type DE Save Delete Enwromental Social l ii e T The last data filtering criterion is the project investment value for which two fields for filtering criteria are defined lowest investme
80. ur user types of the SLAP system e General public this type of user does not have a username and a password but from the SLAP system front page has an insight into the reports on project scoring their current status as well as some basic information about the project sector and type the project belongs to investment value location project documentation status compatibility with the national regional and local development strategy etc This type of user can download the SLAP questionnaire in PDF format For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org Ar SLAP 2 0 Information System User manual e Municipalities Towns local self government this type of user has access all the reports like the general public but since it has a user name and a password it can enter the SLAP and make data insertion into the database Data insertion means defining new projects in the system and filling the electronic questionnaire e Ministries banks and donor agencies this type of user has the access to all the reports like the general public but it has a username and a password for entering deeper into the SLAP system which differs from the one that the municipalities towns have After entering the SLAP system the user can see the data about all the projects in the SLAP database and it has an insight into their PPDs
81. way you will create the new version you can fill in but it will allready contain all the answers you filled in before SLAP 2 0 LlncbopMaunonn cucrem Cnet ax CONE Repo Opopeeta Epo Bepe arya epenpaia arya aposerice Hime nepune OOjan ant AN Vise cert ap i ILa aa 1E lao al 3 Ha Hops ero Ooregeene lipenn Figure 3 14 Inserting Data Version selection For detailed information on SLAP 2 0 Information system functioning you may contact the SLAP project manager Darko Stalevski by e mail darko stalevski skgo org

Donor manual

Contents

Download Pdf Manuals

Related Search

Related Contents