topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Wed, 23 May 2007 10:53:23 GMT

hi gurus,

i wan to take select optins for the rage of 10 to 100.but i don't want to display the customers of 60 and 70 details.pls can u prove me the code.if use full full points.

thanx

lokanadhan.k

Re: reports

Former Member — Wed, 23 May 2007 10:57:22 GMT

Hi,

In the code u can write this :

S_TEST-SIGN = 'I'.

S_TEST-OPTION = 'NE'.

S_TEST-LOW = '60'.

APPEND S_TEST.

S_TEST = '70'.

APPEND S_TEST.

Here S_TEST is the select option u will be providing on the selection screen.

Say, user will enter range 1 to 100, then in ur code in START-OF-SELECTION

u can write the above coding and then in the select statement u can use this select-option.

Regards,

Himanshu

Re: reports

Former Member — Wed, 23 May 2007 10:58:36 GMT

Hi friend,

U can display all values from 10 - 100 but if u want to hide some values then u can use if else condition such that if u dont want to display the range it will be removed

Re: reports

Former Member — Wed, 23 May 2007 11:01:09 GMT

Hi lokanadhan ,

its very simple to do this. first go to the select option range in that u will have exclude and include ranges

where put 10 to 100 in include range and in exclude range give 60 to 70 .

so that exclude will always overwrites the include range,so this range 60 to 70 is excluded and from 10 to 100 ranges values will be displayed without displaying the ranges 60 to 70

sathish

Re: reports

Former Member — Wed, 23 May 2007 11:02:02 GMT

pls see below:


S_OPTIONS-SIGN = 'I'.
S_OPTIONS-OPTION = 'BT'.
S_OPTIONS-LOW = '10'.
S_OPTIONS-HIGH = '100'.
APPEND S_OPTIONS.

S_OPTIONS-SIGN = 'E'.
S_OPTIONS-OPTION = 'BT'.
S_OPTIONS-LOW = '60'.
S_OPTIONS-HIGH = '70'.
APPEND S_OPTIONS.


S_OPTIONS-SIGN = 'I'.
S_OPTIONS-OPTION = 'BT'.
S_OPTIONS-LOW = '10'.
S_OPTIONS-HIGH = '59'.
APPEND S_OPTIONS.

S_OPTIONS-SIGN = 'I'.
S_OPTIONS-OPTION = 'BT'.
S_OPTIONS-LOW = '71'.
S_OPTIONS-HIGH = '100'.
APPEND S_OPTIONS.

thx

pavan

Re: reports

Former Member — Wed, 23 May 2007 11:05:50 GMT

HI,

in the select-options give the range from 10 & 100 in the selection screen.press the arrow mark at the end of the select-options.select exclude range tab.there u can enter ur excluding range.

rgds,

bharat.

Re: reports

Former Member — Wed, 23 May 2007 11:09:18 GMT

hi aggarwal,

suppose if i'll write like this wil it work out.

intialization.

cno-low = 10

cno-high = 100

cno-options = 'bt'

cno-sign = 'e'.

if cno = 60 and cno = 70

message e000(i) 'correct the values'

Re: reports

Former Member — Wed, 23 May 2007 11:24:27 GMT

Here if CNO is ur select-options then

First of all CNO-SIGN = 'I' instead of 'E'.

Then this thing wont wrk if CNO = 60 or CNO = 70.

U shud write :

cno-low = 10

cno-high = 100

cno-options = 'bt'

cno-sign = 'i'.

append cno.

clear cno.

cno-low = 60

cno-options = 'ne'

cno-sign = 'i'.

append cno.

cno-low = 70

cno-options = 'ne'

cno-sign = 'i'.

append cno.

Regards,

Himanshu

Re: reports

Former Member — Wed, 23 May 2007 11:27:49 GMT

I AM NOT SURE WHAT YOU WANT...

BUT HERE IS ONE SOLUTION ...

SELECT-OPTIONS : S_KUNNR FOR KNA1-KUNNR DEFAULT '10' TO '100'.

AT SELECTION-SCREEN.

IF S_KUNNR-LOW = '10' AND S_KUNNR-HIGH = '100'.

S_KUNNR-LOW = '60'.

S_KUNNR-SIGN = 'E'.

S_KUNNR-OPTION = 'EQ'

APPEND S_KUNNR.

S_KUNNR-LOW = '70'.

S_KUNNR-SIGN = 'E'.

S_KUNNR-OPTION = 'EQ'

APPEND S_KUNNR.

ENDIF.

IF S_KUNNR-LOW = '60' OR S_KUNNR-LOW = '70'.

MESSAGE 'ERROR' TYPE 'E'.

ENDIF.

REGARDS

SHIBA DUTTA

Re: reports

Former Member — Wed, 23 May 2007 11:33:04 GMT

hi dutta,

while giving an input in select options it should exclude the values from 60-70.i think now it's clear for u.

thanx

lokanadhan.k

Re: reports

Former Member — Wed, 23 May 2007 11:37:04 GMT

do like this

S_OPTIONS-SIGN = 'I'.

S_OPTIONS-OPTION = 'BT'.

S_OPTIONS-LOW = '10'.

S_OPTIONS-HIGH = '100'.

APPEND S_OPTIONS.

S_OPTIONS-SIGN = 'E'.

S_OPTIONS-OPTION = 'eq'.

S_OPTIONS-LOW = '60'.

S_OPTIONS-HIGH = '70'.

APPEND S_OPTIONS.

goto select options screen and giv values 60 and 70 in single value list of exclude [ indicated by red color icon ]

if helpful reward some points.

with regards,

suresh babu aluri.

Re: reports

Former Member — Wed, 23 May 2007 16:13:48 GMT

hi dutta,

i need to exclude 60 to 70 records in my ouput list.wat u h've given is i think it's won't work it out.for my requirement.

thanx and regards

lokanadhan.k

Re: reports

Former Member — Wed, 23 May 2007 17:00:39 GMT

HI,

in the select-options give the range from 10 to 100 in the selection screen.press the arrow mark at the end of the select-options. You will get a screen with green single and muliple values and red with single and multiple values.

Input 60 and 70 in single red column one after the other. It will work.

Regards,

Senthil