SSRS question, create a textbox that lets the user enter a value...
I apologize for the (probable) simplicity of this question, but I'm relatively new to SSRS and have not been able to come up with a solution. Basically, I'm trying to create a 2 page report. The request from my boss is a report that mimics an application (managers). Page 1 will have 2 values that the user will need to enter, then click "View Report". I have used the "Action, Go to Report" feature to trigger the link to the 2nd report, but how do I create a textbox that the user will be able to enter a value into, while they are already viewing page 1 of the report? When I try to do a preview with a normal textbox it doesn't give me the option to enter a value in it, which would be the prelude to clicking the "View Report" link. I assume there is something clever I'm supposed to do in order to allow the user to enter the value in the report, but it escapes me... Thanks in advance to any help anyone can give me.
June 13th, 2011 12:01pm

try adding parameter and set textbox value =this parameter value this make user send value to the textbox throw the parameter as textbox is read onlyAhmed Ekdawy
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 12:46pm

The only way for users to enter values in SSRS is through the use of parameters which will appear at the top of the report. A text box can be used to display a parameter value but the user will not be able enter a value directly into it. (like you would with a fillable PDF form for example). It sounds like you may be trying to create a form (which allows users to enter values in a way that would mimic a paper form) rather that a report (which is typically output only with very minimal user inputs)Jason Long
June 13th, 2011 1:13pm

That is correct. They want the user to be able to enter in a type of account number, but they don't want them to have a drop down list with all the account numbers in it. I had hoped that there was some way to make a textbox fillable inside the report, then pass the value entered into that box to another report.
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 1:25pm

There is no requirement that you use a picklist to select a parameter value. You can easily create the parameter so that the user can enter free form text. You just need to be aware that the parameters will all be at the top of the report in the tan colored area. If you need to have the user fill in values is the body of a form AND you are using a full version of Visual Studio (rather than the BIDS version that comes free with SQL Server) you should look at using a Windows Form that would accept the user inputs and then use a report to pull data from the database based on the form values.Jason Long
June 13th, 2011 1:40pm

Ok, I'll try that. Thanks!
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 4:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics