SSRS 2008

  • Hello,

    I need help with select and displaying a sepecif row in my report.

    I have a dataset with many rows.I need to create a static report and display specific rows in that dataset.

    How can I choose a row based on a condition (on columns lets age =21 and name=John)

  • Put it in the where clause of your query

    WHERE age = 21

    AND name = 'John'

    Assuming you really don't just want to show 21 year olds named John but rather would want the user to select the age and name, create input parameters for your query such as @age & @name and then make your where clause like

    WHERE age = @age

    AND name = @name

  • Thank you. But this will not work for me.

    I will explain more, I need a way to force SSRS to display a specific value from the dataset at a specific row, using some sort of SELECT.

    I have one dataset that contains all my data.

  • If I have understood your requirements, you need to add a filter(s) to your dataset with conditions you describe and optionally parameterise them 😉

    gsc_dba

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

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