Changing the data source of report (.rpt) on the fly
I have a simple crystal report file (.rpt), which uses excel sheet as a data source. The source excel sheet file name varies very often. Is there any way to dynamically set the data source of the .rpt file before opening it?
I have developed a .NET library, by using which I can load the .rpt file and change the data source using excel vba script. This strategy insists to install dependent run time libraries in the target machine. I don't want to do it and looking for simple and straight forward technique to change the data source.
Thanks in advance.