topic Re: Report showing diff. output in Application Development and Automation Discussions

Report showing diff. output

Former Member — Wed, 06 May 2009 07:50:34 GMT

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...

Re: Report showing diff. output

Former Member — Wed, 06 May 2009 07:54:44 GMT

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!

Re: Report showing diff. output

Former Member — Wed, 06 May 2009 08:05:32 GMT

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.

Re: Report showing diff. output

jaideepsharma — Wed, 06 May 2009 08:42:52 GMT

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,

Re: Report showing diff. output

Former Member — Wed, 06 May 2009 08:46:22 GMT

hi,

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

because the inconsistancy is come only by this..

Regards

Ritesh Jha

Re: Report showing diff. output

Former Member — Wed, 06 May 2009 09:10:13 GMT

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.