By the below, you will learn how to install SSRS step by step to prepare it to get start and build your reports,
Below,it's the first lecture in SSRS course which is transfare how to install SSRS and configure it
You can download SSRS Package from Microsoft. click here
Able to update the existing SQL statement, you have to follow the below Steps :
You are Open to DashBoard Power BI Desktop
1- go to Query Editor Home>>Transform Data >> Transform Data
6- Then Close & Apply to effect on your Dashboard
Open up PowerBI Desktop and click on the Get Data button and select All on the left side. Click on the item labeled Folder and click Connect to continue
Now you are in the Query Editor. This is where the fancy query editing will work to our advantage. We could load all the data into one large query. However, depending on the size of your data sets or how you want to report your data this may not always be desirable. Instead, you may only want data from April, then May when the new data is sent next month.
Note: When using PowerBI desktop it is a good practice to name the files beginning with a YYYY-MM-DD file name. This makes it really easy when sorting and ingesting information into PowerBI. I have used other columns of information such as Date Accessed or Date Created before but have gotten inconsistent results as these dates can change depending on when a file was moved or copied from one place to another.
Click the drop down next to Name and sort the files in Sort Descending.
Now you’ll notice you have only one file selected which is our latest file from April. Click the Load File button found in the Content column.
We have completed the activities in the Query Editor and can now load the data. Click Close & Apply found on the Home ribbon. All our April data has loaded. by making a simple table we can now see all the data that was just loaded.
Now we will remove some data from our desktop folder labeled monthly data. Open the folder on the desktop labeled Monthly Data and delete the filed labeled 2016-04-01 April. You should now have a folder labeled Monthly Data with only two files in it, one for Feb and one for March.
Return back to Power BI Desktop and click the Refresh button on the Home ribbon. Notice now how all our data has changed. We are now looking at the March data because it is the most recent file in our folder based on the file name.
To verify this we open the query editor (Click the Edit Queries on the Home ribbon). Click Refresh Preview on the Home ribbon and finally select the Applied Step called Kept First Rows. This will reveal the month of March as our data source.
Now, every time you add a new file to our folder and refresh PowerBI the latest file (based on the naming convention we talked about earlier) will always be loaded.
Note: This method works great when your data source is coming from an automated system. The file format must always be the same for this to work reliability. If the file naming convention changes, or the number of columns or location of those columns changes then the query will most likely fail.
Good luck and thanks for following along.
1- Open the SharePoint Management Shell as Administrator.
2- Verify that you have the following memberships:
3-From the PowerShell command prompt, type the following syntax to enable Project Server Subscription Edition, 2019, or 2016:
Check for a Project Server Service Application
Check the service applications list for a Project Server Service Application.
To prevent row and column labels from scrolling out of view after rendering a paginated report, you can freeze the row or column headings.,
1- On the design surface, click anywhere in the table to display static members, as well as groups, in the grouping pane.
The Row Groups pane displays the hierarchical static and dynamic members for the row groups hierarchy, and the Column groups pane shows a similar display for the column groups hierarchy.
2- On the right side of the grouping pane, click the down arrow, and then click Advanced Mode.
3- Click the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the Tablix Member properties.
4-In the Properties pane set FixedData to True.
5-Repeat this for as many adjacent members as you want to keep visible while scrolling.
6-Preview the report.
3. Select the server by highlighting the row and select Next.
4. Click Add Features
<script type="text/javascript">
function CreateHierarchyChartControl(parentId, profileId, type, persistControlId) {
var i = profileId.indexOf("|");
var claimsmode = profileId.substr(i-1,1);
if((i >=0 ) & (claimsmode=="w"))
{
profileId = profileId.substr(i+1,profileId.length-i-1);
var initParam = profileId + ',' + type + ',' + persistControlId;
var host = document.getElementById(parentId);
host.setAttribute('width', '100%');
host.setAttribute('height', '100%');
Silverlight.createObject('/_layouts/ClientBin/hierarchychart.xap',
host,
'ProfileBrowserSilverlightControl',
{
top: '30',
width: '100%',
height: '100%',
version: '2.0',
isWindowless: 'true',
enableHtmlAccess: 'true'
},
{
onLoad: OnHierarchyChartLoaded
},
initParam,
null);
}
}
</script>