The problem was in crystal reports itself.
The path was pointing to another file in another folder.
Had to open the file in crystal reports to change what database it was pointing to. Also did a refresh and after that everything worked beautifully.
you might want to check it again if you are saving data with report (thats why you have to Refresh every time to get new set of data) if you uncheck that option, it'll automatically show you the latest set of data.