Multiple SSRS Rows Based on the Same Data Type - Line Chart

Question

I have a TSQL query that gives a month of data for some basic performance metrics. I show the data in a line chart. Now, I would like to add a few more parameters to the report to enable me to select data from two different months and display them in the same line chart for comparison. I don’t know where to start. Any ideas on how I should get the dataset and display in a line chart would be helpful. Any links that mimic expected results will also be helpful.

: , , @Hannover Fist , . , , - ! , , ! .

. , . , , .

Answer 1

( ), .

, . . AdventureWorksDW ,

select ..., 
datepart(day, fulldatealternatekey) as Day, 
left(datename(month, fulldatealternatekey), 3) as Month, 
sum(SomeValue) as SomeValue
from ...

(SomeValue), . . 5 (5, 10, 15 ..), , 1 ( ).

, , :

• . "" " ". ( SomeDate Date)

  = DatePart ( "d", Fields! SomeDate.Value)

• Group On .

• Series, Group Group. Label Group On

  = MonthName (Month (Fields! SomeDate.Value))

• , . :

  = Month (Fields! SomeDate.Value)

- , , . , , .

Answer 2

, , , .

, .

,

=FORMAT(Fields!Your_Date.Value, "YYYY-MM")

Answer 3

:

1) , .

2) , WHERE ( ).

3) .

4) .