Post reply

SSRS Report-Sub report pop up

  • June 17, 2014 at 5:57 am

    #309160

    Hi ,

    How to call another report

    R1.rdl

    R2.rdl

    from R1.rdl output get the id from that pass it to R2.rdl

    R1.rdl

    id,name, address,

    1,n1,a1

    2,n2,a2

    R2.rdl -- input parameter "2: now which is from R1.rdl

    id,newid,work_info

    2,1,'Manager1'

    2,2,'Manager2'

    3,3,'Manager3'

    If i click on the line 2 of R1.rdl then new report window should be opened.

    Thanks!

  • June 17, 2014 at 7:06 am

    #1722297

    You should have posted this under SSRS. I have an answer for you.

    I did this a while ago, so I recreated the problem in AdventureWorks and took screen shots for you. See the attached Word document.

    Basically, in R2, you would pass id as parameter (select id, newid, work_info from managers where id = @id). Then right click on id column in R1.rdl, choose text box properties, click on action, go to report, choose R2 from the list, and write name as 'id' and choose value as id column. That's it, you are done.

    ------------
    🙂

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

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