I have a query to result in the below data from DB But actually, I want to get the data as Is there any way we can do this the SSRS? How can I do this? really stuck Answer You can do this easily in SSRS without changing your dataset. Add a Matrix control to your report Drag the Assignee
Tag: reporting-services
SSRS display text when image column is null
I’m trying to build a SSRS report that shows player name and their photos (if there is any). How do I display a text e.g.”No image” if image column return null value (or empty)? I’ve tried to do this in SSRS report itself but no luck : Any help is appreciated. Answer Assuming you get t…
Group-by and coalesce cannot be combined, gives an error?
I am creating an SSRS report and while making the data queries to it I got into this error. I do need the data set (Month to Date and Year to Date values) in one row connected with a group by command. This is the crystal report I’m referring to and converting to SSRS. The error I get is something
SQL -Pivoting a column from a table which have Unique records
I am trying to pivot a table to Row which have duplicate records on all columns but, a unique ID Named ([log_ID]) at the last columns . I wont log_ID field pivoted and given dynamic name as log_ID_1 ,log_ID_2 …etc FYI – THE log_ID’s is not static they change at every execution’s they c…
How to schedule biweekly SSRS subscription on 2017 report server
I would like my report to be sent biweekly on a Monday. Right now, I created two different subscriptions that sends the report on every 2nd and 4th week. I am not sure it would be accurate considering, I would like the send the report Monday after Pay period ends. What’s a best way to approach to this? …
Data is not inserted MSSQL Python
I am doing a python script to add text files into an MSSQL table. Using pyodbc, I’m doing it. The data is not inserted in the result. There is no error showing when running. Here is my code, Answer You’re missing a call to cnxn.commit() after the loops are done.
Power BI Report Builder Indicator Formula
I am adding in an indicator to a PBI Report Builder Report. The indicator is based off multiple fields from the dataset so I need to use a formula, to create the three up/down/side arrows. Previously in Crystal Reports this could be implemented using a series of IF statements as follows. The below example is …
Query to return all values from next month
I have a dataset of subscriptions in a table that looks something like this: Table: UserID Subscription_type Subscription_end_date I’m trying to build a report in SSRS that shows a list of all subscriptions that are going to expire somewhere in the next month. The report gets sent on the first of every …
SSRS Converting MultiValue Text Paramater into a String in SQL Syntax
I am being forced to use an ODBC source for SSRS report builder, source is Impala SQL, which doesn’t support the use of parameters. So I had to use a string builder function to get parameters into my script. This is working well, however the ask was to allow for multiple values in the text parameter. I …
SQL Report Builder: Issue with SUM in VarChar Column
I’m back with what is probably a very simple question but (as a SQL newbie) I can’t seem to figure it out. I’m basically running a fairly simple report for a hospital. They want a report that details …