Solved

SSRS 2008 - Input Parameters not applying for all objects on the report

Posted on 2010-11-18
4
366 Views
Last Modified: 2012-05-10
I developed a report, with a table and a matrix in it. And passing @startdate and @enddate as parameters to the dataset. When previewed, the table is displaying the correct data, that is within the daterange but the matrix is not considering the date range at all. Both table and matrix uses the same dataset.
Am i missing anything? Please assist.

0
Comment
Question by:nreich
[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
4 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 34173848
If you can use the regular table (tablix) and not matrix you will find it earier to work with.
0
 

Author Comment

by:nreich
ID: 34174761
Thank you planocz.

the first part of the report need to display the data in the regular table. But the summary of the report should be in matrix form (same as 'Cross tab' as in crystal reports). That's the reason i choosed 'regular table'  and  'Matrix'. Is it not posible to use one dataset for two objects?  
0
 
LVL 4

Accepted Solution

by:
BostonMA earned 100 total points
ID: 34175005
I'm guessing the matrix is missing  information because one of the rows or columns has a null.  Can you check to see if the data has null values in either the fields you are using in the rows/columns?
0
 

Author Comment

by:nreich
ID: 34175268
yes, you are correct. the problem is fixed. thank you.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server maintenance plan 8 64
MS SQL Conditional WHERE clause 3 49
SSRS 2013 - Finding Datasets/StoredProcedures 4 54
Section based report in SSRS 14 35
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

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