Trouble linking report parameters to data set parameters. [message #1020873] |
Tue, 19 March 2013 00:44  |
Eclipse User |
|
|
|
I recently started doing BIRT reporting and am having a bear of a time with this. I have two tables connected with a left outer join, and am trying to set parameters. The customer needs to be able to input a Location and a Count Group to run the report for, or a % to run for all locations and count groups. In addition, they need to be able to enter a Start Date (tied to a field in the first table), and an End Date (tied to a field in the second table) and get results between those two dates.
Here is my problem: I have created the Report Parameters, and the SQL query. In all the documentation I could find on both IBM and Eclipse BIRT's websites it says enter a ? in the query where you want the parameter to enter, and when you go to the Parameters section of the Data Set editor you will have the Parameters already there (automatically created when you edit the query) and all you have to do is link them to the Report Parameters. IE:
SELECT *
FROM tbl_one
LEFT OUTER JOIN tbl_two
ON tbl_one.itemnum = tbl_two.itemnum
...
WHERE tbl_one.location LIKE ?
AND tbl_one.countgroup LIKE ?
Problem is when I add that to the query and go to the Parameters section, there is no auto created parameters. When I add my own Parameters and link them to the Report Parameters it just returns a blank result set, no errors or anything. I am holding off on figuring out how I am going to do the Date parameters until I get it working.
Any help would be greatly appreciated. If you need any more info just let me know and I will do my best to get it to you.
|
|
|
|
|
|
Re: Trouble linking report pa rameters to data set paramet ers. [message #1022145 is a reply to message #1020873] |
Thu, 21 March 2013 06:52  |
Eclipse User |
|
|
|
Andrew Trout <forums-noreply@xxxxxxxx> wrote:
[...]
> Problem is when I add that to the query and go to the Parameters section,
> there is no auto created parameters. When I add my own Parameters and
> link them to the Report Parameters it just returns a blank result set, no
> errors or anything. I am holding off on figuring out how I am going to
> do the Date parameters until I get it working.
>
> Any help would be greatly appreciated. If you need any more info just
> let me know and I will do my best to get it to you.
if you give each parameter a default value in the parameter dialogue you
should see a result when you run the query.
--
Colin Sutton
|
|
|
Powered by
FUDForum. Page generated in 0.05879 seconds