Table problem in VC

[arun_ev]

Hi,

I have a table to display the output of a query. First there are repeating textx in the table that i need to contain, the distinct operator does not work. Second the date format needs to be changed. Should it be done through any formula? Also when i create a input form, unless i use a Combo Box the input form does not work and the Value help table does not display the data but when selected and transferred a value will appear in the field.

Any pointers on this?

Arun

[arun_ev]

Hi Marcel,

First thanks for a quick repsonse.

1. The distint operator needs the fields to be selected on which this operation needs to be performed. Though i select the fields it does not show up. So the output table looks crappy.

2.The output of the Date field from the query is in Text format. How can i change it into DD-MM-YYYY format? Presently the query throws a text Output in the format YYYYMMDD.

3.When we are creating a Input Form i drag a line from the variable input and create the form. This when viewing does not produce any options for a user to select a input. So only when i define a combination box separately in a input form and then connet it to the variable port, then only it works.

4. The value help can only be created on an input field. Once the value help is created, when i click the button the output table is blank no data is visible. but when i select any row and click the done button a value appears in the box showing some value for the selection made. I am not able to understand where i am going wrong.

Thanks in Advance,

Arun

[Former Member]

Hi Arun,

there are a lot of problems with table, most of them will be fixed in SP10 according to SAP.

But now to your problems.

With the distinct operator I can't say anything.

The date format can be changed by a formatting option. The date field must be a date type. There can be an error, because I had some errors with input fields of the date type, which will be fixed in next SPs according to SAP.

To the other problems, you must give me more input, what does not work? I used value help in some models and it works fine.

Best Regards,

Marcel