Table for scoring purpose

[Jennypi]

Hello,

My database contains traits. For each trait is defined a dropdown list. Users can put their traits of interest in "trait profiles"
I'm trying to find the component which would allow me to display dynamically all the traits of a trait profile, with their authorized values.

Exemple:
Step 1: the report chooses the desired profile in a user form
Step 2: the report shows:

Sans titre.png (3.83 KiB) Viewed 1551 times

Which component should I use to do that?

Thank you!

[HighAley]

Hello.

If we understant you right, you could use a Data Band, put on it three Panels. On each Panel you could put a Data Band with necessary Trait.

Thank you,

[Jennypi]

hi

Thanks for your reply.
Actually, the trait list is dynamic. In my exemple, trait 1, 3 and 7 are retrieved, but if the user had selected another trait profile, the list would have been different.
My SQL query will retrieve all traits of the selected profile + their values.

Will your method work in that case? It seems to me that it would work only with a static list of traits.

Thank you.

[HighAley]

Hello.

Then it is better to use cross-tab component.

Also you could create report template in code. The sample project is in the attachment.

Thank you.

[Jennypi]

Hello,

Thanks but I cannot open your example, it's a visual studio file I think.

[HighAley]

Hello.

Yes, we sent you Visual Studio project. You can miss it.
You could try to use cross-tab.
To give you more detailed answer we need to see structure of your data.

Thank you.