Solved

SSRS Report Output Issue

Posted on 2011-09-28
19
312 Views
Last Modified: 2012-05-12
Using SSRS To create a Report using a Matrix..

Seems to work But I am having an issue trying to get the 1st column to repeat for every line.  I dont want to just see it for the frist one I want it to populate all the way down.

I am using SQL 2008  1
0
Comment
Question by:gotti777
[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
  • 11
  • 7
19 Comments
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717732
You're grouping on that field, that's why it doesn't repeat...
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717763
In the column group pane, right click on the group and select  "Delete Group", select box for "group only"

then add that column again, now it'll repeat and you can keep grouping on that column.
0
 
LVL 11

Expert Comment

by:SThaya
ID: 36717794
Hi,


Please try the below steps ... hope it will work

1.  ADD a new column next to your grouping and call the same filed in the column .
2. then select the current grouping and delete the particular group.

  it will ask Delete  group with column value or only Column in the particular group

3. select the second option .. it will delete only the grouping column not the Group


0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717824
SThaya it'll definitely work, I just said that in the post just above you ..
0
 

Author Comment

by:gotti777
ID: 36717904
Sorry Haveing Little trouble following,

Ok So I delete Goup as shown?
 1
Now Its blank .. Do i readd the data set in there ?
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717927
Just add a new column, right click on the first column and add a column to the RIGHT, then assign it's value.
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717930
0
 

Author Comment

by:gotti777
ID: 36717946
ok did that
 1
But still got  2
Did I do something Wrong?
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717975
Alright, let's start again...
Delete the "Parent Group"   ...screen 1
select delete group only
create new column and add the forecast_name to it
then delete the OLD forecast_name

try that..
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36717990
If that didn't work for you, Attach your RDL file and I'll show you..
0
 

Author Comment

by:gotti777
ID: 36718057
Ok well tried it again .. Still didnt seem to work.. Would I have to do the same to SPCGroup and Name .. I would also want them to repeat?  Maybe I have to do all @ once?
Copy-of-Sales-Forecast-.rdl
0
 

Author Comment

by:gotti777
ID: 36718467
Didi you need the rdl Data file Also ?
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36718468
something like that?
2.png
0
 

Author Comment

by:gotti777
ID: 36718483
yes... Thats would be perfect
0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 36718561
0
 

Author Comment

by:gotti777
ID: 36718728
Man Not sure what you did different but it works... Thanks ....
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36718770
0
 

Author Comment

by:gotti777
ID: 36718788
Now thats cool. Never seen Video made on here
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36718812
:D
0

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

717 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