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 |
|
rayruest
Starting Member
1 Post |
 Posted - 2008-04-24 : 09:38:27
|
| HI, SQL newbie here... less than a month. I am modifying a report from our MRP vendor. We are allowed to do this. They discourage modifying the underlying SQL for upgrade and support reasons. I need to pull commission data to the report in order to determine proper logo/address/etc information on the page. The report is about 1000 pages long, each page may have different logo, etc. So, I created a stored procedure in SQL to retrieve the data when passed a customer ID. Tests fine. When I attempt to call this stored procedure from reporting services, it tells me that I cannot use a Field (or report item) as a parameter. I cant believe they would limit reports this way. Is there any way to circumvent this limitation? Any alternate recommendations?Thanks in advance!Ray |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-24 : 11:48:12
|
| Field as parameter? DIdnt get that. Based on your stored procedure, the reporting services will automatcally take parameter information. Have you add some additional parameters? And are you trying to assign values from fields? didnt get what you are telling. Can you elaborate? |
 |
|
|
|
|
|
Fields as parameters