topic Re: Reporting.... in Application Development and Automation Discussions

Reporting....

Former Member — Thu, 26 Jul 2007 11:31:29 GMT

Hi experts,

i have two problems relating to reporting techniques...

1) how to reduce data redundancy for one report (means i dont want to display the same data as many time in one page...like for the customer 1000 i have records like kunnr,name1,ort01,vbeln,erdat,netwr...in this kunnr,name1 and ort01 are same so these fields display one time to a page)????????

2)I want to solve resolution problem to endusers PC(means in my PC i set a page for 35 lines but i dont know the endusers PC and his resolution ..but this report display as fit to his screen without overflowing )??????

Please send me code for the two problems ...if it is helpful i will give u 10 points.

Thanks in advance..........

Re: Reporting....

Former Member — Thu, 26 Jul 2007 11:44:38 GMT

If you r using alv report,you can use SORT for those fields that keep repeating thereby making the layout clear!

Regards,

Reema,.

Re: Reporting....

Former Member — Thu, 26 Jul 2007 11:46:32 GMT

Hi Rajesh,

you can use following syantax to delete dublicate record from internal table.

" DELETE ADJACENT DUPLICATES FROM itab. "

Re: Reporting....

varma_narayana — Thu, 26 Jul 2007 11:47:53 GMT

Hi...

Solutions for the First:

Loop at it_kna1 into wa_kna1.

AT NEW KUNNR.

WRITE:/ wa-kunnr.

ENDAT.

WRITE:/ WA-NAME1.....

Endloop.

Solutions for the Second:

REPORT ZZREPORT LINE-COUNT 35.

Here line-count means the No of lines per page in the Output.

This setting need not be changed for each users PC.

But if u want to dynamically set this option use.

NEW-PAGE LINE-COUNT 20.

<b>Reward if Helpful.</b>