Reporting Services

• Topics

  Started by

  Posts

  Last post

• Error: A FilterValue for the dataset "dsReportBody" includes an aggregate function.

  I am trying to add a filter to my report dataset. I want the filter based on the value I choose fro…

  NineIron

  2 replies

  9 years ago

  By: NineIron

• Report with multiple parameters.

  My report creates a patient list of radiology patients and has a parameter for ExamType, Location, …

  NineIron

  5 replies

  9 years ago

  By: NineIron

• How to limit the results of one parameter drop down on the choice of another parameter drop down.

  How do I use one parameter to limit the list of values for another parameter?

  NineIron

  3 replies

  9 years ago

  By: NineIron

• Modify the default name of the Excel sheet in SSRS

  Hi all! I have been looking for this topics in the forum. It's true that exists several posts with …

  jorge_vicente

  3 replies

  9 years ago

  By: Thom A

• sorting to show only few values at the start of the column

  hi,How can we show only few values in the column at the top. Attached is the picture , I want to sh…

  komal145

  3 replies

  9 years ago

  By: komal145

• Scattered data into single line

  Hello,I attached the report.Right now I am getting data in different lines for each date. how can i…

  komal145

  3 replies

  9 years ago

  By: Lowell

• SSRS Parameter Not Working Correctly

  I've recently come across an odd problem with SSRS.  The report used multiple, multi-valued pa…

  Neil Burton

  2 replies

  9 years ago

  By: Neil Burton

• Show all group values

  Hello,I am grouping data based on a 1,2,3 group values but on one page of the report i have only gr…

  lukaszpiech

  4 replies

  9 years ago

  By: lukaszpiech

• Help with % calculation please

  Hello I am trying to get an output that will show me: Total number of deliveries missed / total del…

  faulknerwilliam2

  7 replies

  9 years ago

  By: faulknerwilliam2

• Combine two query codes

  In Microsoft SQL Server Report Builder 3.0, I have one report that, in part, supplies the total to …

  bzoom100

  2 replies

  9 years ago

  By: Mr. Brian Gale

• Video Guide

  Hi, I'm new to SSRS and looking for some good, short but comprehensive guide, preferably videos to …

  gfx99ne

  1 replies

  9 years ago

  By: doug.brown

• Using IN in a Where statement with and option of all

  I'm trying to use aWhere TS.Skill IN (@TS)and it works fine. 🙂The user can select one or …

  Ken at work

  32 replies

  9 years ago

  By: pietlinden

• Select only rows with Max date column

  Please help..I need to create an sql to select all rows with maximum date in a column,My sample dat…

  lein

  1 replies

  9 years ago

  By: Lynn Pettis

• SSRS Lookup Expression

  I have the following expression for a column. I am trying to hide the row if the result is " " or "…

  SQLPain

  1 replies

  9 years ago

  By: SQLPain

• Using a WHERE clause as a parameter

  We're working on an ad hoc reporting system which would allow certain users to write their own WHER…

  frankb 74878

  14 replies

  9 years ago

  By: Thom A