V10 SSRS how to use an added table to dd

Mr. Habib: Thank you so much - I guess I am struggling a little with the join.  How are you defining the join to the main JobHead table?


Also - what does the T1 at the end of the statement mean/or do?


Thanks,


DaveO

I added the VendorPP table to the POForm DD and now I would like to reference VendorPP.Character01.


Any tips on how to add a table to the SQL query.  I see "T1.Company, T1.PONum"  I added a table "VendorPP" to the POForm DD.


Now I want to reference it in the SQL query in Report Builder 3.0. 


Anyone figured that out yet?


Thanks,


DaveO

Ph: 651-246-3281


I uploaded a doc to my onedrive with the basic steps I take after adding a new table to a Report Data Definition so that it shows up in the SSRS report.

On Thu, Oct 16, 2014 at 4:06 PM, daveolender@... [vantage] <vantage@yahoogroups.com> wrote:
Â
<div>
  
  
  <p></p><p><span></span><span>I added the VendorPP table to the POForm DD and now I would like to reference VendorPP.Character01.</span></p><p><br></p><span></span><span><p>Any tips on how to add a table to the SQL query.  I see &quot;T1.Company, T1.PONum&quot;  I added a table &quot;VendorPP&quot; to the POForm DD.</p><p><br></p><p>Now I want to reference it in the SQL query in Report Builder 3.0.  </p><p><br></p><p>Anyone figured that out yet?</p><p><br></p><p>Thanks,</p><p><br></p><p>DaveO</p><p>Ph: <a rel="nofollow">651-246-3281</a></p></span><p><br></p><p></p>

<p></p></div>
 


<div style="color:#fff;min-height:0;"></div>