Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

ssrs Best Practice to include multiple matrix per detai

I am using BIDs to design a customer summary report for a single customer.  Along with static details for the customer (name, address, etc) I intend to include some sales metrics on their performance as sketched below.

Sketch
The only way I know how to do this is using subreports.  I'm fine with this but was wondering if there is another method I could/should be considering.
0
canuckconsulting
Asked:
canuckconsulting
1 Solution
 
edtechdbaCommented:
Is this report executing a stored procedure in order to pull the data into the report? I have combined detailed and summary reports, by including the summary data into the stored procedure in order to avoid 1+ sub-reports. By this, I mean returning all data within one stored procedure.

The summary #'s would just be the same for every row returned within the stored procedure, but will display 1 summary value in the primary report.
0
 
canuckconsultingAuthor Commented:
Thanks!
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now