SSRS Only Returning First Row

Question

SSRS Only Returning First Row

ryan.h.maas

Old Hand

Points: 367
More actions
August 12, 2013 at 11:24 am

#395283

Hi all,
I am trying to get SSRS to display unique data for a unique ID. It's fairly straightforward, and I've done it before. But for some reason now it doesn't work. For example, I have an id which the user can choose, and a textbox that displays the name for that id. It should change with each different id, as should the other columns in order to display customized data, but they don't -the data matches the data returned from the first row and first row only. Any help or advice?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

AJ@SQL SSC Eights! Points: 811 More actions · Answer 1

Are you using a table and saying that it's a single value displayed again? Can you please elaborate further with a design view/example.

ryan.h.maas Old Hand Points: 367 More actions · Answer 2

AJ@SQL (8/12/2013)
Are you using a table and saying that it's a single value displayed again? Can you please elaborate further with a design view/example.

Yeah, sorry. I'll elaborate.

For example, say I have some ID, with a unique value. I want the SSRS columns (like MTD Value X, MTD Value Y, etc) to display data for that particular ID only. If I change the ID, the values in the columns should change to reflect the data for the new ID.

Does that help?

AJ@SQL SSC Eights! Points: 811 More actions · Answer 3

So My understanding is below, Please correct me if its wrong, or if I am missing anything, so can review further

1. You select an ID from a list (let's say Drop Down) and execute the report.

2. In the design you have a text box and a table.

3. So when you execute the report selecting the ID, the data in text box & table should change

ryan.h.maas Old Hand Points: 367 More actions · Answer 4

AJ@SQL (8/12/2013)
So My understanding is below, Please correct me if its wrong, or if I am missing anything, so can review further
1. You select an ID from a list (let's say Drop Down) and execute the report.
2. In the design you have a text box and a table.
3. So when you execute the report selecting the ID, the data in text box & table should change

That's exactly it. I know the SQL is correct since it has all the data for each unique ID and the correlating data. Currently I'm using the Lookup() function to return a result but there has to be a more efficient, and easier, way to do this. Thanks for responding, by the way.