Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How can i get Cumulatives

Author  Topic 

sunny4
Starting Member

2 Posts

Posted - 2008-02-11 : 14:01:35
Here is my doubt .........

I have a view,from which i have to develop a report in Crystal Reports.

The Columns which i have are like this.........

Eff_year...........Risk......NMRates....etc......

I have to show different rows in Report.

In Risk field i have to show three seperate Rows based on high low and cumulative.....high,low can be obtained but how can i obtain Cumulative which is together of high and low.....

The same thing in EFF_year...which has 2007 and 2006...here too i need cumulative of those two years....

Please help me out.....



Thanks..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-11 : 22:40:10
Can you provide your table structures and some sample data?
Go to Top of Page
   

- Advertisement -