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 |
|
okyle
Starting Member
3 Posts |
 Posted - 2008-12-09 : 14:32:43
|
| I am developing a report in SQL Server Reporting Services 2005.1. I have a parent report that is based off of a very simple OLAP query that returns a unique ID for an asset and a period (i.e. 3rd quarter 2007). 2. I have a child report that is based off of a very simple OLAP query that takes 2 parameters (a unique ID for an asset and a period (i.e. 3rd quarter 2007). This OLAP query returns some financial data and spits out this dollar amount in a single textbox. The child report contains nothing but this textbox.3. The parent report only contains a single subreport that is linked to the child report. I'm passing in the 2 parameters to the subreport as parametername.UniqueName.4. When I run the parent report in Preview mode in Visual Studio (2005), the report has no errors. The subreport shows the dollar amount as I want it to.5. However, when i deploy the report to the report server, the subreport only shows "Error: subreport cannot be shown", and the report server log says "One or more parameters required to run the report have not been specified."Is it possible to pass parameters from an OLAP based parent report to an OLAP based subreport? How come the report renders in Visual Studio, but not on the report server?In reality, my parent and child reports are much more complicated, but I dumbed them down to the simplest of forms so that I could test this. We need this report in production ASAP, and I've spent weeks searching for a solution! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 03:03:42
|
| its possible to pass parameters. but keep in mind passed parameters will have value in the format inclusive of measure/dimension name. |
 |
|
|
okyle
Starting Member
3 Posts |
Posted - 2008-12-10 : 09:52:10
|
| Yes, I am aware of that, which is why I'm passing the parameters in using ParameterName.UniqueName which renders as [Dimension].[Measure].&[Value]And to my knowledge, this is the format in which OLAP queries expect parameters, so I'm not sure what I'm missing here. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 10:51:11
|
quote:
Originally posted by okyle
Yes, I am aware of that, which is why I'm passing the parameters in using ParameterName.UniqueName which renders as [Dimension].[Measure].&[Value]And to my knowledge, this is the format in which OLAP queries expect parameters, so I'm not sure what I'm missing here.
the error message suggests like you're missing one of parameter's value. have you checked if you have missed passing values for any? |
|
|
|
okyle
Starting Member
3 Posts |
Posted - 2008-12-10 : 13:07:47
|
| if i create a subreport that doesnt not have it's own dataset but strictly outputs the parameters values to textboxes, the report runs fine, and the parameter values show up as they should [dimension].[measure].&[value]so somehow there's a disconnect when these params are being passes to the subreport's olap query. |
|
|
|
|
|
|
|
|
Error passing OLAP parameters