CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Cross Tab Report, Lables for summary field

    I am creating cross tab report in ASP.Net
    for stock ledger. In row i have
    select `Dept`, `Store` and in columns i have
    selected `month`. Summry fields are
    Opening_Stock,Net_Sales_Retails,Net_Sales,Pur chases, open_po, Purchase_returns,net transfer, shrinkage, Adjustments, Average_stock,stock_turns , Closing stock.

    My report is working fine with all summary
    fields monthwise.

    But how can i insert the lables for all
    summary fields. So that report should show me all lables with related data.

    Please help me.
    I tried all options.
    Thanks in advance

    It should look like this way

    Jan Feb Mar YTD
    Dept
    Store 015
    Opening stock 20 25 23 20
    Net sales at retail 10 15 13 38
    Net sales 8 12 11 31
    Purchases 13 10 5 28
    Open PO 0 0 5 5
    Purchase returns 0 0 0 0
    Net transfers 0 0 0 0
    Shrinkage 0 0 0 0
    Adjustments 0 0 0 0
    Average stocks 23 24 20 19
    Stock turns 0 .36 0.50 0.55 1.68
    Closing stock 25 23 17 17
    Store 015

  2. #2
    Join Date
    Nov 2004
    Posts
    1

    Re: Cross Tab Report, Lables for summary field

    Hi
    I also faced the same problem .
    I tried with Crystal Report 9, but could not find any solution for it ...I think there is no way to display labels over summary fields in cross tabs.
    To solve my problem I finally converted my datatable in the form I was getting with cros tab and then used simple report.
    After executing it looks like a cross tab report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured