I got a 3rd party software (ERP system) which is going to be upgraded soon. We have a lot of external reports (using Crystal Reports) which are accessing the database directly.
Unfortunately the new ERP version changed the table names in the database, however they introduced new views with the same names as the old table names which return the same data as before.
But then I noticed that every single view got a WHERE clause like that one:
WHERE site_ref = CAST(CONTEXT_INFO() AS NVARCHAR(8))
where site_ref is a new column in the new tables.
I do know how to set CONTEXT_INFO in a sql script but unfortunately I do not know how to set CONTEXT_INFO in the connection parameters within Crystal Reports. I searched the internet a lot but did not find anything about that.
I wonder if there is any solution for my problem?