May 10, 2012 at 7:11 am
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)
May 10, 2012 at 7:21 am
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
May 10, 2012 at 7:36 am
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.
May 10, 2012 at 8:53 am
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