Hi Steve,
From your description, you're encountering some problem when try draging
two table's fields onto a chart report item inside a VS 2005 client
report(for reportviewer), correct?
According to the steps you mentioned, I think the problem here is due to
the SQL Server SSRS client report (also server report) only allow a single
dataset bound to a given report Item(such as Table, Chart ......). The
"DataSet" here is the SSRS specific dataset rather than .NET ADO.NET
dataset. You can think the "dataset" here a "resultset".
Therefore, for your scenario, if you want to display info on a single chart
from multiple resultset (from backend data storage's perspective), I
suggest you consider use a View to merge the columns in the two resultset
so that bind a single resultset(table in .net dataset) to the chart.
How do you think?
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
