foreign key field in report RRS feed

  • Question

  • I've been struggling with this for some time and I can't seem to find an honest, straightforward answer, so I'm posting my question here.

    Lets say I have a table Orders (OrderDate int, Amount money, StoreID int) and table Stores(ID int, Name varchar(50)) and that there is a foreign key constraint between Orders and Stores on StoreID. I want to make a report that will look like

    OrderDate       Amount       StoreName

    ------------       ---------       -------------

    I know how to do this using Inner Join, but is there any way I can do this by having a DataSet with those 2 tables and a relation between them, using Select on a single table? And then when I set my report's data source to be Stores table, somehow set field StoreID to have different data source, just like you can do with datagridview, combobox etc. When I add a second data source to my report, I can only select First(column) and Sum(column) for field expression.


    Friday, March 19, 2010 11:07 AM