Report showing diff. output

[Former Member]

Hi,

In report when i inserting the Document Number in selection screen...it display the correct data.. But when i m not inserting the Document Number, only insert Posting date of Document No..showing wrong data...

for ex...in selection screen i m inserting G/L Code, Document Number and Posting Date...then showing the Correct Data.(Value of field Base Amount : 5000).but when not inserting the Document Number, only Insert G/L Code and Posting Date, showing wrong data. .(Value of field Base Amount : 3000).

Please explain how it is showing diff. data....

Thanks...

[Former Member]

HI Kumar,

Is your Documnet number is parameter or selction-options.

try to use the initiality before your select query.

other wise you will get all the data from that posting date,

Thanks!

[Former Member]

Please try to understand use of document number in your logic.

How the same is effecting the data fetched from the database table.

This will surely solve your problem.

[jaideepsharma]

Hi,

If possible please send a snapshot of your code. In case if you are using document number as select option then you need to check whether it is initial or not before using it in select quey. When we use select options and if there is no value in it the query then will fetch all the data satisfying rest of the conditions in where clause.

KR Jaideep,

[Former Member]

hi,

check wethear u take all the key field or not..

because the inconsistancy is come only by this..

Regards

Ritesh Jha

[Former Member]

Hi,

Please specify how you are retrieving the data using function module or select statement.if you are using select statement please specify the select statement you have written so that you will get the solution for the problem.

Thanks,

Naveen kumar.