Query result not showing in Crystal Report

[amir100]

Hi all.

I have a slight problem with Crystal Report. Currently Im using Visual Studio .Net 2002 with its embedded Crystal Report.

I have two different query, qry1 and qry2. qry1 has three criteria. That is criteria A, B, and C. qry2 has the same criteria with qry1 with and additional criteria D. So qry2 has criteria A, B, C, and D. Due to the lack of data variety both queries return the exact same result set. I know this because Ive already tested the query directly to the database server.

That result set are then used in a crystal report object. I tested qry2. The report are shown perfectly. But when I tested qry1. I didnt get anything. It turns out qry1 didnt return any result in the application. But as I mentioned before, both queries were tested directly to the database server and returns the exact same result set.

Can anyone help me on this matter?

 

[amir100]

Solved.

How?

I modified some of the data in the tables that get selected by both queries. Before both queries return 71 rows. After modification both queries return 70 rows. Now the result can be shown whether Im using qry1 or qry2.

A stupid workaround. I dont even know what the real problem was. Maybe theres compatibility problem with System.Data.OracleClient. Since Im using VS.Net 2002, System.Data.OracleClient comes separately.

Sigh.