I need to show WTD, Previos WTD, MTD , Previos MTD ,YTD , Previos YTD all in one report
I have created the cube . But I I am not able to put everything on one report. I can create separate reports for each .
I am using SQL Reporting services.
Any ideas as how i should do this?
thanks
I need to show WTD, Previos WTD, MTD , Previos MTD ,YTD , Previos YTD all in one report
I have created the cube . But I I am not able to put everything on one report. I can create separate reports for each .
I am using SQL Reporting services.
Any ideas as how i should do this?
thanks
Greeting.
I have a dataset (ORDER BY Column1) like the following in the data flow task pipeline
Column1 Column2
1 A
1 B
2 C
2 F
3 T
3 R
3 X
4 M
I only need data of 1, A;
2, C;
3, T
4, M
That is when Column1 value changes. I think we can store the column1 value in a variable as a previous row value. Then I can compare the variable value with the current row value and see if the column1 value changes. Can anyone please help me how to implement this? Or if there is other way to implement it
.
Thanks.