Selection help-show all parameters even if no data

[pb100]

Hi, help!
I am running CRXI with SQL Server 2005 and use multi-value parameters for the user to select Names to include in the report. The Names table is related to other tables that have the data I need in my report. The report needs to output data for all the names selected, even if there is no data for that name in the other tables. How can I do this??? Is it a simple change to my selection formula (isnull({namedata}) then 0)?? Can't seem to figure this one out!!
-pb100

 

[MrBillSC]

The Names table needs to be the primary table that is used to link to other tables in the report. The link to the other tables should be a left-outer join.

MrBill

 

[pb100]

Thank you, makes sense, but I still am not getting all the names to show in the report. I am only getting names for which there is data. If there is no data, I still want to show the names with blanks instead of data. What else can I do?

So glad to have all this help out there!!

 

[lbass]

Remove any selection criteria you have on the tables to the right of the Names table.

-LB