Solved

Microsoft SSRS question

Posted on 2012-04-09
2
437 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
[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 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying 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

This article describes a technique for converting RTF (Rich Text Format) data to HTML and provides C++ source that does it all in just a few lines of code. Although RTF is coming to be considered a "legacy" format, it is still in common use... po…
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

752 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