SSRS 2008 Line Chart

Posted on 2012-09-12
Last Modified: 2012-09-27
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
      ,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 
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 = 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

Question by:Davesm
    1 Comment
    LVL 22

    Accepted Solution

    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:

    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.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now