Solved

ssrs Best Practice to include multiple matrix per detai

Posted on 2014-03-30
2
407 Views
Last Modified: 2014-05-11
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
Comment
Question by:canuckconsulting
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
edtechdba earned 500 total points
ID: 39964890
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
 

Author Closing Comment

by:canuckconsulting
ID: 40057392
Thanks!
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question