You can use Reportitem.TextBox1.value to get the value of the text box(named textbox1) then use it a IIF expression like Happy cat suggested.

alternatively you could take your formula that you...

If I understand what you're saying then what you need to do is make a dataset for Party and segemt.

the data set would have a query along the lines of

Select...

What do the reportserver logs say? They might have an error message that could pint you in the right direction.

Sorry, i totally misread your post. My error was totally different. I read to fast and my mind filled in the blanks.

You'd think that. It was like that in 2005 but for 2008 I find that unless I change a parameter the result set stays cached. I even have...

When i did my upgrade I had two reoccuring errors. One was the one that you had. Do your reports have background images in the headers? if...

I think you have an extra + at the end after NAME.Value

your reports might not actually be faster, just cached. As a test try deleting the .rdl.data files (in the same Dir as the repors) and try running the reports...

I've tried a few more things to no avail. I found another report that has a large dataset and ran them both a few times.

Trouble report: Bytes Retrieved...

the files are named differently so you could probably try the process with those files and see if it works. There wasn't anything in the article about 64bit.

I believe there's a x32 and x64 version of the CAB as well. I'm not sure if the files are named the same or not or what to do...

I should that the part that helped me was the location of the cab file on the server that houses reporting services and where to put the RDL and DLL...

There's a article here that helped me with this problem. I've had this problem twice. Once in 2005 where it wsa a CU that fixed it. the...

Never mind I just saw your other post...

http://www.sqlservercentral.com/Forums/Topic1438173-150-1.aspx

so

IF @ApplicationName = 'MAC'

BEGIN

SELECT NetworkName, SampleTime, [Max] FROM vinny..PerfData_CPUServerView (nolock)

Where NetworkName in (@ServerName)

And SampleTime >= @StartDateTime and SampleTime <= CONVERT(date, DATEADD(dd, 1, @EndDateTime), 101)

Order by SampleTime asc

END

ELSE

BEGIN

select...