PowerBI SSRS Datasource connection issues
Hi,
I recently installed PowerBI Reporting Services which went fine. The issue I am having is the
…![SSRS]()
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of in...
Read more- 10.0K Content
- 2.2K Contributors
Expert Spotlight
IT Specialist
I am an accomplished Software Engineer specializing in Software Programming and Analysis.
Troubleshooting Solution
Advice Solution
How to render .xlsx file from an SSRS report via an SSIS Script Task?
I'm rendering an Excel file from an SSRS report via an SSIS Script Task. I followed the steps in
…
Troubleshooting Solution
SSRS Fill Expression
I am trying to write an expression that will fill the box green for the start of production, plus
…
Troubleshooting Solution
No carriage return when line value is null
In SSRS expressions, when Address Line 2 is Null, don't do a carriage return. Only do carriage
…
Advice Solution
Automate SSRS.reports
Is it possible setup SSRS reports to be scheduled? Can this be done as a SQL or Powershell scripts
…
Troubleshooting Solution
Why does the SSRS "Define Query Parameters" window pop up after opening a Dataset Properties?
I have an SP dataset that I have made sure that the parameters requested are in the SP. Yet each
…
Troubleshooting Solution
How to remove a 2nd certificate from SSRS report manager
I was trying to add a new certificate to SSRS report configuration. There was a certificate on
…
Troubleshooting Solution
Switch Function not working in SSRS
I am getting this error ....
"The value expression for the textbox ‘textbox16’ has a scope parameter
…
Troubleshooting Solution
SSRS Formula not working correctly. when checking for fields > 0
The SSRS goal is to sum and count (two separate formulas) that should have the same format and
…
Troubleshooting Solution
Powershell script to create new subscription with parameter having multiple values
Need powershell script to create new ssrs subscription with parameter having multiple values. Please
…
Troubleshooting Solution
SSRS Expression returns a '#Error' when it cannot satisfy the criteria.
Hello,
I have an SSRS Expression that calls a VB script that returns a message for the user running a
…
Troubleshooting Solution
SSRS Expression IIIf and IsNothing
Hi, I have an existing expression that would handle 2 values and works fine. I now have 3 values to
…
Troubleshooting Solution
SSRS - BC30179 Error when Compiling Expressions
Hello,
I'm getting an error when trying to preview a SSRS report.
'An unexpected error occurred while
…
Troubleshooting Solution
SSRS SQL Server Formula format or syntax is incorrect. Calculation fails with error.
I am getting a error in SSRS not sure why but this is the formula. Does anyone see what is wrong
…
Troubleshooting Solution
SQL SSRS Email Failures
All my SSRS reports are failing to send with this error "Failure sending mail: One or more errors
…
Troubleshooting Solution
Reading report server RDL's for datasources/datasets/refer
We have around 300+ report server rdl's to upload to a new server. I want to read all the data
…
Troubleshooting Solution
SQL 2012 Enterprise with SSRS
A client is currently running SQL 2012 with SSRS. They have a potential vendor who is suggesting
…
Troubleshooting Solution
How to comment out or notate a message inside an SSRS Expression
How to comment out an Expression in the expression window. Someone in my group is working on SQL for
…
Troubleshooting Solution
TSQL selecting MATCHING words and Rating percentage
Hi, I have a table with column Description and Keyword. Now i want to add a new column called RATING
…
Troubleshooting Solution
Dynamically select data from multiple databases in SSRS Report
Hi,
I work in an environment with multiple live databases that are required due to the way our
…Explore solutions and more
![SSRS]()
SSRSBack to the top
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.