Need inputs in developing VC Model

[Former Member]

Hi All,

I have developed Basic VC Model. I need the below mentioned Changes. Could anybody help

a)column headings to show up : On the Layout have included Selection parameters and below that Table View for Query. At runtime when scrolling the records not able to see the column headings. Records are getting overlapped. Other doubt is can we have only one scrollbar, Instead of having scrollbars for page and table.

Can we make bold or change color for the Column headings.

b)Resize of window to fit data or is there any way to freeze the width for the columns.(After getting Output should not able to adjust the columns)

c)Font smaller so that all columns fit on one screen. Is this possible?

d)Results lines/rows (Overall Result, Result) to highlight includes keyfigures and characterstics

e) Supressing Repeated Values.

Regards,

Amit.

[Former Member · Accepted solution]

Hi Amit

You can do following settings for each of your doubts

a) Arrange Table size which will fit in the full screen & scroll bars will come only for table & not for the page. Max you can arrange size is 1024*768 Pixels.

b) Layout method of the iView & Table select 'Fit Width' Option.

c) You can arrange font through 'Expression box' for this you need to select 'Expression box' instead of normal input field in the table

d) This also you can do through 'Expression Box' with formula for the visibility condition.

e) This you can remove with the help of 'Filter Operator'

Regards

Sandeep

[Former Member]

Hey amit

the layout of the dashabord is something i have struggled with as well. the best option is to figure out what the standard resolution which is followed wihtin your company and buidl teh dashabord out accordingly.

I'ev noticed that the scorll bars get added on depending on your resolution as well as the overall monitor size of teh client viewing it.

also, it is good to be aware if you have nested iviews , they in general reshape themsleves to fit the parent iview, so you just need to amke sure your parent iview is smaller than the general viewing real estate you have to work with.

[Former Member]

Hi Sandeep - Can you please explain point 'e' and 'd' in details? How do we get to the 'Expression box'?

I have a VC model displays Profit Center as first column and Sales rep as second column along with other fields in a table and showing overall result and result row for each sales rep.

I want to highlight result and overall result rows. Don't want to repeat the profit center for each sales rep.

Thanks in advance.

[Former Member]

Hi

You cannot avoid repitation of 'Profit Center' in VC. It will come by default for all the rows. But you can highlight the results row for sure. What you need is -

1. Right click on the table & go to 'Configure Element'.

2. Select teh required field & go to the properties. Instead of Input field select 'Expression Box'

3. Go to the Styles Tab of expression box 'Enter Formula' for Results row.

4. Give Different colour for highlighting.

For details go to following link - http://help.sap.com/saphelp_nw70/helpdata/en/42/c2ba7f545e3116e10000000a1553f7/frameset.htm

Regards

Sandeep