Post reply

how do I make the Action Say 'Kevin Bacon' repeat every row

  • March 3, 2022 at 3:08 pm

    #3992509

    I am trying to make the  Actor repeat on every row on the column. I am having a hard time doing this on Report builder

    Attachments:
    You must be logged in to view attached files.

  • March 4, 2022 at 3:10 pm

    #3993171

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • March 4, 2022 at 5:47 pm

    #3993270

    There's not very much to go on but it looks as if you have created a matrix rather than a table - the data is grouped on Actor and thus the name only appears in the group. Try adding an extra column to the tablix (that's just a composite word for a table/matrix) to the right of Year and then there should be a list in the text box of all the data columns that includes Actor. Select that and run the report. If that's OK I'd suggest deleting any group that's called Actor

  • March 4, 2022 at 7:24 pm

    #3993327

     

    Please add sample data along with DDL/DML statements to set up the tables we need to be able to see what you are seeing on your side.

    Without knowing more you can try with SQL >

    Select s1.[name], s2.*
    From (Select 'Kevin Bacon' as [name]) as s1
         ,  /* note the comma */     
         (
         Select attr1, attr2, sum(col3)
         From yourTable
         Group by attr1, attr2
         ) as s2


    You can also substitute the comma with the CROSS APPLY operation

    ----------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

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