web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SSRS combine column group
Microsoft Dynamics GP (Archived)

SSRS combine column group

(0) ShareShare
ReportReport
Posted on by painterisaac 3,015

In a report that I've created my column group is the document date. My row group is the sales line item. I am using the saleslineitem view. 

I've created a between parameter with the column date.

How it appears on my report is like this, with each document date separated. 

5277.Capture2.JPG

I want it to do this, where it aggregates all the dates in one column and sums the amounts. 

What expression, or other method, can I implement to make this possible?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    As you said above, you have the column group set to be your document date so that is why you are getting one column for each date.

    What you could do is change the column group to be something at a higer level even ="1" would work in your case since you really are not grouping on anything you just want it all summarized.

    Or, if you wanted the column group to be by Year you could parse out the Year from the Document Date and group on that instead.

    Then, you can change the label to be an expression that displays the selected Start and End date parameters.

    Hope this helps,

    Adam

  • painterisaac Profile Picture
    painterisaac 3,015 on at

    Thank you Adam!

    How would I do this? "change the column group to be something at a higer level even ="1" "

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    In the report designer, at the bottom of the design pane you should see sections for the Row Groups and Column Groups.

    If you click on the column group you have and select Group Properties you should then be on the General tab of the properties window.

    On the General tab you should see a "Group On" value and this is where you can change it.

    Based on what you are looking for I might suggest trying to enter:

    =datepart("YYYY",fields!YourDateField.Value) which will group by Year. You could alteratively enter ="1" to just have a single group that summarizes everything.

    Let me know if that helps!

    Thanks,

    Adam

  • painterisaac Profile Picture
    painterisaac 3,015 on at

    Wonderful! Thank you Adam. That is soooo helpful.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans