VS2010 Crystal Reports在通过代码发送数据集时要求登录。 [英] VS2010 Crystal Reports ask for login when sending a Dataset via code.

问题描述

我在我的项目中创建了一个数据集（.xsd）和报表（.rpt）文件。我通过代码填充我的数据集，然后将其设置为报告的SetDataSource，它显示第一页罚款，但任何其他，如下一页或导出触发登录弹出窗口。

I've created a Dataset (.xsd) and Report (.rpt) files in my project. I fill my Dataset via code and then set it to the Report's SetDataSource, it shows the first page fine but anything else, like next page or export triggers a login popup.

我做错了什么？

        List<TBL_PAG_SEGURO_VENDASFields> list = controle.GetRelatorioAll();
        vendasDS ds = new vendasDS();
        foreach(TBL_PAG_SEGURO_VENDASFields item in list)
        {
            DataRow row = ds.Tables["vendas"].NewRow();
            row[0] = item.RAZAO_SOCIAL;
            row[1] = item.DT_VENDA;
            row[2] = item.TRANSACAO_ID;
            row[3] = item.SITUACAO;
            row[4] = item.NOME;
            row[5] = item.VALOR_VENDA;
            row[6] = item.DT_LIBERACAO_PAGTO;
            row[7] = item.HISTORICO_ALTERACOES;
            row[8] = item.DT_FINAL_SERVICE;
            ds.Tables["vendas"].Rows.Add(row);
        }
        ReportDocument reportDocument = new ReportDocument();
        string filePath = Request.PhysicalApplicationPath + "Recursos/Reports/vendasCR.rpt";                
        reportDocument.Load(filePath);
        reportDocument.SetDataSource(ds);
        crv_Vendas.ReportSource = reportDocument;

推荐答案

代码是对的，我做错了在报表中使用自定义连接设置数据集文件，重新创建它将数据集设置为ADO.NET Connection，并在Page_Init内部调用代码来解决我的问题。

The code is right, what I was doing wrong is setting the dataset file with a custom connection in my report, recreated it setting the dataset as ADO.NET Connection and making the code call inside Page_Init solved my problem.

这篇关于VS2010 Crystal Reports在通过代码发送数据集时要求登录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！