Skip to main content

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 .


Comments

Post a Comment

Popular posts from this blog

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.
Post a Comment
Read more

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, ...
Post a Comment
Read more