Hello you helpful people
I have just 'cloned' a report by changing the odbc data source it connects to which is simply a path to a different company on our business system server where the tables/ relationships/ data are identical.
This worked perfectly in that I now have my new report returning info from company 'B' in precisely the same manner as it does from company 'A'. I need to run both.
However when I try to schedule the new report it fails with the 'check the info on the logon tab' message and if I try to embed my odbc password for company 'B' via the properties tab of the report I get the message 'No logon is required for this report'.
But I know it does need one and I know its been set up.
Any ideas?
I have just 'cloned' a report by changing the odbc data source it connects to which is simply a path to a different company on our business system server where the tables/ relationships/ data are identical.
This worked perfectly in that I now have my new report returning info from company 'B' in precisely the same manner as it does from company 'A'. I need to run both.
However when I try to schedule the new report it fails with the 'check the info on the logon tab' message and if I try to embed my odbc password for company 'B' via the properties tab of the report I get the message 'No logon is required for this report'.
But I know it does need one and I know its been set up.
Any ideas?