SSRS Hide Multiple Tablix and Return Only One Result Set.

Question

SSRS Hide Multiple Tablix and Return Only One Result Set.

Cawie

SSC-Addicted

Points: 445
More actions
July 13, 2016 at 9:08 am

#328202

Hi All,
I am new to SSRS and I need to build a report. Report has three different datasets, one to display updated records, deleted records and inserted records. We are pulling this data from three different SP and each SP has a StartDate and EndDate parameters. I need to add a new parameter in SSRS report named Operation with Insert/Update/Delete drop downs. Now I need to build a report in such a way that if any user selects a date range and select operation update then it should display results which are updated. Same way for Delete and Insert.
Any help is appreciated. Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

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

Thom A SSC Guru Points: 99143 More actions · Answer 1

Tablix's (and many other items), on SSRS have a visibility value. You can access it by right clicking the tablix, selecting Tablix Properties, and then going to the Visibility Pane.

As you're doing this based on a parameter, you could display "Insert" table by using the expression:

=iif(Parameters!Operation.Value = "Insert", FALSE, TRUE)

Hope that helps.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Cawie SSC-Addicted Points: 445 More actions · Answer 2

Thom A (7/13/2016)
Tablix's (and many other items), on SSRS have a visibility value. You can access it by right clicking the tablix, selecting Tablix Properties, and then going to the Visibility Pane.
As you're doing this based on a parameter, you could display "Insert" table by using the expression:
=iif(Parameters!Operation.Value = "Insert", FALSE, TRUE)
Hope that helps.

Thanks for the reply. Another question I am not able to display results when I execute the report. But if run the same SP in database it's displaying results. Any ideas??

Thom A SSC Guru Points: 99143 More actions · Answer 3

What do you mean you are are not able to? is the report showing no results, or is it erroring?

If it is erroring, then please paste the error here. If no results are being returned, then the SQL that SSRS is running is returning no results. Most likely the SQL statement is wrong, or way the sp is being called in incorrect.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Cawie SSC-Addicted Points: 445 More actions · Answer 4

Thom A (7/13/2016)
What do you mean you are are not able to? is the report showing no results, or is it erroring?
If it is erroring, then please paste the error here. If no results are being returned, then the SQL that SSRS is running is returning no results. Most likely the SQL statement is wrong, or way the sp is being called in incorrect.

Thanks Tom. I fixed it. The issue was Dataset was pointing to the wrong tablix. Changed that and pointed to correct one. Everything is working fine and looks good.

Thanks for your help.