I'm helping out on a project that is being phased out and moved to Access. It uses SQL Server so all of the Access tables connect to a remove (internal) server.
Part of the project requires launching various Crystal Reports.
I tried direct launch (shell "path.rpt") but it only launches Crystal in design mode.
I also tried "connecting" to Crystal in various ways but the best I could get was an error that said "invalid login".
Anyone have ideas about how to launch CR (maybe version 8.5...not sure since I don't have immediate access to the project) using a command-line switch (e.g. CR -r my.rpt)
Or using VBA to launch it (which references do I need)?
I don't mind building a separate viewer window, but I'd prefer to just launch CR. Users will have access to the network drive where the reports are located and should be able to view it using a shared user/pswd combination (which could be hard-coded as needed.)