Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to make crosstab report in crystal report

Hi all ,

I want to make a crosstab report in crystal report

my query is like this

select YearDate.year ,
(currentasset.currentaset / currentliability.currentliability  ) as CurrentRatio
,(currentasset.currentaset - Inventory.Inventoryaset / currentliability.currentliability ) as QuickRatio

from
(
select distinct YEAR(JDT1.RefDate) as year from JDT1
)YearDate left join
(
select YEAR(JDT1.RefDate) as year,sum(JDT1.Debit - JDT1.Credit ) as currentaset from JDT1,OACT 
where JDT1.Account = OACT.AcctCode 
and OACT.AcctCode = '11' 
group by YEAR(JDT1.RefDate) 
)currentasset on YearDate.year = currentasset.year left join
(
select YEAR(JDT1.RefDate) as year,sum(JDT1.Debit - JDT1.Credit ) as Inventoryaset from JDT1,OACT 
where JDT1.Account = OACT.AcctCode 
and OACT.AcctCode = '11.05' 
group by YEAR(JDT1.RefDate) 
)Inventory on YearDate.year = Inventory.year left join
(
select YEAR(JDT1.RefDate) as year,sum(JDT1.Debit - JDT1.Credit ) as currentliability from JDT1,OACT 
where JDT1.Account = OACT.AcctCode 
and OACT.AcctCode = '21' 
group by YEAR(JDT1.RefDate)
)currentliability on YearDate.year = currentliability.year  left join 


order by YearDate.year

So if i view the data in sql server it should be like this

Year   CurrentRatio   quickRatio
2006               501                 100
2007              600                  200
2008             700                   300
2009             900                   400

I want to make a crosstab with the column is year . the Year is dynamic according to the selection

So if i select the year from 2007 to 2009

It should be like this in report

2007                2008              2009
CurrentRatio                 600                  700                  900
QuickRatio                    200                   300                 400

How can i make it in Crystal report ?

I have use the template in crosstab crystal report, but there is not suitable.

Can i make manually. ?

Thanks in advance

Regards

KK

Former Member
Not what you were looking for? View more on this topic or Ask a question