Print Page - SQL help need

Title: SQL help need
Post by: kbasha2004 on 04 Nov 2009 01:31:07 PM

Hi All,

I need to display the value of QTY_4QTR data for PRIOR YEAR Quarter in the report.
Suppose if the user select year 2009, then the prvious year 2008 last quarter values should be displayed = "209" from table QTY_4QTR.

Table 1 -Year, Qrt
-----------------------
1970 ,Q1
1970 ,Q2
1970 ,Q3
1970 ,Q4
1971 ,Q1
1971 ,Q2
1971 ,Q3
1971 ,Q4
1972 ,Q1
1972 ,Q2
1972 ,Q3
1972 ,Q4
.. .. ,
.. ... ,
2008 ,Q1
2008 ,Q2
2008 ,Q3
2008 ,Q4
2009 ,Q1
2009 ,Q2
2009 ,Q3

Table 2 -- QTY_4QTR
-------------------------------
100
123
134
465
657
921
85
4566
38
102
94
7689
567
.....
....
103
405
667
209
408
289
567

Thanks in Adv,

kbasha2004

Title: Re: SQL help need
Post by: VisioX on 05 Nov 2009 05:22:31 PM

Why don't you combine these to tables into a new one on your databse? Would make it easier.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kbasha2004 on 04 Nov 2009 01:31:07 PM