April 2, 2010 at 8:08 am
Hello all - I am having a challenge with some parameters in my report and I hope you all can help.
In my query I have these tables:
Opportunity
left outer join Employee
Some Opportunities have an Employee and some do not, this is not a problem.
In my report I have a parameter for Employee. By default all employees are selected and I want this to show all opportunities regardless if there is an employee or not. Then if I select some employees from the drop down I obviously just want those employee's opportunities.
My problem is that as soon as I introduce this parameter to my report I lose visibility of the ones with no employee. They are fine inside my query, but the parameter at the report level is excluding these.
Ideas?
April 20, 2010 at 1:33 am
Hi Pam,
It is bound to happen....you can use FULL JOIN.
Also can you provide some snapshots
Raunak J
April 23, 2010 at 5:31 am
If I use a full join wouldn't I lose my opportunities that have no employees? That is what I am trying to avoid.
April 23, 2010 at 5:38 am
Have you tried the query with FULL JOIN
Raunak J
April 23, 2010 at 8:02 am
you can have leftouter join put condition in sql if it null then assign default value in it.
April 23, 2010 at 8:48 am
mandavli, can you tell me more about how you would do if null and assign a default value? That is what I am looking to do.
April 23, 2010 at 11:26 pm
hello Pam,
You can use ISNULL(value_to_check,default_value)
So if value_to_check is NULL it is replaced by default_value else not.
Raunak J
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply