Skip to main content

Posts

Python classes to Ammu

Python uses dynamic typing, meaning you can reassign variables to different data types. This makes Python very flexible in assigning data types; it differs from other languages that are statically typed. We can use a colon(:) to perform slicing which grabs everything up to a designated point. s='Hello world' print(s[:5])=Hello we can use two colons in a row and then a number specifying the frequency to grab elements. For example: s[::2] 'HloWrd' s[::3] 'Hlwl' s[::-1] 'dlroW olleH' .split() is a Built in string method used to split the string, by default it takes the blank spaces s='please split this function' s.split() ['please','split','this','function'] Split by a specific element by using that letter s.split('f') ['please split this', 'unction'] We can use the .format() method to add formatted objects to printed string statements. print('Insert another string...
Recent posts

Lesson 68: Create Map reports in SSRS

How to create Map reports in SSRS First create a table which contains State name and Population as columns. Next insert a Map item in the report body. Next choose a source of spatial data by default Map gallery is selected and it is for USA.  Now in Map Gallery choose USA by State Exploded, we can see preview on the right. Next select Basic Map as the map visualization and in Data field select #STUSPS for abbreviated names of the state in the MAP. Now in order to assign the dataset, click on the Polygon drop down and select Layer Data, for assigning the Tooltip to display the population go to Polygon properties. In the Layer Data go to Analytical data and select the dataset and also choose the STATENAME, If more than one column is matching then choose others too. Also assign the tooltip as sum(population) in polygon properties At last choose Polygon Color Rule to change polygon colors.

Lesson 67: Join two datasets in SSRS by using Lookup function

How to join two datasets in SSRS by using Lookup function First create two datasets each one with a different datasource. Next insert a table in the report body and insert the required columns from the dataset1. Next in order to insert the columns from 2nd dataset, you need to write a look up function where you need to give the matching columns from both the datasets and the required column from dataset and scope as 2 datset Here since we are inserting the columns of dataset1 first, we are writing exp with scope as dataset 2.

Lesson 66: Export SSRS report to PDF format.

How to export the SSRS report to PDF format. Once you create a report and preview it, from the drop down list of options you can see an option as PDF, click on it to export the report in PDF format. When the list of columns is huge, by clicking on Print Layout you can see that some of the columns are moved to next page in such case, click on the Page set up and select the output type as Landscape and click OK. When you export the report in PDF format you can see that the groups are not toggled and you can't see the complete report information. In such case go to group properties and edit the visibility expression as follows.

Lesson 65: Export SSRS Report to CSV,Tab or Pipe Delimited File

How to Export SSRS Report to CSV,Tab or Pipe Delimited File After creating the report once you preview it and click on the drop down you can see CSV(comma delimited) export option, when you click on it the CSV format of the report is downloaded. Right click on the report and click on open with note pad, you can the output in the below format. If you wish to change the delimited format go to the report server location and open the config file and do the below changes Under the render tag create one more extension by the name Tab delimited as shown below and save the file. Once you refresh the report you can see the tab delimited option. If you are not able to see then stop the service and start again. If you want to see the Pipe delimited then edit the FieldDelimiter to pipe (|) symbol

Lesson 64: Export detail and Drilldown Reports to Excel

How to Export detail and Drill down Reports to Excel Firstly create a detail/drilldown report. We can export the created report in two ways. When you preview a report , when you click on the drop down we have various options to export. When you click on the Excel, the report is exported in xlsx format. The Second option is through the report manager. When you deploy the report same as in the preview tab we can see various options to export and you need to select Excel. When you export a drilldown report and wish to see each group in a different page with sheet name as group you can follow below steps. Go to properties of group in Row Groups and edit the PageName field to Group name and save the report. Also right click and go to group properties and and enable the Page break at the end of the group. When you preview the report you can see the region names as sheet names.

Lesson 63: Additional elements in Report builder

What are the new add ons in Report builder compared to SSDT. When you open the report builder and click on insert in the menu, you can see a chart wizard item which doesn't exists in SSDT. Here there is an option similar to report wizard for the creation of charts. While you create a dataset through the wizard in report builder you can add by clicking on the filters selecting the required column and 'is' operator is for single value, 'is any of' for multi value parameter and enabling the check box below the parameter.