Link to home
Start Free TrialLog in
Avatar of Mokwaja
Mokwaja

asked on

SQL Server Reporting Services - List Control - URGENT HELP PLS!

I have a List Control on my Report, but for some reason it only shows the data in the report for the 1st row.

So it doesnt look like it's looping the DataSet through all rows, only the first row. (Only showing contents of the 1st row in List Control, even though DataSet has more than 1 row) I suspect it's due to the Controls in the List Control that uses an Expression with =Fields!FieldName.

I see there's props on the List Control such as DataElementName and Instance Element Name, but I'm not sure how to implement this nor can I find examples or documation on how to do this.

Please give me an example or tell me how to fix this issue asap please!

Thanks,
Freddie
ASKER CERTIFIED SOLUTION
Avatar of shorak
shorak
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
see this link for some more info on working with List items

http://msdn.microsoft.com/en-gb/library/ms159121(SQL.90).aspx

Rob
Avatar of Mokwaja
Mokwaja

ASKER

Thanks for the quick response Rob. I had the settings exactly as what you said, but it still didnt work. Think I then cleared the DataInstanceName prop which I populated earlier and it worked. Not sure if it was that, that caused the problem