| how-to question: use result set to iterate on other queries [message #119575] |
Mon, 30 January 2006 04:39  |
Eclipse User |
|
|
|
Hello,
We would like to use Birt to create reports on our issue tracking.
We'd like to quantify "design effort" (e.g. new and open issues),
"validation effort" (e.g. fiwed but unverified issues), overall effort).
As such we've identified queries on the database that reflect these
concepts.
We've made these queries with a parameter: e.g. the product on which we
want the info.
Somehow now we need to itterate over all products, which is another easy
query; and use the outcome of this query to repeat all above mentioned
queries and put the results in a graph.
My main question is: how do we go about to use the results of a product
query as the parameter on the above mentioned queries: do we create a
javascript data source or are there other and beter solutions.
Any help is welcome.
best regards,
Ruben
|
|
|
|
|
|
|
|
| Re: how-to question: use result set to iterate on other queries [message #123299 is a reply to message #122966] |
Thu, 02 February 2006 14:24  |
| Eclipse User |
|
|
|
Hi Ruben,
Let me confirm that this is indeed a limitiation before we make a feature
request. But if it the case, then it seems like a good request :) BRB.
"Ruben" <rsa@newtec.be> wrote in message
news:2d712dab1606db837de74d6ec4faf163$1@www.eclipse.org...
> Hello Paul,
>
> thanks for your input.
>
> Indeed the set-up I had built was using a nested table.
> It seems this is the only way of displaying data of 2 datasets close to
> each other.
>
> However the limitation of data in child containers being inaccessible to
> the parent container, and more general data in a report being inaccessible
> to objects not contained in the same table, seem very harsh limitations
> indeed.
>
> It implies that all data correlation one wants to set up, needs to be done
> on the database side.
> It seems that it would be great addition to a report tool that data from 2
> or more datasets can be correlated, as it is my opinion that it is just
> such correlation that most people want reports on.
> Just my 2 cents.
>
> Perhaps I should file a feature request to that extent ?
>
> Best regards,
> Ruben
>
> <Hi Ruben,
> <
> <I doubt I can be of more assistance but I'll just say I had a similar
> <problem once and it was because I had a table in a table (using 2
> different
> <data sets) and I think there is a known issue in BIRT about data
> <accessibility in child containers. I can't remember the scenario so
> perhaps
> <someone else can help further. Are you using nested tables?
>
>
>
|
|
|
|
| Re: how-to question: use result set to iterate on other queries [message #124441 is a reply to message #123337] |
Sat, 04 February 2006 11:29 |
| Eclipse User |
|
|
|
Ruben,
When you have nested tables, here's how the inner table gets a value from
the outer table to use in its query:
1) In the query of the inner table, use a parameter marker in the WHERE
clause. For example, WHERE custID = ?
2) In the data set of the inner table, create the corresponding data set
parameter. You must supply a specific default value for the parameter.
3) In the layout editor, select the inner table. Select Binding and bind the
data set parameter to the outer table's field whose value you want.
The BIRT online help provides a tutorial for creating such a report. Under
Help Contents, select BIRT Developer Guide -- Building a report with
subreports -- Tutorial 3.
Hope this helps.
-Diana
"Paul Reeves" <preeves@actuate.com> wrote in message
news:drtmq0$j33$1@utils.eclipse.org...
> Ruben,
>
> the nested table/grid issue doesn't appear to be a problem anymore. It was
> bug that was fixed awhile back. I just made a simple report that used both
a
> nested table and grid and used different data sets. It worked fine.
>
> I suggest you post what you did to achieve this:
> "with sub reports it seems that one can wire up the input for one query
> with the result of another query."
>
> Perhaps someone more knowledgeable than myself can then help you get to
the
> next step.
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.10228 seconds
Home