Solved

SSRS Report Output Issue

Posted on 2011-09-28
19
308 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
  • 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
 
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

911 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

26 Experts available now in Live!

Get 1:1 Help Now