Data issue with Oracle View & Crystal Report

[bubu2006]

Hi,

I am using one Oracle view to create Crystal Report. View is returning 9 rows where as report is only returning one records. I am no filter in the report, no group, no sort order nothing. Any one has any clue? The interesting thing is I have tried to create a table using that view and I have used that table to create report and that report returned 9 rows.

I am using Oracle 10g, Oracle Server Connection & Crystal Report XI.

This is very urgent. Can anyone help me?

Thanks,
bubu

 

[Turkbear]

Hi,
Are all the rows different? ( Just checking to see if the 'return distinct records' option is set).


Try the report using a command object that replicates the view you created...


Can you post the create view SQL?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bubu2006]

I have already tried to create command but that also failed. The rows are different. The issue was with a substring funtion. For some reason Crystal was not liking that.