Basic Question..How to show all results form the the DataSet in SSRS?

  • Hello,

    In my SSRS I am pulling the results from a Stored Procedure.

    When I look into the Data View of the report and Execute the Query it gives me all the result,

    but when I go to the Preview and pass the parameter to the report it only gives me one result.

    The Layout view of the report has something like the following:

    =First(Fields!Field1.Value)

    =Sum(Fields!Field2.Value)

    Which does explain that it's only pulling the first or the sum of the columns.

    But my question is how Can I see all the results of the query which i see in the Data View.

    Thanks.

  • You need to use some sort of construct like a table matrix or list to get output all of your values...

    If you use the report wizard it should step you through setting the options for a fairly rudimentary report which you could use as an example.

    Also, at the below link you see a section to download more samples... It's the 2008 link but at the top there is a link to the 2005 version.

    http://msdn.microsoft.com/en-us/library/ms161542.aspx

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Thanks for your reply. How Can I mark your reply as the Answer?

    Do we do that like we do on asp.net forums?

  • Nope, no real to do that. We do appreciate that when you get some sort of resolution to whatever your issue is that you post back and let us know how you got it sorted. This will both let other posters know that the issue has been resolved and may help someone else who happens along later on.

    Glad that my suggestion helped.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply