Expand values as columns



Common questions about 1C:Query language, Query builder tool and Data composition schema

#1
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Oct 25, 2012
Company: Care Small Animal Hospital

Aho!!!

I would like to create a summary table where column values should represent country of origin, rows - items and values - price. I really do not want to create this large amount of columns for each country. Is it possible to expand one column values to separate columns?

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Can you please illustrate your message?

 
#3
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Oct 25, 2012
Company: Care Small Animal Hospital

Sure

 
#4
People who like this:0Yes/0No
Interested
Rating: 33
Joined: Oct 27, 2011
Company: Abaco Soluciones S.A.

Where do you want to create this?

If this is a report, you should use Data composition scheme, cre ate table in settings section and select rows and column. It is automatically expandable.

 
#5
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Oct 25, 2012
Company: Care Small Animal Hospital

Yes, I'm using the Data composition schema. Could you show an example please?

 
#6
People who like this:0Yes/0No
Interested
Rating: 33
Joined: Oct 27, 2011
Company: Abaco Soluciones S.A.

Try to use a wizard in the settings section. The icon looks like a wand with stars.

 
#7
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Nov 19, 2012
Company: BizzSimple.com

Simon, here is example

Download 26.03.png (144.52 KB)
Download 1Cv8.dt (14.17 KB)
 
Subscribe