Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

Mixed Layout Report Service

Posted on by Microsoft Employee

Currently I have a list that is horizontal and I would like to leave it in the following layout:
How can I do this using report service?

pastedimage1663933267428v1.png

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mixed Layout Report Service

    In this case it doesn't work for me because I'm using fetch xml and not sql

  • Suggested answer
    Kipetcoff Profile Picture
    Kipetcoff 1,000 on at
    RE: Mixed Layout Report Service

    Hi,

    First of all you need to write correct SQL command with groups of rows numbers

    select Mod3 = (row_number() over (PARTITION BY Mod2 ORDER BY Id)),
           Mod2,
           Id
    from
    (
        select Mod2 = (row_number() over (ORDER BY Id)) % 2,
               Id
        from
        (
            select 'Id' = '1'
            union all
            select 'Id' = '2'
            union all
            select 'Id' = '3'
            union all
            select 'Id' = '4'
            union all
            select 'Id' = '5'
        ) datatable
    ) tt
    order by id

    Then create matrix table

    pastedimage1664224265323v9.png

    pastedimage1664224310365v10.png

    Then remove rows and columns headers

    pastedimage1664222167409v4.png

    pastedimage1664224368578v11.png

    Insert subreport with parameter of row id

    pastedimage1664224396992v12.png

    pastedimage1664222292265v7.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mixed Layout Report Service

    Yes it is  2 columns, N rows

  • Kipetcoff Profile Picture
    Kipetcoff 1,000 on at
    RE: Mixed Layout Report Service

    Hi,

    Does this report have 2 columns, N rows or vice versa?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans