Solved

SSRS report won't show the data

Posted on 2014-01-15
10
596 Views
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?
0
Comment
Question by:Sherry
  • 7
  • 3
10 Comments
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 250 total points
Comment Utility
<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?
1
 

Author Comment

by:Sherry
Comment Utility
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.
0
 

Author Comment

by:Sherry
Comment Utility
Recreating the tablix didn't help.  Even if I add a text box for just the person's name, it won't show.
0
 

Accepted Solution

by:
Sherry earned 0 total points
Comment Utility
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
0
 

Author Comment

by:Sherry
Comment Utility
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.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
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.
0
 
LVL 65

Expert Comment

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

Author Closing Comment

by:Sherry
Comment Utility
Thank you, I did forget the points
0
 

Author Comment

by:Sherry
Comment Utility
Thank you for the help.
0
 

Author Comment

by:Sherry
Comment Utility
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?
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only seeā€¦
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now