CrossTab With Nested Chart - how unbind data?

I need to create a crosstab with for every value an nested chart, but the data for this chart comes from another dataset with some parameters from that row.

For the moment if i add a chart in the value cell, then it automatically bind it with the dataset (cube) from the crosstab, how can i unbind this?

Thanks for the help

Kind regards,
Sammy

Find more posts tagged with

Comments

mwilliams

Hi Sammy,

Can you recreate this issue with the sample database? Also, let me know what version of BIRT you're using. Thanks.

sammydepre

For example:

How can i add a chart under the quantity that tells me how many (quantity) products are sold per year.

Is that possible?

Kind regards,
Sammy

mwilliams

Sammy,

You want the chart in the crosstab? To have the chart in the crosstab, you'd have to have the fields you're wanting to use in your chart, in your crosstab. In this example, you don't have a date dimension to create a per year sold number.

sammydepre

Thats the problem, I only need for example from every row a key so i can execute for every row a new query with that key and that data i want to use in the chart

regards,
sammy

mwilliams

Sammy,

The report that you provide in this thread could probably be designed with just a table. With a table, you could probably embed a separate table bound to a different dataSet with the data for the chart in it. Now, maybe your report design isn't quite as simple as the one in your example report, so that may not work for you.