Thursday, January 24, 2013 1:49 AM
Recently I'm doing a report that present a graphical layout (Warehouse layout) to my user.
What I have done is to create multiple Dataset with Multiple textbox assign to it.
However, the way that I'm doing is using multiple dataset that tags along with multiple textbox. I'm wondering, is these the recommanded way of doing? Or can i assign a parameter or formula to the dataset to retrieve every individual record.
Friday, January 25, 2013 6:33 AMModerator
From your description, you use multiple text-boxes to show multiple datasets in your report, right? If we use text-box to show the dataset data, then it will display the first record in the dataset. And we can use a parameter to filter data, or use expressions to control the visibility of the report items. Here has a MSDN document about how to filter data, please see:
If you have any questions, please feel free to ask.
TechNet Community Support
Friday, January 25, 2013 11:49 AMI'm not sure if I understand what you're asking. If your dataset contains more than one record and you want to display them all, you can use a Table, Matrix or List control: Tables, Matrices, and Lists (Report Builder 3.0 and SSRS)
MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
Check out my articles at BI: Beer Intelligence?
Monday, January 28, 2013 3:33 AM
As per attach picture, each individual textbox represent a dataset that return a single record that will reflect either green or red base on the status. Hence, I'm not sure whether parameter are able to use in this case.
As for why I'm not using table, matrix or list control is because I need to reflect the status of an individual record when the dataset return.
A textbox will be representing a parking lot. Hence, when dataset return back record, it will return all the parking lot record which i can't figure how to tag a textbox with a record. So ended up, I have came out with more dataset which will only return a single record that I am able to tag with a individual textbox. However, i believe that the way of doing this is not very efficient, so i need some advice from you guys.
Tuesday, January 29, 2013 9:25 AMThank you all for spending the time to read my question. Anyway, I have found the solution for my problem. I'm using the lookup function to look out for the specify value from the dataset. Thanks
- Marked As Answer by Kevinlky Tuesday, January 29, 2013 9:25 AM