?
Solved

SSRS 2008 Line Chart

Posted on 2012-09-12
1
Medium Priority
?
344 Views
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
      ,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

0
Comment
Question by:Davesm
1 Comment
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 38393952
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

839 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