Skip to Content
0
Former Member
Feb 10, 2011 at 04:31 PM

Crystal report require SQL login while ran on EDGE platform

32 Views

Hello Experts:

I created a crystal report to run in BOBJ Edge X3.1 info view.

I created the crystal against a OLB DB datasource. Every time it started to run it ask for SQL connectivity information, such as sa and password. I certainly don't want the user have to put in a SQL connectivity string in there before they can run the crystal. Some one had suggested to me to create the crystal against Universe, however we are talking some pretty complex SQL statement that the OLB DB is running against, So it is very difficult to create a Universe for that and could change very frequently. Is there a way in BOBJ to record connectivity information for specific databases or some else on Crystal report that I can store that information so user wouldn't need to ask that every time?