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 |
|
jaynichols
Starting Member
18 Posts |
 Posted - 2008-11-20 : 14:44:05
|
| I have a report that is navigated to from another report with parameters passed. The second report under certain circumstances will fail to render a few columns of data. When the dataset is run independent of the report in the data tab, the results are there. I've checked the parameters that are passed and all is correct.any ideas?Dirt biking forever! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-22 : 00:58:07
|
| its worth checking those column cells in report designer to see if somebody have set any expressions for altering visibility property of the cells. select the problem cells, click to view properties window and look for expression of visibility property. |
 |
|
|
jaynichols
Starting Member
18 Posts |
Posted - 2008-11-23 : 00:01:49
|
| Thanks, but that's not the problem. I can change the parameters and the data shows. Very disturbing. Also have checked the properties of the offending boxes and there is nothing there.Dirt biking forever! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-23 : 01:55:21
|
quote:
Originally posted by jaynichols
Thanks, but that's not the problem. I can change the parameters and the data shows. Very disturbing. Also have checked the properties of the offending boxes and there is nothing there.Dirt biking forever!
that clearly suggests there's some expression being written for manipulating visibility of those columns based on parameter values.Are you sure you checked both cell properties tab as well as properties window? |
|
|
|
jaynichols
Starting Member
18 Posts |
Posted - 2008-11-23 : 18:32:18
|
| I think I have checked all of those, but I will check again when I get in to work tomorrow morning. I agree it must be something to do with visability as the query returns values. I'll let you know what I find in the morning.Thanks for your continued interest in my problem.Dirt biking forever! |
|
|
|
|
|
|
some results render, some don't