Flat files

How to read all flat files in data set. I mean i have plenty of falt files with name as date.
If the user typed fromdate to todate i have to read the data of that files between that dates how to do it using birt?

Thanks,
ravi

Find more posts tagged with

Comments

Virgil Dodson

Hi ravi,

You can accomplish this with filters. The filters can be on the data set... or on the table in the report and can be compared against passed in parameter values like below. See the screenshot.

row["YourDate"]
Greater than on Equal
params["startDate"]

ravi8nz

Virgil,

Hi actually my problem is not reading single file. I have plenty of files the filename is dd-mm-yyyy. I have to read the files with name(suppose 29-2-2008 to 3-3-2008) and corressponding data in that files.

Let me know is there any possibility read in that way or with any customization code is it possible?

Thanks and Regards,
Ravu

Virgil Dodson

Hi again Ravi,

Perhaps you could use a scripted data source. In this way, you will always have a single data source, but that source could use Java to open as many files as necessary pulling in the data into a single data set.