SSRS 2008 Line Chart

The Below script gives me all my intake of apps, its then filtered at the bottom to show only  apps that were auto declined.

These applications are shown perfectly on the line graph in ssrs 2008 i would like to know is it possiable to show a second line on the same chart showing all the intake volumes with out the auto decline filter  



select a.Application_ID
	  ,CONVERT(Date, Application_Date, 103) as Application_Date
	  ,Convert(Varchar(10),Datename(mm,Application_Date)) +' '+ Convert(Varchar(10),year(Application_Date)) as Application_Month
      ,offer.Description
      ,case when a.application_ID in (select application_ID
									from POSTGRESQL.pyramid.[public].ap_applicant applicant
									where employment_status = 'SELF_EMPLOYED') then 'SELF_EMPLOYED'
			else 'SALARIED' end as ValueStream
	  ,case when indicational_decission = 'DECLINED' and score_type = 'APPLICATION_INDICATIONAL' then 'AutoDecline' Else 'NotAutoDecline' End As AutoDecline 
	  ,case when offr.existing_fnb_customer = '1' Then 'FNB_Client'  Else 'NON_FNB_Client' End As Existing_fnb_customer 
	  ,indicational_decission
	  
into  #Intake 
    

from POSTGRESQL.pyramid.[public].ap_application a
		LEFT JOIN POSTGRESQL.pyramid.[public].ap_offering_request AS offr ON offr.application_id = a.application_id 
		LEFT JOIN POSTGRESQL.pyramid.[public].lu_offering AS offer ON offer.id = offr.offering_id
		Left Join POSTGRESQL.pyramid.[public].ap_application_score score on score.application_id = a.Application_ID


Order by 2


Select *
from #Intake
where ValueStream in (@Valuestream)
	and Existing_fnb_customer in (@Existing_fnb_customer)
	 and application_date  between @StartDate and @EndDate
		and AutoDecline = 'AutoDecline'

Drop Table #intake

Open in new window

DavesmAsked:
Who is Participating?
 
Nico BontenbalConnect With a Mentor Commented:
It this what you are looking for. In this example I have a dataset that has the applicationid and the autodeclined field. In the chart I show lines for the total, the declined and the notdeclined values. This is done with an expression for the series like this:
=sum(iif(Fields!AutoDecline.Value="AutoDecline",1,0))

Open in new window

This results in a line that only counts the "AutoDecline" rows. This way I have taken the filter out of the dataset and into the line itself.
SecondLine.rdl
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.