Parameterized - SharePoint and SSRS

Posted by Eshwargee under Interview Questions on 3/10/2011 | Points: 10 | Views : 2449 | Status : [Member] | Replies : 5
How to develope and provide security for parameterized SSRS report in sharepoint?
( Input from SharePoint , connect to SSRS, dispaly/ output in SharePoint )

Eshwar,


Responses

Posted by: Rahuljgosavi on: 3/11/2011 [Member] Starter | Points: 25

Up
0
Down
can you please elabborate more , are you using sharepoint integration mode with SSRS ?

Eshwargee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Eshwargee on: 3/11/2011 [Member] Starter | Points: 25

Up
0
Down
I have a sharepoint and SSRS environment.
I have to give input parameters from sharepoint (ex., webpart, submit button)
I have to generate an SSRS report using one or more parameters (ex., input : emp no, output some info)

It is routing like this
SharePoint(empNo) -> SSRS(report) -> SharePoint(output, as a report)
Output should be in sharepoint as a report

I think u understood.



Eshwar,

Eshwargee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rahuljgosavi on: 3/11/2011 [Member] Starter | Points: 25

Up
0
Down
Actually there are two types of mode in SSRS,
1.Native mode
2.Sharepoint Integration mode.

I just want to confirm whether you are 2nd option ?

Eshwargee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Eshwargee on: 3/11/2011 [Member] Starter | Points: 25

Up
0
Down
Is it?
explain in these 2 ways.
And, suggest preferable way also

Eshwar,

Eshwargee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 3/11/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

What is the issue exactly you face? are you not sure on how to start?

Thanks
Karthik
www.f5Debug.net

Eshwargee, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response