Lesson 53: Data Bar and SparkLine items in SSRS.

How to use Data bar and Spark line items in SSRS.

Data bar is a column chart or bar chart which is tiny in size and can be used inside the column.
Firstly create a datasource, a dataset and select required fields in the Matrix item.Click on the last column and insert a new column inside group.Right click on the insert column and Add a Data bar/Sparkline item as below.

Once the Data Bar or Sparkline item is inserted when you click on the chart area a Chart Data window pops up which is similar to the column chart chart data.

Now when you select value field in the value column and a category group for every row the category values are displayed in the bar. In the fig you can see for Asia there two bars when we categorised w.r.t country.

In the same way add a Sparkline item and select the required fields, If you want to change the data label of the spark line/data bar click in the data label and select series label properties. edit the exp as bellow.

Comments

Lesson 57: Auto refresh the report in SSRS

How to Auto refresh the report in SSRS. Firstly create a datasource,dataset and select the required fields into the table/matrix. If you want to refresh the report frequently for every second you can change the Auto refresh as 1 in the properties of the report. If you want to change the color of a field after given period of time to change the expression of the color in properties as a follows and set the Auto refresh time to the required period of time in the report properties.

12th Day

Conditional statement in SSIS: same as ternary operator in C ** <condition>? <true>:<false> Eg: Gender=="M" ? "Male": "Female" Multicast Transformation : This t/r creates multiple copies of i/p data. it is useful because every time we need not to go to source. ** This will improve task performance. Aggregate Transformation : It is used to convert the detailed values into aggregated data by using Aggregate functions like sum,avg,max,min,count etc. ** It is Asynchronous transformation. Example: to the i/p data from source group by deptno and perform aggregate funcs. Conversion in SSIS ; * Conversion is very important because data from flat file, excel comes to transformations in the form of string(varchar) , so we cannot perform required operations so it require to convert data. 1) Directly at source level : ** Select flat file source, right click--> show advanced editor. ** Select i/p & o/p properties tab, ...

Lesson 60: Create folders and Data sources by Report Manager in SSRS

How to create folders and Data sources by using Report Manager in SSRS Firstly select the report manager URL from reporting services configuration and go to the reporting services home. Next click on New Folder option and create a folder for data sources, also create various folder for Data Sets and Reports. Now click on the Details view in order to move or delete multiple reports at once. For creating a New Data Source click on the New Data source in the Home and provide the connection string, also connect using a service account so that we can provide access to that service account and every one uses that service account for connecting to the database. Finally after adding/deploying a report, select manage from the dropdown and choose the correct datasource .

My Tech Views

Search This Blog