chad_sriram
asked on
Hiding the typing in an SSRS 2008 parameter
Hi,
My client wants a report made available to the internet to their salesmen. In order to avoid building a separate ASPX page for just typing a user id and password, I chose to implement them as SSRS 2008 parameters. The salesmen will be taken straight to the published URL in report manager.
The user id and password values are stored in a password protected database, and are used to limit the data that appears in other parameters on the report (so that salesmen see only their customers to choose).
I am able to get all of this to work in 1 report using stored procedures and different datasets driving the parameters that result in dynamic values filtered based on the parameters keyed in but I cannot hide the typing for the password parameter. How will I be able to accomplish this where the password parameter's text appears like a password text box? Can this be done or not?
Thanks.
My client wants a report made available to the internet to their salesmen. In order to avoid building a separate ASPX page for just typing a user id and password, I chose to implement them as SSRS 2008 parameters. The salesmen will be taken straight to the published URL in report manager.
The user id and password values are stored in a password protected database, and are used to limit the data that appears in other parameters on the report (so that salesmen see only their customers to choose).
I am able to get all of this to work in 1 report using stored procedures and different datasets driving the parameters that result in dynamic values filtered based on the parameters keyed in but I cannot hide the typing for the password parameter. How will I be able to accomplish this where the password parameter's text appears like a password text box? Can this be done or not?
Thanks.
Hi
This cannot be done. Regarding code, it executes when you render the report (too late). You can use report viewer on aspx page and put text boxes outside but I don't see a point.
Are your using windows authentication? probably not but If yes than you don't need password and you access username using Globals!Username.Value (If I remember correctly).
Hope that helps
Emil
This cannot be done. Regarding code, it executes when you render the report (too late). You can use report viewer on aspx page and put text boxes outside but I don't see a point.
Are your using windows authentication? probably not but If yes than you don't need password and you access username using Globals!Username.Value (If I remember correctly).
Hope that helps
Emil
ASKER
If the report needs to be seen on the internet, how will I use Windows authentication? There would have to be a VPN tunnel for using Windows authentication, isn't that right? Viewing it via the web would probably force me to use forms authentication, won't it???
I would gladly use Windows authentication if it can be done without using VPN. Let me know if that can be done.
As you can tell, I am new to this authentication aspect of SSRS when it is not a case of intranet.
I would gladly use Windows authentication if it can be done without using VPN. Let me know if that can be done.
As you can tell, I am new to this authentication aspect of SSRS when it is not a case of intranet.
check this link to see if this will help you..
https://www.experts-exchange.com/questions/26806886/How-do-I-get-the-report-to-run-from-a-web-page.html
https://www.experts-exchange.com/questions/26806886/How-do-I-get-the-report-to-run-from-a-web-page.html
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Hi,
I have looked for an answer to this question without success.
Maybe things are changed since 2011, so I'm asking if there's a way for hiding the typing in an SSRS 2017 parameter, something like a password style input.
Thanks in advance.
ASKER
Can someone provide me the code to do so?
Thanks