Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Multiple Dataset Showing On Multiple Textbox

已答复 Multiple Dataset Showing On Multiple Textbox

  • Thursday, January 24, 2013 1:49 AM
     
     
    Sign In to Vote
    0

    Hi all,

    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.

     

All Replies

  • Friday, January 25, 2013 6:33 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Kevinlky,

    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:
    http://msdn.microsoft.com/en-us/library/aa337401(v=sql.105).aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Friday, January 25, 2013 11:49 AM
     
     
    Sign In to Vote
    0
    I'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
     
     
    Sign In to Vote
    0

    Hi all,

    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. 

    http://imageshack.us/photo/my-images/507/parkingm.png/

    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. 

    • Edited by Kevinlky Monday, January 28, 2013 3:34 AM
    • Edited by Kevinlky Monday, January 28, 2013 4:02 AM
    • Edited by Kevinlky Monday, January 28, 2013 7:49 AM
    •  
     
  • Tuesday, January 29, 2013 9:25 AM
     
     Answered
    Sign In to Vote
    0
    Thank 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
    •