Link to home
Start Free TrialLog in
Avatar of Gabe Lebron
Gabe LebronFlag for United States of America

asked on

SSRS Report Output Issue

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  User generated image
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

You're grouping on that field, that's why it doesn't repeat...
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.
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


SThaya it'll definitely work, I just said that in the post just above you ..
Avatar of Gabe Lebron

ASKER

Sorry Haveing Little trouble following,

Ok So I delete Goup as shown?
 User generated image
Now Its blank .. Do i readd the data set in there ?
Just add a new column, right click on the first column and add a column to the RIGHT, then assign it's value.
ok did that
 User generated image
But still got  User generated image
Did I do something Wrong?
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..
If that didn't work for you, Attach your RDL file and I'll show you..
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
Didi you need the rdl Data file Also ?
something like that?
2.png
yes... Thats would be perfect
ASKER CERTIFIED SOLUTION
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Man Not sure what you did different but it works... Thanks ....
Now thats cool. Never seen Video made on here