Records not retrieved

[samson123]

I am using CR XI

I am having a strange problem. I have created a report using a test dB "Cust_test.mdb"

This how I connect to the database thru VB 6.0
*******************************
Set m_objconnectioninfo = m_objcrxReport.Database.Tables(1).ConnectionProperties
m_objconnectioninfo.Item("Database Name") = m_strDatabaseName
m_objconnectioninfo.Item("Database Password") = "TSec"
*********************

In my case, m_strDatabaseName = c:\Cust_test.mdb"

When I run this application against a production mdb file ("Cust_Prod.mdb") with exact same table structure and same password, the report does not retrieve any records. I do not get any error message.

I made sure the option "Save Data with report" is unchecked.

What could be wrong here ? Your help will be appreciatedd.

 

[samson123]

Guys I figured out the problem.. It was related to a field that was null ( in Cust_Prod.mdb file). The same field in my Cust..
I had a inner join link defined in the report. Hence it found records for the test dB. Inner Join link was the reason for not pulling the records. I changed it to left outer join and it worked...