Stack Overflow
Stack Overflow

Questions tagged [ssrs-grouping]

Microsofts SQL Server Reporting Services (SSRS) allows creation of reports that contain Tablix controls where data is grouped by fields or expressions in row and/or column groups. Use the ssrs-grouping tag for questions about how to use group properties to change report behaviour.

SSRS reports can contain tablix controls (lists, tables, and matrices) which can group data in row and/or column groups. Use this tag for questions specific to this grouping behavior.

412 questions
0
votes
1 answer

Row number of a group within a group in an SSRS report

I am trying to assign a row number to a group, which is under another group in an SSRS 2008 report. This is how my report looks: Salesman1 - Customer Group1 - Row number 1 Customer Group2 - Row number 2 Customer Group3 - Row…
Nomaan
  • 3
  • 3
0
votes
1 answer

Exclude Filtered data from Group Totals in Report Builder

I have a stored procedure pulling data based on a parameter based "list date" range and rolling it up by month. My output gives me rows based on the month. I need to filter out the "Previous" values which actually represent 'To Date' Month-------#…
Maverik76
  • 11
  • 1
  • 4
0
votes
1 answer

Unable to get the Filtered Values when passing the parameter into filter Value in SSRS

I have multi Valued Parameter which have list of values in the Drop down . I am trying to apply filter on the data set.My requirement is when i choose a value from Drop down,it should be filtered on that value. I am using the below value in my DATA…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

SSRS Map layer visibility for multi valued parameter issue

I am trying to show visibility of the map layer in SSRS based on multi valued Parameter. below expression is giving me errors because of multi valued parameter =iif(Parameters!DataLayer.Value ="LeadStatus", "Visible", "Hidden") i have the…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

Error Converting Datatype nvarchar to int in SSRS for multivalued Parameter

I have a parameter Client in the report which takes Multivalues. When i run the value for one client, it's working fine, but when i include more than 1 client it's giving the error like: "Error Converting Datatype nvarchar to int in SSRS for…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
0 answers

Aggregate (AVG) of RunningValue outside of group

I have the following values that are calculated using the RunningValue() function. This is the Expression used. =RunningValue(Math.Abs(SUM(Fields!paid_amount.Value)/fields!adv_amt.value), Sum, "PercentageFunded") I need to create an average for…
dimiguel
  • 1,429
  • 1
  • 16
  • 37
0
votes
0 answers

SSRS Dataset data only showing 1 groups data

My ds is displaying all the records correctly when going through the GUI but when I preview the report only one of the 2 groupings set up actually display. There are no filters, and no visibility expressions on the tablix or the…
AdamE
  • 99
  • 1
  • 3
0
votes
1 answer

How to parameterize DataSet with group variable?

I have 'external' table. Inside each row of this table I need to show several tables associated with different DataSets. But I have no idea how I can constrain these 'internal' DataSets with parameters of the group. Is it possible? Update The next…
Pavel Voronin
  • 13,503
  • 7
  • 71
  • 137
0
votes
0 answers

SSRS IIF child visibility expression hiding parent as well

Currently trying to implement SSRS 2014 as we now have an increased desire to have compatibility issues across all platforms resolved (Mac+Safari) which has been resolved. SSRS 2014 is rather elegant, however - I have run into an issue importing my…
Alex H
  • 23
  • 4
0
votes
1 answer

error: [BC30057] Too many arguments to 'Public Function IsNothing(Expression As Object) As Boolean'

I'm getting this error: The Value expression for the textrun ‘Textbox233.Paragraphs[0].TextRuns[0]’ contains an error: [BC30057] Too many arguments to 'Public Function IsNothing(Expression As Object) As Boolean'. When I add the "Group" to the…
donviti
  • 284
  • 4
  • 12
  • 27
0
votes
1 answer

rdlc 2005 Add a static column to a matrix

given the dataset - Name, Date, Value, Value2 (the dates are at the month level - so only MMM/yy is returned.) Is it possible to configure a Matrix in RDLC 2005 such that it displays - Static | Dynamic Columns | Static …
user2983931
  • 304
  • 5
  • 17
0
votes
1 answer

SSRS Report Builder 2nd Series in Stacked Column Chart Percentage of 1st Series Total

I am currently using SSRS Report Builder 3.0 and need to make a stacked column chart with 2 series (side-by-side). The category grouping (x-axis) should be a month/year while the values (y-axis) should be a percentage based on: Series 1: sum of…
sadmicrowave
  • 39,964
  • 34
  • 108
  • 180
0
votes
1 answer

How can I make a simple flow chart in SSRS?

I come to you with a question on how I can create a simple flow chart like in the pictures below in SSRS. I have a query that returns rows with events, and a date column that I can use to organize these events in chronological order. I have it all…
t3hclwn
  • 37
  • 1
  • 7
0
votes
1 answer

To prevent groups to display as separate sheets in SSRS 2005 report exported as excel

I am designing reports using SSRS 2005.The exported reports in pdf format is coming fine but the problem is with the MS excel exported form where each group in the tablix is getting displayed as a separate sheet.The requirement is that entire data…
user123
  • 1
0
votes
2 answers

ssrs multivalued parameter that selects which reports to execute

In an SSRS 2008 report, I would like to be able to allow the user the option of selecting between 1 to 30 different ssrs reports that they would like to run as a parameter value. Basically when the main report starts to run, I would like to allow…
user1816979
  • 511
  • 4
  • 13
  • 25
1 2 3
…
27 28