Using T-SQL Stored Procedure to create a report in Power BI Report Builder.
Execute dbo.sp_LoanAmount
@LoanAmount= 150000,, @RateOfInterest = 1.7, @TimePeriod= 20
(Rate of interest 1.7 = 1.7% Time period is in years)
This is the first and last page of the report.
Report Body.
Each parameter contains a default value. After running the report, it starts rendering straightaway.
Snippets:
="Generated at " & Format(Globals!ExecutionTime, "MM/dd/yyyy HH:mm:ss") & " UTC"
& vbCrLf & "Page " & Globals!PageNumber & " of " & Globals!OverallTotalPages
vbCrLf = line break; the rest are global variables.
="Rate Of Interest: " & Format((Parameters!RateOfInterest.Value)/100,"P2")
="Loan Cost: " & Format((Parameters!LoanAmount.Value * Parameters!TimePeriod.Value * Parameters!RateOfInterest.Value) / 100, "C0")
="Last Payment: " & Max(Fields!CalendarDates.Value, "DataSet1")
Conclusion
If you want to publish this report to Power BI services, you need PPU licence (premium per user).
13/04/2022 paginated reports are not available for Publish to Web. You can publish it only within your organization.
You must:
1. registre Power BI services in Report Server Configuration Manger
2. sing in in SQL Server Reporting Services
Comments