-
Sep 12th, 2017, 04:50 AM
#1
Thread Starter
New Member
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
-
Sep 12th, 2017, 06:15 AM
#2
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.
-
Sep 12th, 2017, 06:57 AM
#3
Thread Starter
New Member
Re: Cross Tab Report
Hai, I nned to display data in the Cross table in crystal report
-
Sep 12th, 2017, 07:07 AM
#4
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.
-
Sep 12th, 2017, 07:18 AM
#5
Thread Starter
New Member
Re: Cross Tab Report
Please help anybody with this crosstab report
-
Sep 12th, 2017, 05:35 PM
#6
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|