asked on

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?

SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sherry

ASKER

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.

Sherry

ASKER

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

ASKER CERTIFIED SOLUTION

Sherry

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sherry

ASKER

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.

Jim Horn

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.

Jim Horn

> Any ideas on what to look for?
The asker didn't ask for a solution, only 'ideas', which were provided.

Sherry

ASKER

Thank you, I did forget the points

Sherry

ASKER

Thank you for the help.

Sherry

ASKER

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?