Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Birt Report dynamic query filter
Birt Report dynamic query filter [message #1690137] Wed, 25 March 2015 12:57 Go to next message
Prathyush S is currently offline Prathyush SFriend
Messages: 10
Registered: February 2015
Junior Member
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 16:29 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.


Michael

Developer Evangelist, Silanis
Previous Topic:How do I use a Web Font with a BIRT report?
Next Topic:Hide icons in footer based on PageNumber
Goto Forum:
  


Current Time: Sat Jul 20 14:09:05 GMT 2024

Powered by FUDForum. Page generated in 0.03439 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top