Question

I m trying to get the parameter of user name and replace its value with the session s username so I can pass to a Stored procedure inside the DRL to generate a table timestamp with this user name. The parameter "username" is one of the parameters of the RDL which comes with default value and I m trying to change it with the following code.

重置报告参数之一:

var userParameter = GetUserParameter();
if (userParameter != null)
{
    newParameters.Remove(newParameters.FirstOrDefault(param => param.Name.Contains(CurrentUserParameterName)));
    newParameters.Add(userParameter);
}

查询用户名称报告参数:

var paremeters = ReportViewer.ServerReport.GetEditableHiddenParameters();

//finds parameter by its name, pelase view const value in CurrentUserParameterName
var userParameter = paremeters.FirstOrDefault(param => param.Name.Contains(CurrentUserParameterName));
if (userParameter != null)
{
    userParameter.Values.Clear();
    userParameter.Values.Add(Utils.GetUserName());
}
return userParameter;

服务器报告参数:

ReportViewer.ServerReport.SetParameters(parameters);

报告发表后,我收到“用户名参数缺失价值”的信息。

当我对<代码>ServerReport.GetPara amounts()进行清点时,我可以看到,我确实有“用户名称”,但国家是“MissingValidValue”。

What am I doing wrong? Thanks in advance, Eddie

Answer 1

由于这一条款,我最终设法解决这个问题:

If you have specified available values for a parameter, the valid values always appear as a drop-down list. For example, if you provide available values for a DateTime parameter, a drop-down list for dates appears in the parameter pane instead of a calendar control. To ensure that a list of values is consistent among a report and subreports, you can set an option on the data source to use a single transaction for all queries in the datasets that are associated with a data source.

自2006年以来除了将其置于“违约值”之外,我还在“现有数值”选择中加入了默认价值,报告试图确认新届会的用户名称,该名称被列为“可用价值”。一旦我删除了“现有价值”中的数值,就必须验证我在编码背后提供的新的报告参数,报告必须成功完成。

友情链接