May 16, 2013 at 7:19 am
I'm trying to display results from a query against a DB2 datasource as well as a query from a sql data source in the same table (report). Is this even possible? I'm trying to compare data to see if there are errors from the sql data source which inserts data into the DB2 accounting database.
May 16, 2013 at 8:51 am
Any given tablix can only be associated with one dataset at a time, but there are two ways to accomplish your goal that I can think of.
First, you could create two identical tables side-by-side that are designed to pull related data from each dataset together in the same order. When you run the report, if the data are synchronous between the two tables, you can visually confirm that there are no errors. If they appear out of sync, there is a problem to investigate.
Second, you can use the LookupSet function to pull related data from a secondary dataset into the context of a tablix associated with a the dataset. By using a Split function and by concatenating a vbCRLF as a delimiter for the string created by the Split function, you can create a set of "rows" that can mimic a table within a table.
May 16, 2013 at 9:20 am
Thanks!
I'll investigate the lookup function. I was pretty sure that only 1 dataset per tablix was allowed.
May 17, 2013 at 12:16 pm
Can the secondary dataset be from a completely separate Data Source? My first dataset comes from a SQL Server Data source while my second dataset comes from a DB2 Data Source.
May 17, 2013 at 3:09 pm
I don't know why not, though I have not tested that particular arrangement. But once the data are in datasets, I think the report would see it all the same.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply