Hi,
I try to find out if a user who is not in the administrator group can publish a report, without the need to go into CMS and adjust the settings for the Database or the Parameters.
The reports read from a SQL database and have mandatory parameters (date and numbers).
The endusers should be able to view the report on demand and be presented with all parameter prompts but not with the logoin information for the Database. I found that this is only possible if an administrator changes the relevant settings in the CMS (process, database, in Parameters: ensure that all parameters are set to null.
The publishing wizard allows to change the default values, however when I enter in the database logon password to avoid being prompted for the passwd at refresh time, then at the same time mandatory parameters must be filled out.
this has the effect that these parameters are not requested at refresh time and the report uses the values with which it was published. It should not be neccsessary that users have to explictly change the parameter values in infoview.
Is there any way that such a report can be published without the need to make adjustments in the CMC?
Many thanks,
Sunny
I try to find out if a user who is not in the administrator group can publish a report, without the need to go into CMS and adjust the settings for the Database or the Parameters.
The reports read from a SQL database and have mandatory parameters (date and numbers).
The endusers should be able to view the report on demand and be presented with all parameter prompts but not with the logoin information for the Database. I found that this is only possible if an administrator changes the relevant settings in the CMS (process, database, in Parameters: ensure that all parameters are set to null.
The publishing wizard allows to change the default values, however when I enter in the database logon password to avoid being prompted for the passwd at refresh time, then at the same time mandatory parameters must be filled out.
this has the effect that these parameters are not requested at refresh time and the report uses the values with which it was published. It should not be neccsessary that users have to explictly change the parameter values in infoview.
Is there any way that such a report can be published without the need to make adjustments in the CMC?
Many thanks,
Sunny