Possible...? yes. The possibility and method will vary depending on the data.
For instance, I have several reports that run from TFS data. TFS has a web interface that allows me to open a work item in edit mode and assign a value using a querystring parameter. I could then update my data by setting the action property of the desired control to execute that hyperlink with the querystring parameter for the particular field to update being dynamically added, such as:
="http://tfsserverurl...?id="+Fields!WorkItemID.Value+"&"+ReportItems!ColumnHeader.Value+"="+Fields!CurrentCellField.Value
If you need direct input to a database as seems to be the case, You might be able to accomplish that through custom code. The needed assemblies to support your code must be available on the reporting server and explicitly referenced in the report properties. Executing that code on click might be a little awkward. Again, you could use the action property, go to bookmark or go to report, to execute your custom code and have the code return an appropriate bookmark name or the current report name as appropriate. By the way, if you use go to bookmark to go to a nonexistent bookmark, it will not scroll or reload the report, but the custom code should run.
This is theory (for the custom code solution). It is a complex solution that I cannot replicate locally.
"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
Please Mark posts as answers or helpful so that others may find the fortune they seek.
No comments:
Post a Comment