Solved

SSRS Report Output Issue

Posted on 2011-09-28
19
309 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

816 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

13 Experts available now in Live!

Get 1:1 Help Now