Solved

Microsoft SSRS question

Posted on 2012-04-09
2
429 Views
Last Modified: 2012-05-14
I have 2  matrix table . in a report layout. They have the same fields from the dataset in them.

there is a field in the dataset that is not in either of the tables that I would like to use to determine what record is display in each table


dataset
------------
A
b
c
d
version


if version is 1  then table A

table A

a  b  c  d

if version is 2  then table B

Table B

A B  C  d
0
Comment
Question by:TClevel
2 Comments
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 37825520
Hi,

you have 2 options:

1-you can create 2 datasets, one datset for each matrix,  and add a where clause to the query to limit each version to each dataset.
2-add a IIF condition on the visibility property of each of the matrixs, to display only it's version of rows.

use this link as an example reference for the same concept , http://lukehayler.com/2010/02/custom-visibility-toggling-ssrs-2008/
0
 

Author Closing Comment

by:TClevel
ID: 37964529
Thank you soory for getting back late
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

805 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