=IIF(fields!address2.value = '',fields!address1.value,fields!address2)

please anyone else expiriencing the same slowness i am gettting.... i got over 3,000 business hitting this almost 24/7 and each business has at least 3 to 4 people running...

yea our DB is on another BOX... and the web services are on 4 different boxes...

Nope it comes up pretty fast.... and there is really nothing special going on in the RDL file itself... 12 columns doing a data dump.. the RDL file doesn't do...

thanks for all your help...

well i am doing a datediff so it looks like this

datediff(hh, soandsodate,soandsodate2) which this would return 25 hours... but i am looking for something similar that would return instead...

Any other advise out there to speed up the reporting services engine...

well when i run the query say for example EXEC SP_NAME @,@,@,@ ... it takes like say 2 or 3 seconds to return with a result set... i know on...

go with embeded images dude... save the hassel...

The thing i would do next is look in the reporting services logfiles... this will tell you what in the report is causing this error... also try looking in the...

Make sure in the report designer on the report parameters you do not have the default set to NULL...

Refer to the name of the column/textbox the calculation is on.. for example...

=ReportItems!textbox22.value(this would be the calculated field) + fields!CountOfSomething(this would be what ever you want to add to...

good one... i like that...

i don't get the question but i use Apex SQLDiff...

well i could help out... email me when you get a chance...