Page 1 of 1
Table for scoring purpose
Posted: Tue Jul 07, 2015 2:44 pm
by 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 1553 times
Which component should I use to do that?
Thank you!
Re: Table for scoring purpose
Posted: Wed Jul 08, 2015 8:46 am
by 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,
Re: Table for scoring purpose
Posted: Wed Jul 08, 2015 2:03 pm
by 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.
Re: Table for scoring purpose
Posted: Thu Jul 09, 2015 6:30 am
by 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.
Re: Table for scoring purpose
Posted: Wed Jul 15, 2015 1:44 pm
by Jennypi
Hello,
Thanks but I cannot open your example, it's a visual studio file I think.
Re: Table for scoring purpose
Posted: Thu Jul 16, 2015 8:12 am
by 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.