<div>
Tried that through just a query and ran into an optimzation issue.<br />
Although I am not familiar with it, the LOOKUP expression seems a possibility. &nbsp;I have no idea how to apply it. &nbsp;Can I get some Help with this?
</div>


<div>
<div class="content wysiwyg-content">
Current: (This works fine)<br />
<br />
I am using a line chart which currently utilizes data based on Dataset1 which is an Oracle query. These are all numeric fields. Which also has a date field as the Category Group.<br />
<br />
Desired:<br />
<br />
I want to add an additional marker to the line chart from Dataset2 which is an MS SQL query. I am attempting to use a text field.<br />
<br />
When I include the field different dataset in the chart properties as a series it continues to fail. &nbsp;Also, the MS SQL query uses a different date.
</div>
</div>


Current: (This works fine)

I am using a line chart which currently utilizes data based on Dataset1 which is an Oracle query. These are all numeric fields. Which also has a date field as the Category Group.

Desired:

I want to add an additional marker to the line chart from Dataset2 which is an MS SQL query. I am attempting to use a text field.

When I include the field different dataset in the chart properties as a series it continues to fail.  Also, the MS SQL query uses a different date.

Tried that through just a query and ran into an optimzation issue.
Although I am not familiar with it, the LOOKUP expression seems a possibility.  I have no idea how to apply it.  Can I get some Help with this?

How can I add a series from a different dataset to my line chart.

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.