SSAS – Why aggregation values are not changing for the hierarchical dimensions in Cube.
This issue normally comes when there is a problem in relationship between Dimension and Measure group. Go to the Dimension…
Month: July 2023
SSRS – How to print a same report for Laser jet printer as well as Dot Matrix Printer
A dot matrix printer is a type of printer that uses a print head that moves back and forth, striking…
Explanation of SQL Server Error Message – “String or binary data would be truncated”
The error message “String or binary data would be truncated” tells we are trying to put a longer string into…
SSRS – How to run large bulky report
If there is a case where we need to run a report which process large volume of data and we…
SSRS – How to remove the duplicate values from the report input parameter
If we are using ar eport parameter which is duplicate values. you can remove duplicate records by using T-SQL DISTINCT…
SSRS Report Subscription Issue – Parameters are not valid in subscription
If we get error parameters are not valid while subscribing the report in SSRS then we need to check Parameter…
Embedding a document in an SSRS report
If there is a requirement of embedding a word or pdf document in the SSRS then following alternatives can be…
SSRS Deployment Issue :Could not connect to the report server http://servername/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server
When we tried to run the reports from SSDT, all the reports working fine in SSDT but when we tried…
SSRS File Share Subscription Issue – An impersonation error occurred using the security context of the current user
When we setup SSRS File Share subscription to some shared location or local system then sometimes impersonation error occurred. We…
SSRS Issue – Unable to connect to Report Server page
We need to try the following to resolve the issue with Report Server page: 1) Go to the Reporting Service…
SSRS – How to resolve formatting issue(s) in reports after deployment.
After deploying the SSRS reports on Report Server, sometimes, Report formatting is not as expected. Following formatting issue(s) could occur…
SQL Server Case Sensitivity
SQL Server is, by default, case insensitive, which means the word “SQL SERVER” or “sql server” will be same for…