Hello,
May I have two tables in one report?
I get error when debugging.
I check the xml code of the report.There are two tables here thus cause this problem.Code:<DataSet Name="Report"> <rd:DataSetInfo> <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod> <rd:DataSetName>Report</rd:DataSetName> <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod> <rd:TableAdapterName>BalancingSummaryDataTableAdapter</rd:TableAdapterName> <rd:TableName>BalancingSummaryData</rd:TableName> </rd:DataSetInfo> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText></CommandText> <DataSourceName>Report</DataSourceName> </Query> <Fields> <Field Name="TenderType"> <rd:TypeName>System.String</rd:TypeName> <DataField>TenderType</DataField> </Field> <Field Name="Amount"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>Amount</DataField> </Field> <Field Name="Ts"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>Ts</DataField> </Field> </Fields> </DataSet> <DataSet Name="Report"> <rd:DataSetInfo> <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod> <rd:DataSetName>Report</rd:DataSetName> <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod> <rd:TableAdapterName>VarianceDataTableAdapter</rd:TableAdapterName> <rd:TableName>VarianceData</rd:TableName> </rd:DataSetInfo> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText></CommandText> <DataSourceName>Report</DataSourceName> </Query> <Fields> <Field Name="Tender"> <rd:TypeName>System.String</rd:TypeName> <DataField>Tender</DataField> </Field> <Field Name="ActualTotal"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>ActualTotal</DataField> </Field> <Field Name="SystemTotal"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>SystemTotal</DataField> </Field> </Fields> </DataSet> </DataSets>
Thanks for your help.




Reply With Quote