Get data from a subreport into the main report

reporting-servicessubreport

I have made one main report containing a few subreports. At the end I would like to compare some figures from the different parts of the report and also make some calculations with numbers received from the different parts.

Does anybody know a way to get values from the subreport into the main report? All calculations e.g. aggregates that will be made at the end refer only to the dataset for the main part and the other subreports have their own datasets, fetched from other tables.

Best Answer

I must second @JoaoLeal's comment, I think the method you propose (retrieving data from a subreport in the main report) is technically not possible.

However, there's another way to achieve what you want (show aggregate info on the data displayed in subreports). You could encapsulate your dataset queries in a way that they can be reused by the main report. There are two main/basic options:

Use a stored procedure to query the data
Use a database view for the data

Your datasets will be very simple: the subreports will select all the data. The main report can then either have a dataset query that aggregates data appropriately from the view / proc, or also retrieve all results and do the aggregation in SSRS.

Related Solutions

Node.js – How do create couchdb design docs with Nano in Node.js

Simply use the db.insert function.

db.insert(design_doc, '_design/design_doc_name', callback);

Here's a more complete example (from tests/view/query):

  db.insert(
  { "views": 
    { "by_name_and_city": 
      { "map": function(doc) { emit([doc.name, doc.city], doc._id); } } 
    }
  }, '_design/people', function (error, response) {
    console.log("yay");
  });

If you are interested in learning some more check this sample or go on and read the CouchDB Guide

Best Answer

Related Solutions

Node.js – How do create couchdb design docs with Nano in Node.js

Related Topic