How to display Sub Report as pop up window in SSRS 2008

Question

Post reply

How to display Sub Report as pop up window in SSRS 2008

deepak.a

SSCertifiable

Points: 5330
More actions
June 4, 2010 at 12:15 am

#387082

Hi all
I got one Requiremeent in that I need to design a two reports lets say ex: report 1 & Report 2
In Report 1 I need display 4 columns
Report
Name , Score , Section, StudentID
User 1 , 10 , ’A’ , 101
User 2 , 25 , ’B’ , 115
On click of Student ID (ex: 115) I need to show the detials of the User 2 in Report 2 as Popup window . For Report2 input will be StudentID
Iam using Windows 7 as Operating system(64 bit) & IE 8 browser
Thanks
Deepak.A
June 4, 2010 at 1:20 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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

deepak.a SSCertifiable Points: 5330 More actions · Answer 1

hi All

The Below is the Sample Data

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

-- Report 1 Data

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

DECLARE @tblStudents TABLE

(

Name VARCHAR(75) ,

Score DECIMAL(9,2) ,

Section VARCHAR(50),

StudentID BIGINT

)

INSERT INTO @tblStudents

SELECT 'User 1' , 10 ,'A', 101 UNION ALL

SELECT 'User 2' , 25 ,'B' ,115 UNION ALL

SELECT 'User 3' , 20 ,'C', 121

SELECT * FROM @tblStudents

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

-- Report 2 Data

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

DECLARE @tblStudentDetails TABLE

(

StudentID BIGINT,

ActivityName varchar(50),

TestStartDate DATETIME,

TestStartEnd DATETIME

)

INSERT INTO @tblStudentDetails

SELECT 101,'Activity 1','2010-06-04 11:30:00','2010-06-04 12:30:00' UNION ALL

SELECT 115,'Activity 2','2010-05-04 10:30:00','2010-06-04 11:30:00' UNION ALL

SELECT 121,'Activity 3','2010-06-04 9:30:00','2010-06-04 11:30:00'

SELECT * FROM @tblStudentDetails

DECLARE @StudentID BIGINT -- Input Parameter

SET @StudentID = 115

SELECT * FROM @tblStudentDetails WHERE StudentID = @StudentID

Thanks,

Deepak.A

deepak.a SSCertifiable Points: 5330 More actions · Answer 2

Thanks stewartc for u r Reply

But that is the Requirement .

i tried like this also in the URL

= "void(window.open('http://servername/reportserver?%2fpathto%2freport&rs:Command=Render&StudentID="+Fields!StudentID.Value+"'))"+"'))"

The above method also Not working.

Thanks,

Deepak.A

Gopi Muluka SSCarpal Tunnel Points: 4594 More actions · Answer 3

Gopi Muluka

SSCarpal Tunnel

Points: 4594

June 4, 2010 at 2:11 am

#1176382

Add "" before void in your URL

deepak.a SSCertifiable Points: 5330 More actions · Answer 4

thanks Gopi Muluka for the reply

before the void added javascript : void(no spaces) that is also not working & i had given " also . please can u give more details how to use.

Thanks

Deepak.A

Gopi Muluka SSCarpal Tunnel Points: 4594 More actions · Answer 5

Check this link

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5c525e46-c47e-4bea-9356-ac93537cb88c

deepak.a SSCertifiable Points: 5330 More actions · Answer 6

Hi Gopi Muluka

I tried that also it is not working For me.

i used like this

Report Name : StudentReport

Report URL :http://localhost/ReportServer_SQL2008

Report1.rdl

Report2.rdl

in the Text Box Action Property

used the Below Expression :

="void(window.open('http://localhost/ReportServer_SQL2008/Pages/ReportViewer.aspx?%2StudentReport%2Report2&rs:Command=Render&StudentID="+Fields!StudentID.Value+"'))"

<rd:DefaultName>StudentID</rd:DefaultName>

<ActionInfo>

<Actions>

<Action>

<Hyperlink>="void(window.open('http://localhost/ReportServer_SQL2008/Pages/ReportViewer.aspx?%2StudentReport%2Report2&rs:Command=Render&StudentID="+Fields!StudentID.Value+"'))"</Hyperlink>

</Action>

</Actions>

</ActionInfo>

deepak.a SSCertifiable Points: 5330 More actions · Answer 7

Hi Gopi Muluka thanks for the help

it is worked for me i used + instead of &

thanks,

Deepak.A

ramuis78 SSC Rookie Points: 49 More actions · Answer 8

Hi,

I am in similar situation, i need to open pop up window and also specify window height and width.

I am using SSRS 2008 and MS Dynamic CRM 4.0. Getting 2 pop up windows open.

Appreciate your great help

Here is my code:

Created place holder: on place holder properties, action->Go to URL: i set following

Hi,

I am in similar situation, i need to open pop up window and also specify window height and width.

I am using SSRS 2008 and MS Dynamic CRM 4.0. Getting 2 pop up windows open.

Appreciate your great help

Here is my code:

Created place holder: on place holder properties, action->Go to URL: i set following

="Java[inserted curly brackets to appear javascript]Script:void(window.open('" & Replace(Parameters!CRM_URL.Value, "/CRMReports/viewer/drillopen.aspx", "/ISV/GBS/RemoveMyProspect.aspx") & "?cid=" & Fields!CONTACT_ID.Value.ToString() & "','RemoveFromList','width=500,height=150,scrollbars=no,toolbar=no,location=no,status=no,resizeable=no'))"

AFter uploading to CRM, click on this column will open two pop up windows. one with correct popup page and other with blank page and address bar appears "void(window.open........................)