locked
One data set inside another RRS feed

  • Question

  • I have a list with data source A, which contains a ClientName, some dates, and a dollar amount.  This is all displayed within a list, one client per row.  I also have data source B, which also has ClientName and a list of notes about the client.  What I want to do is add another simple table in the SAME ROW as the table containing ClientName, dates, and dollar amounts.  When I go to add the table below my other information I cannot choose data set B as the source of my data.  I just want to add this simple table and automatically filter all notes from data source B to have the same ClientName as the current item in the list.  Is this possible?

    Thanks!

    Tuesday, May 13, 2014 5:03 PM

Answers

  • If you need to use a totally separate dataset (not datasource, that is the thing that connects to your database), inside a table, you might be better off creating a subreport.

    The subreport will have this dataset B, then you can drop a subreport into your main report table cell and pass the parameters through.

    Tuesday, May 13, 2014 11:39 PM