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 |
|
sassy
Starting Member
4 Posts |
 Posted - 2011-06-16 : 10:50:40
|
Hi Everyone,I have an embedded datasource in my report which works fine. The dataset is set up and the fields have been assigned to the dataset. One of the fields is called EffectiveDate. The report needs to include a subreport which needs an expression passed in to it as a parameter (which includes EffectiveDate from the main report). The problem is that when I try to create the expression, there are no Fields that appear. When I use this line of code there's an error under Fields!EffectiveDate.Value saying "unkown collection member":="isnull([" + Fields!EffectiveDate.Value + "],0) as [" + Fields!EffectiveDate.Value + "]" Does anyone know of a workaround to this problem or how i can access the fields in my report? Nothing I'm trying is working.Thanks so much! |
|
|
sassy
Starting Member
4 Posts |
Posted - 2011-06-16 : 14:06:33
|
| I wasn't able to figure out how to add fields to a subreport object but I found a workaround that works well for anyone who has a similar problem. I created a variable using the field I needed to access (EffectiveDate) and then used that variable in the subreport parameter expression. It works. This issue is considered closed for me. |
 |
|
|
|
|
|
Subreport Parameter Expression Issue with Fields