?
Solved

SSRS Report Output Issue

Posted on 2011-09-28
19
Medium Priority
?
316 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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 2000 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

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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…
Suggested Courses

864 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