SSRS Parent groups repeating creating a “staircase”SSRS Sum in table groupTrying to Add Sub Row Group inside Parent but flush left in the nested cellSSRS 2008 R2 - Group toggle aggregatesSSRS - Count grouped by Column AND Row in a TablixHow to get multiple disparate row groupings in a tablix to function?Adding a new group to an SSRS tablix with existing groups?SSRS Grouped total sum issueSSRS - Convert multiple rows into multiple columnsSSRS Report tables - Repeat Row Headers on Subreports?Parent child group giving blank rows when row is getting hide based exp - SSRS
How did C64 games handle music during gameplay?
powerhouse of ideas
Iterate over non-const variables in C++
Automatic Habit of Meditation
Can two figures have the same area, perimeter, and same number of segments have different shape?
How can I prevent corporations from growing their own workforce?
What do teaching faculty do during semester breaks?
Does academia have a lazy work culture?
Strange Cron Job takes up 100% of CPU Ubuntu 18 LTS Server
Spoken encryption
How do professional electronic musicians/sound engineers combat listening fatigue?
Commercial jet accompanied by small plane near Seattle
How may I concisely assign different values to a variable, depending on another variable?
This message is flooding my syslog, how to find where it comes from?
Can the Artificer's infusions stack? Returning weapon + radiant weapon?
What are the exact meanings of roll, pitch and yaw?
High income, sudden windfall
How were the LM astronauts supported during the moon landing and ascent? What were the max G's on them during these phases?
401(k) investment after being fired. Do I own it?
What does Kasparov mean by "I was behind in three and even in one after six games"?
How do campaign rallies gain candidates votes?
Using "Kollege" as "university friend"?
Inadvertently nuked my disk permission structure - why?
Is there a reason why I should not use the HaveIBeenPwned API to warn users about exposed passwords?
SSRS Parent groups repeating creating a “staircase”
SSRS Sum in table groupTrying to Add Sub Row Group inside Parent but flush left in the nested cellSSRS 2008 R2 - Group toggle aggregatesSSRS - Count grouped by Column AND Row in a TablixHow to get multiple disparate row groupings in a tablix to function?Adding a new group to an SSRS tablix with existing groups?SSRS Grouped total sum issueSSRS - Convert multiple rows into multiple columnsSSRS Report tables - Repeat Row Headers on Subreports?Parent child group giving blank rows when row is getting hide based exp - SSRS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
The information is correct but its in a "staircase" with repeating columns and rows and a lot of excess empty cells.
(im new to ssrs hopefully this is really basic)
hours are stored in sub-projects, i am trying to get the sum for each project within each department
So i Added two parent groups one for projects(row) and one for departments(col), and hid the hours row since i only want the sum
inputs
_______________________
|_________|__[dept]____|
|[proj]___|__sum(hours)|
[hidden] |_________|__[hours]___|
Here's what i got
__________________________________
|_____|__D1__|__D1__|__D2__|__D2__|
|__P1_|__10__|______|______|______|
|__P2_|______|__76__|______|______|
|__P1_|______|______|__32__|______|
|__P2_|______|______|______|__48__|
Here's what i want
_____________________
|_____|__D1__|__D2__|
|__P1_|__10__|__32__|
|__P2_|__76__|__48__|
ssrs-2012 ssrs-tablix
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
add a comment |
The information is correct but its in a "staircase" with repeating columns and rows and a lot of excess empty cells.
(im new to ssrs hopefully this is really basic)
hours are stored in sub-projects, i am trying to get the sum for each project within each department
So i Added two parent groups one for projects(row) and one for departments(col), and hid the hours row since i only want the sum
inputs
_______________________
|_________|__[dept]____|
|[proj]___|__sum(hours)|
[hidden] |_________|__[hours]___|
Here's what i got
__________________________________
|_____|__D1__|__D1__|__D2__|__D2__|
|__P1_|__10__|______|______|______|
|__P2_|______|__76__|______|______|
|__P1_|______|______|__32__|______|
|__P2_|______|______|______|__48__|
Here's what i want
_____________________
|_____|__D1__|__D2__|
|__P1_|__10__|__32__|
|__P2_|__76__|__48__|
ssrs-2012 ssrs-tablix
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
– Alan Schofield
Mar 26 at 23:13
That was the problem! i had extra groups i wasn't using anymore. i'm surprised you figured that out, thank you very much!
– leafey
Mar 27 at 13:51
I'll add the comment as an answer so you can mark it as answered.This will help others when searching for a similar solution.
– Alan Schofield
Mar 27 at 20:35
add a comment |
The information is correct but its in a "staircase" with repeating columns and rows and a lot of excess empty cells.
(im new to ssrs hopefully this is really basic)
hours are stored in sub-projects, i am trying to get the sum for each project within each department
So i Added two parent groups one for projects(row) and one for departments(col), and hid the hours row since i only want the sum
inputs
_______________________
|_________|__[dept]____|
|[proj]___|__sum(hours)|
[hidden] |_________|__[hours]___|
Here's what i got
__________________________________
|_____|__D1__|__D1__|__D2__|__D2__|
|__P1_|__10__|______|______|______|
|__P2_|______|__76__|______|______|
|__P1_|______|______|__32__|______|
|__P2_|______|______|______|__48__|
Here's what i want
_____________________
|_____|__D1__|__D2__|
|__P1_|__10__|__32__|
|__P2_|__76__|__48__|
ssrs-2012 ssrs-tablix
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
The information is correct but its in a "staircase" with repeating columns and rows and a lot of excess empty cells.
(im new to ssrs hopefully this is really basic)
hours are stored in sub-projects, i am trying to get the sum for each project within each department
So i Added two parent groups one for projects(row) and one for departments(col), and hid the hours row since i only want the sum
inputs
_______________________
|_________|__[dept]____|
|[proj]___|__sum(hours)|
[hidden] |_________|__[hours]___|
Here's what i got
__________________________________
|_____|__D1__|__D1__|__D2__|__D2__|
|__P1_|__10__|______|______|______|
|__P2_|______|__76__|______|______|
|__P1_|______|______|__32__|______|
|__P2_|______|______|______|__48__|
Here's what i want
_____________________
|_____|__D1__|__D2__|
|__P1_|__10__|__32__|
|__P2_|__76__|__48__|
ssrs-2012 ssrs-tablix
ssrs-2012 ssrs-tablix
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
edited Mar 26 at 17:46
leafey
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
asked Mar 26 at 16:52
leafeyleafey
11 bronze badge
11 bronze badge
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
– Alan Schofield
Mar 26 at 23:13
That was the problem! i had extra groups i wasn't using anymore. i'm surprised you figured that out, thank you very much!
– leafey
Mar 27 at 13:51
I'll add the comment as an answer so you can mark it as answered.This will help others when searching for a similar solution.
– Alan Schofield
Mar 27 at 20:35
add a comment |
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
– Alan Schofield
Mar 26 at 23:13
That was the problem! i had extra groups i wasn't using anymore. i'm surprised you figured that out, thank you very much!
– leafey
Mar 27 at 13:51
I'll add the comment as an answer so you can mark it as answered.This will help others when searching for a similar solution.
– Alan Schofield
Mar 27 at 20:35
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
– Alan Schofield
Mar 26 at 23:13
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
– Alan Schofield
Mar 26 at 23:13
That was the problem! i had extra groups i wasn't using anymore. i'm surprised you figured that out, thank you very much!
– leafey
Mar 27 at 13:51
That was the problem! i had extra groups i wasn't using anymore. i'm surprised you figured that out, thank you very much!
– leafey
Mar 27 at 13:51
I'll add the comment as an answer so you can mark it as answered.This will help others when searching for a similar solution.
– Alan Schofield
Mar 27 at 20:35
I'll add the comment as an answer so you can mark it as answered.This will help others when searching for a similar solution.
– Alan Schofield
Mar 27 at 20:35
add a comment |
1 Answer
1
active
oldest
votes
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55362409%2fssrs-parent-groups-repeating-creating-a-staircase%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
add a comment |
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
add a comment |
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
answered Mar 27 at 20:36
Alan SchofieldAlan Schofield
7,3951 gold badge10 silver badges22 bronze badges
7,3951 gold badge10 silver badges22 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55362409%2fssrs-parent-groups-repeating-creating-a-staircase%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I'm not sure what you have now exactly, but you just need a single row group for Project, remove any other row groups.
– Alan Schofield
Mar 26 at 23:13
That was the problem! i had extra groups i wasn't using anymore. i'm surprised you figured that out, thank you very much!
– leafey
Mar 27 at 13:51
I'll add the comment as an answer so you can mark it as answered.This will help others when searching for a similar solution.
– Alan Schofield
Mar 27 at 20:35