Solved

ssrs Best Practice to include multiple matrix per detai

Posted on 2014-03-30
2
396 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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…

751 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