Every time you add a parameter field to your crystal report and make it a dynamic parameter the report requires you to re-enter your Sage login. Dynamic parameters are great in that the field selection is dynamically populated from the database, but its a pain to have to re-enter your login 3 or 4 times if you have 3 or 4 dynamic parameters on the report.
by: Robin S. | over a year ago | Reports / BI
Comments
I totally agree. Doing this over and over again, in the design and in the program execution, is getting really old!!
This was addressed with the Sage 100 2013 release. When creating your custom report use the connection string utilized on standard reports (not the SOTAMAS90 DSN or User Created DSN). John Nichols Sage