Creating multiple .qvw-Files with different sources
my problem is the following:
My customers are different companies, which use one of our programs. The data of this program is stored separate MS SQL - Databases for each company. All of those databases are located on our server. So it looks something like this:
Company A -> Database A
Company B -> Database B
Company C -> Database C
I've already created a QV-Application, into which I load the data from one of the databases.
Now I want to create a qvw-File for each company (or database), which looks exactly the same apart from the loaded data.
So I would like to have the same number of qvw-Files as there are companies.
Company_A.qvw -> Data from Database A
Company_B.qvw -> Data from Database B
This way, employees of every company would only see their own data.
The big problem is, when I apply changes to a qvw-File, it does not affect the others. For example, if I want to add a new object, I have to do this for each qvw-File seperately.
Is there a way to create multiple qvw-Files, in which only the script (or the source of the data) is different?
Otherwise I would have to load all data into a single qvw-File and create filters or something like that ...