Displaying the tablix structure for No data values in ssrs?

Question

I am working on a SSRS report in which I have a parameter with a list of names, In which a multiple value can be selected by the user. I gave title of the report using an expression where it shows "Result for SELECTED NAME" and applied page break such that each value is displayed on a new page.

But when i select all the values at a time, the report is only displaying the results for the names only for whom the data is available.

I would like to display the title as "Result for SELECTED NAME"(remember this is for the values with no data along with the values with data, each on new page) and tablix structure with a NoRowmessage.

I am really struggling on this since two days!!

Can any one help me?? Thanks Guys.

Answer 1

I think you should look at your query. Is your query returning a row for each name, or only rows where the names exist? If you can, change the structure of your query to return the names, left joined to your actual query.

Here's some simple code that captures the idea:

SELECT names.Lastname, names,Firstname, data.* 
from (select distinct name from name table) as names
left join (previous query) as data on data.nameID = names.nameID