Date field

[#1]

Hi all,

i am using four files as source to create a report,

one is the weekly generated file, remaining three are daily generated files.

so i want to show the report based on weekly generated report date. How can i remove or supress the remaining dates

exapmple: first file, aug10,aug18, aug25,aug31

second,third and fourth files: aug1,aug2,aug3,aug4.......aug31

all the dates are not required for the report, only first file dates data want to show.

all the files are having date fields,

what i have done is created a variable and assigned the weekly file date Field to it and used where condition to the remaining three files  that the date  should equals to variable value.

i am getting blank report

pls help me..

Thanks,

Sowmya

[tresesco]

Probably three things could give you what you need.

     -Create a logic for Week definition

     -Aggregate the daily values to get the weekly values based on that logic

     -Associate the files on week.