none
Dataset Names

    Question

  • Is there a way to pull the Dataset name you are using into a report ?

    Thanks

    Richard

    Tuesday, November 19, 2013 6:08 PM

Answers

All replies

  • Need more explanation. Not sure what the ask is.

    "You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
    Please Mark posts as answers or helpful so that others may find the fortune they seek.

    Tuesday, November 19, 2013 9:53 PM
  • Hi Richard,

    In Reporting Services, data regions of the report are report items that display the rows of data from report datasets. Data from datasets can be displayed in a table, matrix, list, chart, or gauge data region.

    Data regions expand as needed to display the data from the dataset. Table, Matrix, and List data regions are based on the Tablix data region. A Tablix data region supports multiple row and column groups and with static and dynamic rows and columns.

    When adding data to data region, the corresponding dataset is bounded to the report. If you only want to add the dataset name to the report, you can add a textbox in the report and type the dataset name.

    Hope this helps.

    Regards,
    Heidi Duan

     


    Heidi Duan
    TechNet Community Support

    Wednesday, November 20, 2013 3:29 AM
  • Hi Richard ,

    To pull the Dataset name you are using into a report ?

    We have to either read the XML (rdl file) or query the ReportServer.dbo.Catalog

    http://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5c


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Wednesday, November 20, 2013 3:37 AM