SSRS report won't show the data

Posted on 2014-01-15
Last Modified: 2016-02-19
I have a single query that runs fine in SSMS and also runs in the Query in VStudio.  There's a dropdown query also, works fine.  But, when I run the report, I get nothing.  Two parameters, a persons id number and debt (from the dropdown.)   Any ideas on what to look for?
Question by:Sherry
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
LVL 66

Assisted Solution

by:Jim Horn
Jim Horn earned 250 total points
ID: 39782895
<wild guesses that's been correct before>

Any chance the Detail row (three lines in grey button to the right) in your Tablix control was accidentally deleted?  
Is your data set correctly connected to a Stored Procedure/View that contains this query?
Does the Data Set, Parameters, connect the two parameters the SP needs to the parameter prompts in the report?

Author Comment

ID: 39782909
Nothing's been deleted, but I'll recreate the tablix to be sure.  I just created this.  I can run the queries in VS and they both run fine.  Prompts for the parameters are there and it requests the parameters when I run the main query in VS.

Author Comment

ID: 39782920
Recreating the tablix didn't help.  Even if I add a text box for just the person's name, it won't show.
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!


Accepted Solution

Sherry earned 0 total points
ID: 39782998
Figured it out.  My dropdown query had only two fields.  A created row_number and the actual field "Debt_Type".  So it only saw the 0 and 1's.  I added another field to that query that also pointed to the Debt_type and in the part for the select all, I added a '0' as the Debt_type.  Then in the report parameter settings, I used the new field in place of the row_number and that fixed it.  Thanks

Author Comment

ID: 39785780
I've requested that this question be closed as follows:

Accepted answer: 0 points for slslusher's comment #a39782998

for the following reason:

I had someone here remind me of what I did.
LVL 66

Expert Comment

by:Jim Horn
ID: 39783019
So ... no points for troubleshooting advice?  

Contributing experts are not real wild on open-ended questions that end with 'Nevermind, I figured it out...', with nothing in the original question that would have helped get to that point, with no points awarded.
LVL 66

Expert Comment

by:Jim Horn
ID: 39785781
> Any ideas on what to look for?
The asker didn't ask for a solution, only 'ideas', which were provided.

Author Closing Comment

ID: 39829084
Thank you, I did forget the points

Author Comment

ID: 41277904
Thank you for the help.

Author Comment

ID: 41472429
I've finally gotten all my totals and they seem right.  But I'm using the following to format for hh:mm.  It's giving me an extra digit on the end and I can't seem to get rid of it.

=FORMAT(Floor(SUM(Fields!F_OneOnOne_Min.Value + Fields!F_CaseMgmt_Min.Value)/ 60), "00") + ":" + Format((SUM(Fields!F_OneOnOne_Min.Value + Fields!F_CaseMgmt_Min.Value Mod 60)), "00")

Any suggestions?

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question