Eclipse Community Forums: BIRT » report parameters

Help

Home

Home » Archived » BIRT » report parameters(sql query in birt plus params)

Show: Today's Messages :: Show Polls :: Message Navigator

report parameters [message #1402314]

Wed, 16 July 2014 21:21

Daniel Hudson

Messages: 7
Registered: July 2014

Junior Member

Hi, I am hoping that someone will be able to assist me with setting up report parameters for Date from and then Date to. I have my data set virtually done I am not sure how to finish it of, do I need to specify the date from and to in the sql query and if so how because I don't want a fixed date range hence wanting to use parameters From and To. My query looks at a column named createddate, is it possible to have two parameters for one column or do I need to find another column in the table I'm working from and use that? I normally set params by writng 'and columnname like ? Then use % in the report param as a default value and this works fine. Just struggling with this date and can't get passed it. If you could help me that would be awesome. Thanks

Report message to a moderator

Re: report parameters [message #1402844 is a reply to message #1402314]

Thu, 17 July 2014 19:05

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

It should be something like:

select * from table
where date between ? and ?

Then, in your parameters area of the dataset editor, you'd link your two dataset parameters to two report parameters you've created in the data explorer (you can also do this from the dataset editor by clicking on the icon next to the linked to drop down when modifying a dataset parameter).

Let me know if I misunderstood something about your issue.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: report parameters [message #1403093 is a reply to message #1402844]

Mon, 21 July 2014 10:58

Daniel Hudson

Messages: 7
Registered: July 2014

Junior Member

Hi Michael,
I that once I've created the parameters and edited the query and I run the report in efacs I get a http 500 error. I have tried leaving the default value blank as well and also specified a date in both parameters but I still end up with the same outcome. When I run the report with the parameters set in BIRT it works fine. I know this isn't a forum for efacs related issues but just wondered if you had any ideas?

Report message to a moderator

Previous Topic:	Can't open a .doc file generated by B.I.R.T with ActiveX
Next Topic:	Parameter help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:08:05 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter