Results 1 to 6 of 6

Thread: Cross Tab Report

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2017
    Posts
    3

    Cross Tab Report

    I would like to display datas in my cross tab with date columnwise and location rowwise. Actually I am able to generate the report in this way. But if the date is not in the Transcation table,that particular date is not not coming inthe cross tab header .How can i able to generate with all the dates (Always 1 -31)

    Really I need a solution for this

  2. #2
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,034

    Re: Cross Tab Report

    Hi,

    dont know really what you mean.

    here a sample to fill columm Header with Day of Month

    Code:
    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
            Dim startp As Date = CDate("01.09.2017")
            Dim endp As Date = CDate("30.09.2017")
            Dim CurrD As Date = startp
            Dim datevalue As Date = CurrD
            While (CurrD <= endp)
                DataGridView1.Columns.Add(CurrD.ToShortDateString, CurrD.ToString("dd.MM.yyyy"))
                CurrD = CurrD.AddDays(1)
            End While
        End Sub
    regards
    Chris
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

  3. #3

    Thread Starter
    New Member
    Join Date
    Sep 2017
    Posts
    3

    Re: Cross Tab Report

    Hai, I nned to display data in the Cross table in crystal report

  4. #4
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,034

    Re: Cross Tab Report

    sorry I don't use crystal report

    I do have a crosstab query where I set the Days myself
    sorry it is in German but it might help

    Code:
    TRANSFORM Sum(tbl_VogelZaehlen.ZA_Anzahl) AS Menge
    SELECT Format([ZA_Datum],"yyyy") AS Jahr, Format([ZA_Datum],"mmm") AS Monat, tbl_Vogel.VO_BEZ_DE, Sum(tbl_VogelZaehlen.ZA_Anzahl) AS Gesamt
    FROM tbl_Vogel INNER JOIN tbl_VogelZaehlen ON tbl_Vogel.VO_ID = tbl_VogelZaehlen.ZA_VOGELID
    GROUP BY Format([ZA_Datum],"yyyy"), Format([ZA_Datum],"mmm"), tbl_Vogel.VO_BEZ_DE, tbl_VogelZaehlen.ZA_VOGELID
    ORDER BY Format([ZA_Datum],"yyyy") DESC , Format([ZA_Datum],"mmm") DESC , tbl_Vogel.VO_BEZ_DE
    PIVOT Format([ZA_Datum],"dd") In ("01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31");
    regards
    Chris
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

  5. #5

    Thread Starter
    New Member
    Join Date
    Sep 2017
    Posts
    3

    Re: Cross Tab Report

    Please help anybody with this crosstab report

  6. #6
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,927

    Re: Cross Tab Report

    Welcome to VBForums

    I've moved this thread to our 'Reporting' forum, as that is more likely to get the right answer to this question.

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