I have a table in a database that i need to print in a data report. Sounds simple doesn't it.


I can do this in design time by createing a Data Environment and selecting the "sample" database manually. But the filename of the database will change while the program is running. Is it a good idea to use this "dummy" Data environment and change only the filename of the connection (if it's possible could someone tell me how), or should I scrap the "dummy" Data Environment and use some other method that's made for this type of thing.


If I can change the filename of the data environment connection, where does the code go. I've played around with this one and I can change the filename by changing property(7) in the connection but then I get errors saying that the data report can't find the rowset after it's changed.