Hello, I am using excel as a data source. The same file name is being used but I am updating the data on each refresh. I figured out that naming the Sheet1 to Sheet1$ allows me to move thru the issue of refresh when the data set changes. Now, the column data returns but in the wrong place on the report. The report has not changed. I am using CData excel driver for the odbc connection. What am I missing? Is there a better way to connect? Any suggestions is greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.