Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Access dataset from script
Migrateduser
I would like to take the data retrieved from a dataset, manipulate that data and then create a new report based on the resulting data. I've been digging as hard as I can but can't seem to find a way to do this. Is it possible?
Here's the situation: I have a very complex data set with multiple joins across 3 tables (for example: project, state and project_state_cross, where the cross table holds stateId, projectId). This is fine for a single parameter as I can just call a different dataset for each join group. However, I will have a dynamic multi-select input because the report must include details for many projects and because of the multiple many-to-many relationships, I end up with many rows for a single project, which is no good because I end up with this:
project id: 1
state: UT
project id: 1
state: WY
When What I need is:
project id: 1
states: UT
WY
What I think I need to do is to get the data from the dataset with the multi-select parameter and then manipulate that data into a POJO and shove the POJOs into a report and render that report. That seems to address the problems of not knowing how many rows there will be because I will know how many unique project ids are in a dataset and it allows me to be very flexible with the output, which is the goal of management.
I may be way off base here... I have been trying to do this in java with no luck so far.
Thanks in advance! I'm a total BIRT newbie and might be missing something very obvious.
Find more posts tagged with
Comments
There are no comments yet