Solved

Microsoft SSRS question

Posted on 2012-04-09
2
419 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:
huslayer earned 500 total points
Comment Utility
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
Comment Utility
Thank you soory for getting back late
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

743 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now