I am generating a label from a data source in Excel, modifying the SQL statement with GROUP BY over the data read from the xls and printing multiple records on the same label. My idea is to change the file every time I have to print new labels. The only thing that varies is the data and the number of records. But I can't: it loses the connection parameters and doesn't access Excel. Even if I create a database connection with name...
If I restore to the initial xls there is no problem !!!!
Is that behavior normal? What is the use of being able to read data from a file if you can only print THAT file, and not another with the same characteristics but different data?