Eclipse Community Forums: BIRT » Birt Report dynamic query filter

Home » Archived » BIRT » Birt Report dynamic query filter

Birt Report dynamic query filter [message #1690137]

Wed, 25 March 2015 08:57

Eclipse User

I am new to Birt Report. I have get the all rows from the table(PostgreSQL DB) then generated the report it is working.My Data Set query is as follows.

Data set:

SELECT * FROM students ORDER BY id ASC

In "students" table have a column called "createdate"(date time stamp). Now I need to filter the rows based on the "createdate".

For example: my query like

SELECT * FROM students WHERE dateofinsert = '2014-12-18 12:22:23.71189'

How to get the rows? based on the dynamic date. Some one help me.

Re: Birt Report dynamic query filter [message #1690200 is a reply to message #1690137]

Wed, 25 March 2015 12:29

Eclipse User

You could do something like:

SELECT * FROM students WHERE dateofinsert = ?

This will automatically create a data set parameter (because of the '?'). Go to the parameters section of the data set editor, double click on the parameter, name it what you want, and click on the button next to the "linked to" field to create a new DateTime type report parameter to supply the date. That should do it. Let me know.

Previous Topic:	How do I use a Web Font with a BIRT report?
Next Topic:	Hide icons in footer based on PageNumber

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Mar 20 12:24:20 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter