Mixing non group columns in between grouped columns? SSRS

  • sebekkg

    Valued Member

    Points: 65

    Hello guys like title suggest is it possible to do it in SSRS? I have some tablix that presents general data regarding customers and few columns regarding our interactions and I would like at last place to have grouped column regarding days since last interaction. Is it possible in ssrs?

  • Thom A

    SSC Guru

    Points: 98207

    Guessing a bit here, but wouldn't that be easier to do in your SQL? This is pseudo--SQL but you could have something like this that would give you this information:
    DATEDIFF(DAY, MAX({Contact Date}) OVER (PARTITION BY {Customer ID}),GETDATE())

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • jonathan.crawford

    SSCertifiable

    Points: 6346

    or do something kludgy like have a different dataset with the interaction data and do a lookup for what you wanted for the last few columns

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • sebekkg

    Valued Member

    Points: 65

    That wasn't problem, but i would like that column could be at the end, since it is same for one customer. Because i would use condition coloring on the side because of my ocd.

  • Thom A

    SSC Guru

    Points: 98207

    sebekkg - Friday, March 15, 2019 9:58 AM

    That wasn't problem, but i would like that column could be at the end, since it is same for one customer. Because i would use condition coloring on the side because of my ocd.

    Not sure I understand the problem here then. Think you need to do some more explaining,. and show the what you want your report to look like.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • sebekkg

    Valued Member

    Points: 65

    I definitely needed to make it an example it would be like this:

    and the result should be like this:

    So I have in this example two columns in between grouped columns, and that was to my dilemma and question, how to do it?

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply