Special Report logic.Help needed urgently

[anand1991]

Hi Experts,

I have a requirement where I need to use purchase order detail table F4311 and display the count of purchase order for a month range(This will be specified in processing option).
I need to categorize that purchase order into six categories whose AEXP falls in the specified range(AEXP ranges will also be specified in processing option)
For eg: If I enter in Proc option two AEXP values i.e. 100 and 500,then report should display a range where the count of DOCO's less than 100,100-500and >500 are displayed in three categories.I can do this report if user specifies only one month.If more than 1 month is specified<, I am unable to think of the logic.
Need some expert solution. I have applied sequencing on DOCO and level break on same.
I need to display count of DOCOs for that particular months and display it along with AEXP categorizing.

 

[Abhishek Chhajer]

What is the complexity with One month or two months or any? If you can do it for one month than it should be applicable for any date range. This will be part of your data selection only.
Rest logic will be same to same.

 

[anand1991]

Yes I can do it for more than one month too.But I get the DOCO count wrong for the next months.

 

[clmates]

Hi

You can always make this report a simple BI publisher excel template, then you will end with an excel dump of F4311 and there you can manipulate easily or also build a dynamic table for presenting the results

Regards

 

[Abhishek Chhajer]

It has to be coding issue in my opinion. Share your sequencing and Level break details.

 

[anand1991]

1st Sequence : DOCO
2nd : TRDJ

Level break footer on TRDJ

 

[johndanter]

Are you using PC variables in the level break? that could explain why only one month works

If you use BC values, it will be wrong. Maybe that's the issue ?

BC = Current record record
PC = Previous record read

Maybe your code is only seeing/using the one?

 

[Abhishek Chhajer]

I don't see only issue apart from why you are having LBF on TRDJ?

Check your data and see if we have different TRDJ for same DOCO?

 

[anand1991]

Yes Abhishek.We have different TRDJ for same DOCO