Expand values as columns

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

Pages: 1

Simon Foster	#1 People who like this: 0 Yes / 0 No Mar 22, 2013 12:51 PM
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?

Timofey Bugaevsky	#2 People who like this: 0 Yes / 0 No Mar 22, 2013 04:44 PM
Timofey Bugaevsky Guest Joined: Company:	Can you please illustrate your message?

Simon Foster	#3 People who like this: 0 Yes / 0 No Mar 22, 2013 04:56 PM
Active user Rating: 2 Joined: Oct 25, 2012 Company: Care Small Animal Hospital	Sure Attached Files Download summarytable.jpg (27.3 KB)

Alexey Gerasimov	#4 People who like this: 0 Yes / 0 No Mar 22, 2013 09:34 PM
Interested Rating: 32 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.

Simon Foster	#5 People who like this: 0 Yes / 0 No Mar 25, 2013 09:28 AM
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?

Alexey Gerasimov	#6 People who like this: 0 Yes / 0 No Mar 26, 2013 05:09 AM
Interested Rating: 32 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.

Aleksey Bochkov	#7 People who like this: 0 Yes / 0 No Mar 26, 2013 03:10 PM
Active user Rating: 4 Joined: Nov 19, 2012 Company:	Simon, here is example Attached Files Download 26.03.png (144.52 KB) Download 1Cv8.dt (14.17 KB)

Subscribe

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)