Please enable JavaScript to view this site.

thankQ Help

If another table is required e.g. a Lookup Table, this can be added to the existing report.

1.Right click on sqlDataSource1 under Report Explorer

2.Select Manage Queries…

TQ2REP~1_img80

3.Click Add

TQ2REP~1_img81

4.Click Run Query Builder

TQ2REP~1_img82

5.Locate and double click on the Table e.g. Tbl_Sourcecode

6.Click into the boxes beside the fields required eg Sourcecode

7.Enter an Alias name eg Source

8.Click OK

TQ2REP~1_img83

9.Click Finish

TQ2REP~1_img84

10.Click OK

TQ2REP~1_img85