Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Tuesday, September 07, 2010 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: Passes PortalId and UserId as parameters
Prev Next
You are not authorized to post a reply.

Author Messages
muniappanUser is Offline

Posts:53
06/22/2007 14:40  

Passes PortalId and UserId as parameters. I could not understand this point. Is this module accepts PortalId and UserId as querystrings?. Then how to pass thase accepted values to SQL Server Reporting Services from thom this module?

Thanks,
hostUser is Offline

Posts:449
06/22/2007 18:11  
No, portalId and UserId are not sent as querystring, they are sent via session strings. All you have to do to get it to work is be sure your report has a matching parameter name.
muniappanUser is Offline

Posts:53
06/25/2007 10:06  
Thank you for yuor reply. But still i have the doubt. From which page I can store the value for the parameter in the session.I am showing report from inside dotnetnuke module. I have the user control ViewRS2005.ascx. Do I need to write the code Session("UserID") = "Session Test" in that user control?. It is showing the value -1 if I am doing like that.
muniappanUser is Offline

Posts:53
06/25/2007 10:25  
I am storing value in to the session from Default.aspx page itself. This is the first page gets loaded when I am running my website.The url is for the report page is http://localhost/dotnetnuke_2/Report/ParamReport/tabid/69/Default.aspx.But still the report is showing -1 as parameter value. Please give me suggestion to correct this issue.
hostUser is Offline

Posts:449
06/25/2007 12:59  
The module is setup when displaying a report to look for UserId and PortalId in the parameter names of a selected report. If they are found, it will then take the logged in UserId or PortalId and pass them through accordingly. There is no code needed on your side to make this happen, just ensure the parameter names are named exactly as stated and this should work. If you are seeing -1 values, make sure you are logged into DNN when running it.
muniappanUser is Offline

Posts:53
06/25/2007 13:23  
I am getting these parameters in the report now.
Thank you
hostUser is Offline

Posts:449
06/25/2007 13:28  
That is great!
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > Passes PortalId and UserId as parameters



ActiveForums 3.7
Copyright 2005 by Module Masters Privacy StatementTerms Of Use