I want to select the active year where the value = 1. That currently is end year = 2016. I do not want any of the other columns that have...

These are not drilldown or subreports. These are independent reports.

What format is the most efficient for executing the best? subqueries, temp tables, or cte?

The user does not want to use the interactive sort. Due to that fact, would you show me other examples?

found answer

Would you show me the 'few calculated fields' in the dataset that I need in t-sql 2012?

TSQL is this part of my question

would you show me the t-sql? I am not certain how to setup the sql?

What other options do I have?

solved can use more than one dataset.

problem was solved. set t can grow to true.

what objects you place the filter on? I am assuming you are using the filter on the tablix and/or dataset. Can you show me and/or show me the places you...

Can't each embedded tablix filter the rows they need from the dataset by using a column called report_number? The value in each column will be for each embedded tablix.

I am told all unique reports are separate matrixes in the same rdl. I am going to have a parameter where you can select which report I want. However all...

What is EAV design? The date value needs to be used to keep the correct group of values.