有人知道我怎样才能避免这个错误或它意味着什么吗？
错误：Microsoft.Reporting.WinForms.LocalProcessingException
内部异常：Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException
（我将完整错误作为注释放在下面代码片段的catch块中）
这是我第一次尝试在VS2010中运行本地报表/报表查看器，但这种呈现方法每次都在爆炸式增长，而且谷歌似乎没有提供太多帮助。
你能找出明显的错误吗？
FYI没有显示的东西是一个非常简单的XSD，其中有一个datatable，它填充在用作数据集的代码中，还有一个rdlc文件（报表），其中有一个表，并且使用的数据源只有一个数据集（XSD）。
谢谢。
class Program
{
private const string UID = "myLogin";
private const string PASSWORD = "myPassword";
private const string IP = "myServerIPaddress";
static void Main(string[] args)
{
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
try
{
using (MySqlConnection con = GetMySqlConnetion("schools"))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = @"SELECT `venrollmentandmaxenrollment`.`classId`,
`venrollmentandmaxenrollment`.`NumberOfStudentsEnrolled`,
`venrollmentandmaxenrollment`.`NumberOfMaxEnrollments`
FROM `schools`.`venrollmentandmaxenrollment`;";
MySqlDataReader sessionReportReader = cmd.ExecuteReader();
DataSet1 dataSet1 = new DataSet1();
dataSet1.Load(sessionReportReader, System.Data.LoadOption.Upsert, dataSet1.Tables[0].TableName);
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = "C:\\VS\\TestReports\\TestReports\\Report1.rdlc";
viewer.LocalReport.DataSources.Add(new ReportDataSource(dataSet1.Tables[0].TableName, dataSet1.Tables[0]));
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
//TODO: do something with bytes, and drag this code back to the main application, once we get this working!
}
}
}
catch (Exception ex)
{
/*
LocalReport.Render always takes us here with this exception:
*
Microsoft.Reporting.WinForms.LocalProcessingException occurred
Message=An error occurred during local report processing.
Source=Microsoft.ReportViewer.WinForms
StackTrace:
at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings)
InnerException: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException
Message=An error has occurred during report processing.
Source=Microsoft.ReportViewer.Common
ExceptionLevelHelpLink=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=1.0
SkipTopLevelMessage=false
StackTrace:
at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.AbortHelper.ThrowAbortException(String reportUniqueName)
at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.CheckAndThrowIfAborted()
at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.FetchData(Boolean mergeTran)
at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.PrefetchData(ReportInstance reportInstance, ParameterInfoCollection parameters, Boolean mergeTran)
at Microsoft.ReportingServices.OnDemandProcessing.Merge.FetchData(ReportInstance reportInstance, Boolean mergeTransaction)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessOdpReport(Report report, OnDemandMetadata odpMetadataFromSnapshot, ProcessingContext pc, Boolean snapshotProcessing, Boolean reprocessSnapshot, Boolean processUserSortFilterEvent, Boolean processWithCachedData, ErrorContext errorContext, DateTime executionTime, IChunkFactory cacheDataChunkFactory, StoreServerParameters storeServerParameters, GlobalIDOwnerCollection globalIDOwnerCollection, SortFilterEventInfoMap oldUserSortInformation, EventInformation newUserSortInformation, String oldUserSortEventSourceUniqueName, ExecutionLogContext executionLogContext, OnDemandProcessingContext& odpContext)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory cacheDataChunkFactory, IChunkFactory yukonCompiledDefinition, Boolean& dataCached)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.Reporting.LocalService.CreateSnapshotAndRender(CatalogItemContextBase itemContext, ReportProcessing repProc, IRenderingExtension renderer, ProcessingContext pc, RenderingContext rc, SubreportCallbackHandler subreportHandler, ParameterInfoCollection parameters, DatasourceCredentialsCollection credentials)
at Microsoft.Reporting.LocalService.Render(CatalogItemContextBase itemContext, Boolean allowInternalRenderers, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup)
at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings)
InnerException: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
Message=DataSet1
Source=Microsoft.ReportViewer.Common
ExceptionLevelHelpLink=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsErrorCreatingDataReader&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=1.0
SkipTopLevelMessage=false
StackTrace:
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()
at Microsoft.ReportingServices.OnDemandProcessing.TablixProcessing.RuntimeOnDemandDataSet.Process()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)
InnerException:
*/
}
}
public static MySqlConnection GetMySqlConnetion(string DB)
{
string connStr = String.Format(
"SERVER={0}; Port={1}; UID={2}; PASSWORD={3}; DATABASE={4}; pooling={5};",
IP,
"3306",
UID,
PASSWORD,
DB,
"false");
MySqlConnection mycon = null;
try
{
mycon = new MySqlConnection(connStr);
mycon.Open();
}
catch (MySqlException ex)
{
Logger logger = new Logger("Test Reports App");
logger.Log(ex);
}
return mycon;
}
}
最佳答案
创建自定义类以将数据绑定到。
public class MyReportClass
{
public int ID {get;set;}
public string Name {get;set;}
}
然后使用
DataReader填充类//snippet
MySqlDataReader reader = cmd.ExecuteReader();
// add to collection
List<MyReportClass> myReportClassCollection = new List<MyReportClass.();
while (reader.Read())
{
// populate entity
var myReportClass = new MyReportClass();
// set properties, skipping DBNull checking for quickness
myReportClass.ID = (int)reader["ID"];
myReportClass.Name = (string) reader["Name"];
myReportClassCollection.Add(myReportClass);
}
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = "C:\\VS\\TestReports\\TestReports\\Report1.rdlc";
viewer.LocalReport.DataSources.Add(new ReportDataSource("myDataSource", myReportClassCollection));
关于c# - C#中的LocalReports导致Microsoft.Reporting.WinForms.LocalProcessingException，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/18623228/