Create chart series from values in single record

[IanMcCarthy]

I have a master child relationship where the child data always contains a single record with a set number of values corresponding to the amplitude of sound at specific frequencies:

16Hz - 67dB
32Hz - 64dB
.
.
16KHz - 45dB

I want to display this data on a vertical bar chart (one chart one child record) (amplitude against frequency) but I'm unsure of how to convert the record data to a series.

Can anyone assist?

Thanks,

Ian

[Vital]

Hello,

You can use following trick. Create new calculated column in detail datasource. For example: CalcColumn. In expression type: Details.Relation.ColumnInMaster
After then you can specify ArgumentDataColumn and ValueDataColumn from details datasource. For example argument from detail datasource, value from CalcColumn.

Thank you.

[IanMcCarthy]

Ahh, felt the air move as that one went straight over my head...

The best I can follow it, it seems to be going the other way?

In case I wasn't to clear before:

For each master record I have (at present) one detail record.

The detail record has 11 fields (values).

I want to generate a bar chart from those 11 fields (values).

At present I don't see how to generate a single series from the 11 fields (values) on a single record.

So I end up with one bar chart per master record showing the 11 values of the one detail record for that master.

Not sure that's any clearer either, sorry

Ian

[Edward]

Hello, Ian.

Sorry, but it seems that we did not understand your task correctly. Could you please send a sample report with a data to support[at]stimulsoft.com and we would provide you with a solution.

Thank you.