I have a report with, say, 10 sub reports.They're each connected to an oracle database via MS Access linked tables. I am usind Crytal Reports X, by the way.
My problem is that when I start the crystal report and refresh the data. I need to type in 2 different passswords(2 schemas in Oracle DB) about 10 times. I was just wondering if there is someway of centralising the connection, so that it just asks me twice and thats it!!
Thanks in advance.
~kingsley~
My problem is that when I start the crystal report and refresh the data. I need to type in 2 different passswords(2 schemas in Oracle DB) about 10 times. I was just wondering if there is someway of centralising the connection, so that it just asks me twice and thats it!!
Thanks in advance.
~kingsley~