Solved

SSRS report won't show the data

Posted on 2014-01-15
10
627 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 65

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?
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

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 65

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 65

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

739 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