SQL Server Performance

create new dataset

Discussion in 'SQL Server 2008 Reporting Services' started by arkiboys, Feb 12, 2010.

  1. arkiboys Member

    Hello,
    I am running a stored procedure (sp) in the Data tab so that I can create a dataSet. of the reporting services 2005.
    This dataset returns too many fields in the result pane below.
    Question: I should really see these fields in the dataset window on the left hand side of the screen but it shows different fields.
    The fields in the dataset shown are not as same as the fields returned in the result pane
    Do you know why?
    Thanks
    arkiboys, Feb 12, 2010
    #2

  2. satya Moderator

    What for this dataset is being used?
    It is better to use the source table than the result set unless you want to work further on the results.
    satya, Feb 21, 2010
    #3

Share This Page