What are the values of the 2 parameters: @IterationParentID and @TeamProjectTeamProject when this error occurs. It looks like this report is using cascading paramters - so have these 2 parameters already been selected (ie. they occur before AreaParentID)?
The parameters I have along the top of my report are:
Team Project: _______(dropdown) Iteration: _________(dropdown)
Area: ______________(dropdown) Work Item Type: ___(dropdown)
Work Item State: ____(dropdown)
The report works as long as all the parameters are all set to all, but if I want to select a specific team project, I run into the problem. At first I was thinking that maybe I need to add some kind of DISTINCT to allow from the same names. For example: some of our projects are the same names as the iteration or area....
So first I drop down team project and select Project1, then when I go to Iteration, If I select Project1, I get the error about something with Area.
Except I just did the exact same thing and this time it didn't display anything when I went to preview it in VS but when I delpoyed it I can see the report, and it works, and I don't see any errors....I'm pretty sure I didn't change anything....hmmmm. Weird....because I was getting that error when I tried previewing it in VS and on the website.....
Any suggestions on why I can't view the data in Visual Studio?
Thanks so much for your time and replying to my post!