Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Cross Tab Formula - Please help me Post Reply Post New Topic
Author Message
kavitha
Newbie
Newbie


Joined: 22 Apr 2012
Online Status: Offline
Posts: 1
Quote kavitha Replybullet Topic: Cross Tab Formula - Please help me
    Posted: 22 Apr 2012 at 5:03pm
Dear All,
 
How can i get the Cross Tab with Formula
Rows GL -> Code and Text
Colunms ->This Year Month like (2012 April - 2012 March)
                 Last Year Month like(2011 aPRIL - 2011 mARCH)
                 Variance Like (This Year Month - Last Year Month)
                 This Year This Month Like (2012 April - 2012 March)
                 This  Year Last Month Like(2012 March - 2012 Feb)
                 Varaince like (This Year This Month  - This Year Last Month )
                 This Year YTD Like (2012 April)
                 Last YEAR YTD like (2011 April)
                 Varaince (This Year YTD - Last Year YTD)
How can i get the Colunms values please help me
 
 
GL Code  Text 
    2012 2011 2012 2012 2012 2012
CONSOL GL   Feb Feb Feb Jan YTD Feb  YTD Feb
  CURRENT ASSETS 流动资产
10010000 Cash and bank balances 现金及其等价物 This Year Last Year This Year This Year This Year Last Year
10020000 Trade Debtors and Notes Receivables (3rd parties) 应收账款(第三方) Month Month Variance This Month Last Month Variance YTD YTD Variance
  Other receivables US$ US$ US$ US$ US$ US$ US$ US$ US$
10030000 Advance for property, plant and equipment 固定资产预付款
10031000 Advances to suppliers 预付账款(付给供应商)  -     -     -   
10040000 - WIL Due by holding/fellow subsidiaries (WIL) 控股/子公司应收款  -     -     -   
10040000 - WCL Due by holding/fellow subsidiaries (WCL) 控股/子公司应收款  -     -     -   
10041000 Due by associates 联合股份公司应收款  -     -     -   
10042000 Due by related party corporations 集团关联公司应收款  -     -     -   
10070000 Other current assets 其它流动资产  -     -     -   
10050000 Inventories 存货  -     -     -   
10060000 Tax recoverable 可返回所得税款  -     -     -   
10080000 Derivative financial instruments 以业务为基础的金融手段  -     -     -   
10090000 Financial assets held for trading 交易性金融资产  -     -     -   
10100000 Available-for-sale financial assets 可供出售的金融资产  -     -     -   
10200000 Held-to-maturity 持有至到期投资  -     -     -   
10210000 Gross amount due from customers for contract work-in-progress  -     -     -   
10220000 Development property  -     -     -   
  TOTAL CURRENT ASSETS 流动资产合计  -     -     -   
     -     -     -   
  NON-CURRENT ASSETS 非流动资产  -     -     -   
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.