[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SSRS report won't show the data

Posted on 2014-01-15
10
Medium Priority
?
650 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
[X]
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
10 Comments
 
LVL 66

Assisted Solution

by:Jim Horn
Jim Horn earned 750 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?
1
 

Author Comment

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

Author Comment

by:Sherry
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.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Accepted Solution

by:
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
0
 

Author Comment

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

Author Closing Comment

by:Sherry
ID: 39829084
Thank you, I did forget the points
0
 

Author Comment

by:Sherry
ID: 41277904
Thank you for the help.
0
 

Author Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

656 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