Home

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

Support & Forums
Thursday, February 09, 2012 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: Passing UserId via querystring
Prev Next
You are not authorized to post a reply.

Author Messages
myfunmailUser is Offline

Posts:6
12/10/2007 12:28  

This is the main reason for purchasing your module but I do not understand how this is done.  I urgently need assistance on this issue.  Is this it.

http://localhost/reportserver?/CreditReportPM/CR_PM&rs:Command=Render&ProgramMgrID=UserID
hostUser is Offline

Posts:497
12/10/2007 12:38  
We're not sure what you are asking here. Are you asking what your report server URL should be? If so, try http://localhost/reportserver
myfunmailUser is Offline

Posts:6
12/10/2007 12:46  

I think I saw something that may help. I am trying to pass the dnn userid to the report. 

http://www.lacdpop.com/popnet/Credits/CreditReportPM/tabid/62/Default.aspx?ProgramMgrID=UserID

Is the UserID written correctly, because it did not the parameter.  Thanks,
hostUser is Offline

Posts:497
12/10/2007 12:48  
You have to be using version 2.1 to do this and check the box to allow UserId to be passed via the querystring. Please confirm you have done this.
hostUser is Offline

Posts:497
12/10/2007 12:50  
Oh, and one other thing, make sure your report parameter is called UserID, this will do the pass implicitely, any report that has that Parameter name it will substitute a default value for the logged in UserId.
myfunmailUser is Offline

Posts:6
12/10/2007 13:07  

I am starting to understand. I included a field called UserID in the report.  Do I have to make it a parameter in the SSRS?  How do you make a field a parameter?  Thanks,
hostUser is Offline

Posts:497
12/10/2007 13:09  
Getting closer, in the report itself, you don't need it as a field, you want to add it as a parameter of the report!
myfunmailUser is Offline

Posts:6
12/10/2007 14:01  

Thanks for your help.  I never would have gotten this without further explanation.  I would suggest a section devoted to this on your website. I have not gotten it to work but I think it is my report now.
hostUser is Offline

Posts:497
12/10/2007 14:14  
Please email your report RDL file to service@modulemasters.com, we're happy to look to make sure all looks setup right.
myfunmailUser is Offline

Posts:6
12/10/2007 14:59  
Thanks for your help. Your support was great. I did get it working.
hostUser is Offline

Posts:497
12/10/2007 15:53  
Fantastic!
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > Passing UserId via querystring


ActiveForums 3.7
Copyright 2011 by Module Masters Privacy StatementTerms Of Use