One report contain two tables?
Hello,
May I have two tables in one report?
I get error when debugging.
I check the xml code of the report.
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>
There are two tables here thus cause this problem.
Thanks for your help.