Not getting the required output

[chander79]

Hi,

when i run the report through Apps, there are some records missing. I executed the same query in TOAD, which is used in the data model and got the result. But, when i run the same report through Apps, i am unable to get the result.

I even checked for format triggers, parameters and all other things. But, couldnot solve the issue.

i would be very much thankful if anybody helps me in this regard.

thanks,
Chander

[amitm_66]

Can you post the count of the query from report builder and toad for my reference along with the query and the parameter values that you are passing?