Page History

...

For this tutorial we will use an RDL that was created in Visual Studio containing a data set with the following query:Image Removed

SELECT Production.Product.ProductID, Production.Product.Name, Production.ProductListPriceHistory.ListPrice,
  Production.Product.DaystoManufacture
FROM Production.Product
  INNER JOIN Production.ProductListPriceHistory
  ON Production.Product.ProductID = Production.ProductListPriceHistory.ProductID

1. Place your curse in the cell A2 and click inside it. This is where we will insert the data marker. 
   
   
2. Click Data Markers on the Designer.NET toolbar and locate your data set from the drop-down list. 
   
   
   
   
3. Hover over your data set to see the fields that are available. 
    
4. Select the ProductId field to insert the data marker into cell A2. Your template should now look like this: 
    
   
5. Place your cursor in cell B2 cell and click inside it. 
   
   
6. Click Data Markers again, hover over your data set, and select the Name field. Your template should now look like this: 
   
   
   
   
7. Place your cursor in cell C2 cell and click inside it. 
   
   
8. Click Data Markers, hover over the data set, and select the ListPrice field. 
   
   
9. Place your cursor in cell D2 cell and click inside it. 
   
   
10. Click Data Markers, hover over your data set, and select the Days to Manufacture field. 
    
    
11. In cell A1 type Product ID, in cell B1 type Product Name, in C1 type List Price, and in D1 type Days to Manufacture.

...