topic report program in Application Development and Automation Discussions

report program

Former Member — Mon, 16 Jul 2007 05:26:19 GMT

my question.

a report program to display student information stud.no name percentage marks in 5 subjects,

my requirement is when execute the program it displays highest percentage in 3 subjects(maths,physics,chemisrty). which tables taken.

output is

stud,no name percentage (3subjectsonly)

101 xxxx 98

102 uuuu 87

103 ttt 76

how to write the start-of selection logic,

pls send the details report.

thanx and regrads,

priya

Re: report program

Former Member — Mon, 16 Jul 2007 05:38:48 GMT

First create a Transparent Table(ZTABLE) in SE11 with the fields like

Studentno, Name and 5 subjects, Keep Stduent no as primary key

and create table maintenance generator for this table and enter the data and save

Now the table is ready with data

Now write a program in SE38 by giving student no in the selection screen

and in the program write the select statement to fetch all the data from the Above Z table

data: itab like ztable occurs 0 with header line,

v_per type P decimals 2.

select-options: s_student for ztable-studentno.

Select * from ztable into table itab where stduentno in s_student.

loop at itab.

write:/ itab-studentno, itab-name.

v_per = ( itab-physics + itab-chemistry + itab-maths ) / 3.

write : v_per.

endloop.

This will display the desired output.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: report program

former_member189059 — Mon, 16 Jul 2007 05:40:07 GMT

types: begin of itype,

id type i,

name(60),

subj1 type i,

subj2 type i,

subj3 type i,

subj4 type i,

subj5 type i,

avg type i,

end of itype.

data: itab type itype occurs 0 with header line.

populate all your data here

write:/ 'studno, name, percentage (3subjectsonly)'.

loop at itab.

itab-avg = (itab-subj1 + itab-subj2 + itab-subj3 ) / 3.

modify itab.

write:/ itab-id, itab-name, itab-avg.

endloop.

Re: report program

Former Member — Mon, 16 Jul 2007 05:41:24 GMT

U will have all the data in internal table say itab.

loop at itab.

IF itab-mark1> itab-mark2 AND itab-mark1 > itab-mark3.

Clear l_mark

l_mark = itab-mark1.

ENDIF.

IF itab-mark2> itab-mark3 AND itab-mark2 > itab-mark.1

Clear l_mark

l_mark = itab-mark2.

ENDIF.

IF itab-mark3> itab-mark2 AND itab-mark3 > itab-mark1.

Clear l_mark

l_mark = itab-mark3.

ENDIF.

at e nd stud no.

itab1-studno = itab-stud_no.

itab1-name = itab-name.

itab1-mark = l_mark.

clear l-mark.

aoppend itab1.

clear itab1.

endat.

endloop.

Re: report program

Former Member — Mon, 16 Jul 2007 05:49:07 GMT

hi,

once you check any tables related to your requirement, if not you can create ZTABLE with required fields and fill that table before developing the report program.

after creation of Ztable, in report program..you follow these steps...

1) tables: Ztable "provide tables work area

2) create internal table based on output fields data.

3) in START-OF-SELECTION event you write the select statement like

select <required fields> from ZTABLE into table <internal table>.

4) while processing the internal table you calculate percentage and display the highest percentage...

   LOOP AT <internal table>.
            ****here write the logic for calculating percentage
       
   ENDLOOP.

regards,

Ashok Reddy

Re: report program

Former Member — Mon, 16 Jul 2007 06:03:31 GMT

Hi,

I am not getting u r exact requirement.

My quetion is , how many subjects totally are there.

1. in that table only 3 sub are there or

You want highest 3 sub marks in 5 sub marks?

Regards,

sarath

Re: report program

Former Member — Mon, 16 Jul 2007 06:14:23 GMT

hi, priya my understanding is that u want to display the the highest percentage in 3 some subjects ....what iam unable to understand is that whether u want the details of al the student or a particular student with highest percventage in the 3 subs.

Re: report program

Former Member — Thu, 19 Jul 2007 14:11:51 GMT

hi sarath,

they are 5 subjects, english,telugu, maths,physics,chemistry

but i want only 3 subjects percentages(maths,physics,shemisrty.)

i want logic how to write.

sum of 3 subjects using at loop i think.

Re: report program

former_member189059 — Fri, 20 Jul 2007 02:57:28 GMT

types: begin of itype,
id type i,
name(60),
maths type i,
physics type i,
chemistry type i,
english  type i,
telugu type i,
avg type i,
end of itype.

data: itab type itype occurs 0 with header line.

* populate all your data here

write:/ 'studno, name, percentage (3subjectsonly)'.
loop at itab.
itab-avg = (itab-maths + itab-physics + itab-chemistry ) / 3.
modify itab.
write:/ itab-id, itab-name, itab-avg.
endloop.

Note: if the marks are out of 100 then this will suffice, else multiply the avergage by 100 and divide by the total marks in that subj

eg: if it is out of 50 then avg * 100 / 50