Example #1
0
        void LocalReport_SubreportProcessing(object sender, Microsoft.Reporting.WebForms.SubreportProcessingEventArgs e)
        {
            DataTable dtFiles = new DataTable();

            try
            {
                string sContract_NO = e.Parameters["FO"].Values[0];
                string sStartDate   = e.Parameters["startDate"].Values[0];
                string sEndDate     = e.Parameters["endDate"].Values[0];
                dtFiles = data.msSQL.GetDataTable("select top 6 * from FC_File where DateIn>='" + sStartDate + "' and DateIn<='" + sEndDate + "' and Contract_NO='" + sContract_NO + "'");
            }
            catch (Exception)
            {
                //throw;
            }
            e.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("files", dtFiles));
        }
Example #2
0
        /// <summary>
        /// Método acionado quand for necessário processar um subrelatório.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void LocalReportSubreportProcessing(object sender, Microsoft.Reporting.WebForms.SubreportProcessingEventArgs e)
        {
            var parameters = new ReportParameterInfoCollection();

            foreach (var i in e.Parameters)
            {
                parameters.Add(new ReportParameterInfo {
                    AllowBlank = i.AllowBlank,
                    DataType   = (ParameterDataType)(int)i.DataType,
                    Nullable   = i.Nullable,
                    MultiValue = i.MultiValue,
                    Name       = i.Name,
                    Values     = i.Values
                });
            }
            var args2 = new Colosoft.Reports.SubreportProcessingEventArgs(e.ReportPath, parameters, e.DataSourceNames.ToArray());

            Document.ProcessSubreport(args2);
            foreach (var i in args2.DataSources)
            {
                e.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(i.Name, i.Value));
            }
        }