Solved

Microsoft SSRS question

Posted on 2012-04-09
2
433 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
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…

749 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