Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dba123
Yak Posting Veteran
90 Posts |
 Posted - 2006-01-24 : 21:13:33
|
| Is there a way to allow a user to manually input values in one of the columns in my report and then also allow other columns to rely on that value in their calculations? |
|
|
jhermiz
3564 Posts |
Posted - 2006-01-27 : 00:08:17
|
quote:
Originally posted by dba123
Is there a way to allow a user to manually input values in one of the columns in my report and then also allow other columns to rely on that value in their calculations?
Not directly in a report but yes as a parameter.That parameter can be sent back to the stored procedure for additional processing and dependencies if required.Maybe post more about what it is with sample data or why you want to do this.Thanks,Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
dba123
Yak Posting Veteran
90 Posts |
Posted - 2006-02-01 : 11:09:07
|
| The problem is, the parameters are dynamic in number. The report may return fewer rows the next month so therefore there would be one input parameter for each row but there is no way to dynamically create parameters...at least I don't think that's an easy task even in SSRS 2005?I ended up creating what I knew I probably had to do in the first place was to create an input form for the column that requires manual input. The input form is dynamic in that it presents only the # of cells necessary per the companies in the report. The report then picks those entred values from our management from the table and embedds it into the report. |
|
|
|
|
|
|
Manual inputs on one of the columns - SSRS 2005