Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 661
  • Last Modified:

SSRS report won't show the data

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
Sherry
Asked:
Sherry
  • 7
  • 3
2 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<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
 
SherryDeveloperAuthor Commented:
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
 
SherryDeveloperAuthor Commented:
Recreating the tablix didn't help.  Even if I add a text box for just the person's name, it won't show.
0
Industry Leaders: 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!

 
SherryDeveloperAuthor Commented:
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
 
SherryDeveloperAuthor Commented:
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
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
> Any ideas on what to look for?
The asker didn't ask for a solution, only 'ideas', which were provided.
0
 
SherryDeveloperAuthor Commented:
Thank you, I did forget the points
0
 
SherryDeveloperAuthor Commented:
Thank you for the help.
0
 
SherryDeveloperAuthor Commented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now