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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
http://msdn.microsoft.com/en-gb/library/ms159121(SQL.90).aspx
Rob