Lesson 62: Build reports using Report Builder in SSRS

How to build reports in SSRS using Report builder

Firstly open report builder from report manager URL or from the local system.
Next when you open the report builder a dialog box appears where you can directly select a wizard to directly create a table, matrix, chart and Map.
If you want to directly create a report from scratch then you can choose blank report.

You can connect to the report server using connect option at the bottom of the wizard.

Once you get connect to the report server,you can use the files deployed to the report server.
You can directly create a data source in the report builder or you can use the data source present in the report server. As shown below you should select shared datasource and click on browse and connect to the server.

If you want to make changes to the existing report in the server and redeploy it again you need to first open the report by connecting to the server. In the file menu(2016 server) or ribbon(2014 server version) on the top left, Select open from servers and click on the report and then open it.

Once you make the changes click on the save or Ctrl+S it will be saved to the report server.
If you want to deploy the created dataset then you can choose Publish report parts from the file menu

Now choose second the option review and modify report parts before publishing

Next select created datasets using browse,select the folder in report server where you want to deploy and click on publish.

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 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.

My Tech Views

Search This Blog