I am using 10g.i have one report.In that report query return 2 values but my table report shows only one value.Could you please let me know how it will take data from DB into report.
Same DB query while executing my sql developer it return
See here FF05 activity twice in DB query but my report have only one record.
Make sure the rpd is pointing to the correct database. (i.e the one on which you are running the query on sql developer).
Also, make sure you copy the entire query from query log. Often people copy only the select part and omit the with clause.