Main > Forum > 1C:Enterprise Platform > 1C:Query language and DCS > Expand values as columns

Forum

Search UsersRules
Expand values as columns
#1
Active user
Points:: 0
Joined:: Oct 25, 2012

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?

Profile
#2
Guest
Points::
Joined::

Can you please illustrate your message?

Profile
#3
Active user
Points:: 0
Joined:: Oct 25, 2012

Sure

Profile
#4
Interested
Points:: 15
Joined:: Oct 27, 2011

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.

Profile
#5
Active user
Points:: 0
Joined:: Oct 25, 2012

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

Profile
#6
Interested
Points:: 15
Joined:: Oct 27, 2011

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

Profile
#7
Active user
Points:: 0
Joined:: Nov 19, 2012

Simon, here is example

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



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.