Our relational database is implemented using VPD (Virtual Private Database). Our old reporting software allowed for different connections to be created that point to the various database schemas created for VPD. (i.e. The nextfare_report schema points to all reporting data, nextfare_test points to all test reporting data, nextfare_production points to all production reporting data.) Each of the connections are then be assigned to the appropriate users.
Im having trouble figuring out how we would implement something similar in Crystal Reports so that if User A logs on to the web and runs reports he sees only the nextfare_test data. And if User B logs on then she only sees the nextfare_production data.
burkj (BOB member since 2010-06-16)