topic Re: Interactive Report data overlapping or conflicting in Application Development and Automation Discussions

Interactive Report data overlapping or conflicting

Former Member — Fri, 18 Jan 2013 08:48:46 GMT

Hi, In Interactive programming report if on the first page(first list) of the output if I have data from 2 separate internal tables,one below the other how can they be made to work independent of each other so that the detail list(second list) output does not create conflict/overlapping between the output of list 1st and 2nd internal table of the first list.The 2nd List Output displayed data should come from mutually exclusive table 1 and table 2 of the first list and show mutually exclusive of each other results on the second list.

Re: Interactive Report data overlapping or conflicting

former_member392866 — Fri, 18 Jan 2013 08:57:08 GMT

Sankil,

use object oriented programming to resolve this one.

Take 2 screens for 2 internal tables and populate the data based on screens.

Hope this concept helpful to you.

Thank you.

Regards,

BALAJI.

Re: Interactive Report data overlapping or conflicting

former_member491621 — Fri, 18 Jan 2013 10:39:20 GMT

Hi Sankil,

Can you please elaborate your requirement? It is a bit confusing.

You just need to be a bit precise while displaying data.

If possible, please paste your code(would be helpful for me to get the requirement correctly)

Re: Interactive Report data overlapping or conflicting

Former Member — Fri, 18 Jan 2013 11:55:25 GMT

Hi, I have made profit report,its interactive report.In this report in the first page there is 2 internal table for infow and outflow. In the inflow suppose there is document no 1000 and in outflow also there is doc no 1000,2000,3000.when I am clicking doc no 1000 of inflow I get details of that document on second list. I come back to first list from second list using back button. Then I go to doc no 1000 of Outflow.The same detail data of doc no 1000 of inflow shows again here in spite of variable names are different for inflow and outflow since they come from 2 separate internal tables that are independent of each other but their data is displayed on the first list separately. We tried to clear data of inflow table using clear statement,but still details data of inflow table doc 1000 again displays for outflow table for doc 1000. How to resolve it.

Re: Interactive Report data overlapping or conflicting

former_member491621 — Fri, 18 Jan 2013 12:00:30 GMT

Hi Sankil,

Are you using hide in your report?? If yes, is the correct value passed to it?

One more thing, can you please put a screenshot of your output screen?

Maybe there is a problem in READ LINE.

Re: Interactive Report data overlapping or conflicting

Former Member — Fri, 18 Jan 2013 12:17:32 GMT

Hi Sankil,

For this you need to capture the field value by using get cursor field statement for this i am giving you a sample code once you try it.

At line selection.

get cursor field <field name> value <field value>.

if <field> = < field value >.

u r code what you want to display.

elseif <field > = < field value ( give field of the second table) >

and ur code .

endif.

Code is executed as follows :

cursor field value will be captured as per the first table or second table field selection by the user and the IF condition will be triggered if the field value is equal to captured value i.e in your case if the select 1000 from table one field value will be displayed and when you come back and click on second table 1000 then those field variables will b captured in < field value > coloumn.

Hope Useful.

Thanks.

Arun Kumar.

Re: Interactive Report data overlapping or conflicting

former_member225688 — Fri, 18 Jan 2013 13:06:11 GMT

Hi Sankil

Please check hide statement in ABAP and use it properly. that will resolve the issue.

HIDE dobj.

Effect

This statement stores the content of a variable dobj together with the current list line whose line number is contained in sy-linno in the hide area of the current list level. The data type of the variables dobj must be flat and no field symbols can be specified that point to rows of internal tables, and no class attributes can be specified. The stored values can be read as follows:

For each user action in a displayed screen list that leads to a list result, all the row values stored using HIDE - that is, the row on which the screen cursor is positioned at the time of the event - are assigned to the respective variables.
If a list row of an arbitrary list level is read or modified using the statements READ LINE or MODIFY LINE, all the values of this row stored using HIDE are assigned to the respective variables.

