Date wise Report

[pkpandey]

Hi All

My requirement is to show the detailed data for the selected group date wise. For example when Code AO1 is selected it will show data from 01/05/2016 to 09/06/2016  continuously and for Code AO2 it will show data from 01/06/2016 to 09/06/2016 continuously. The data will show 0 for the missing dates for both the Codes as given below :

Code	cGroup	Dt	Amt
A02	A2	01/06/2016	10
A02	A2	02/06/2016	20
A02	A2	03/06/2016	0
A02	A2	04/06/2016	0
A02	A2	05/06/2016	0
A02	A2	06/06/2016	0
A02	A2	07/06/2016	25
A02	A2	08/06/2016	0
A02	A2	09/06/2016	40

[Gysbert_Wassenaar]

See this blog post: How to populate a sparsely populated field

Only instead of using peek to get the previous value you fill in 0 as value.

[anushree1]

hi,

Please check if the attached Solution solves the problem