• Marek Vavrovic

SSRS Loan Statement

Using T-SQL Stored Procedure to create a report in Power BI Report Builder.


Data set: Using T-SQL to create a bank loan statement (mavaanalytics.com)


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



6 views0 comments

Recent Posts

See All