Re: Interactive Report data overlapping or conflicting

Former Member — Fri, 18 Jan 2013 13:52:43 GMT

Hi Sankil ,

May be in your case some clearing issue is there and please also check the HIDE statement that is it properly used ...... for what u want in the secondary list.

Every time press the back button and go again to secondary list the previous values should be clear before generating the new values .

I think it is not clearing that's why u r seeing some previous data as well.

and also check whether the checked value is getting correctly executed or not.

Clear the work areas , refresh the internal table before using them & check for check box value which u r selecting from the primary list is correct or not.

Hope this will help

Re: Interactive Report data overlapping or conflicting

Former Member — Sat, 19 Jan 2013 09:18:43 GMT

Hi Amit, I have tried but its not working and after using Refresh its wipe out the data.

Re: Interactive Report data overlapping or conflicting

former_member491621 — Sat, 19 Jan 2013 09:32:56 GMT

Hi Sankil,

You must not clear/refresh the values of tables on which the interactive reports work.

Just check if the values which you are hiding are stored correctly and also if they are retrieved correctly upon line selection.

Try searching the syntax of READ LINE which reads the lines from the screen.

Just for the sake of confirmation, why don't you post the code which is hiding the fields?? Also, post the code of reading the output screen values. It would be better to give you a correct solution.

Re: Interactive Report data overlapping or conflicting

Former Member — Sat, 19 Jan 2013 09:49:03 GMT

Hi, For Inflow table its showing proper but for Outflow table its showing the same value of inflow.

Re: Interactive Report data overlapping or conflicting

former_member491621 — Sat, 19 Jan 2013 09:54:09 GMT

Yes. I have read the requirement. But it is difficult to guess the problem this way. That is the reason i am asking you to post the code(declarations,the write statements for the fields and the section of the code which reads data from the output screen).

Help us to helps you through this

Re: Interactive Report data overlapping or conflicting

Former Member — Sat, 19 Jan 2013 16:34:24 GMT

Hi Sankil,

Did my code not work for you or did i get the question wrong ?

You will have a first list displayed with few details (table 1 ) followed by details of another table (table 2 and when you click on table 1 list secondary list should be displayed with details from table 3 and when you come back to first list and perform action on table 2 details from table 4 have to be displayed .

This is what i understood from your question.

Please clarify me if i understood the question wrongly.

Thanks

Arun.

Re: Interactive Report data overlapping or conflicting

Former Member — Mon, 21 Jan 2013 06:02:13 GMT

Hi , While executing report there are 2 tables, for inflow and outflow, when we are clicking any doc of inflow its show the detail list of that particular doc in second list and while clicking on outflow for same doc its showing the same details of inflow doc.EX Inflow Table Doc No 1000 after clicking its go inside of doc 1000 and show the detail of inflow. Outflow Table. Doc No 1000 after clicking its go inside of doc 1000 and show the detail of outflow but the data what we are getting its same as inflow data of doc 1000.

Re: Interactive Report data overlapping or conflicting

former_member491621 — Mon, 21 Jan 2013 06:06:38 GMT

Hi Sankil,

You have already told your problem. For proper responses, please show us the code

Replying this way is not helping you.

Re: Interactive Report data overlapping or conflicting

Former Member — Mon, 21 Jan 2013 06:40:00 GMT

Hi Sankil,

Write a IF condition and use cursor value,

At line selection.

get cursor field <field name> value <field value>. // Here you will capture the field value i.e consider you captured doc 1000 of table 1 and write an IF condition as follow :

if < field value > = < wa >. // Here field value is what you captured and your comparing with the work area value.

Read table 1 into work area 1 with key < doc no > = < wa >.

write :< Fields you want to display in secondary list >.

else if <field > = < field value ( give field of the second table) >

read table 2 into work area with key < doc no > = < wa2 >.

write : < fields you want to display from table 2. >.

end if.

I think this will be more useful.

Thanks