Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Report Output Issue

Posted on 2011-09-28
19
Medium Priority
?
315 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

610 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