Trunk Media

SQL Report server “select all” work around

16 June 2009

If you’re showing your search results in your report and have a very long select all multivalue coming through then you’re probably not seeing any results until the second page of your report. I searched for a way of showing “Search all” instead of the 110 selected items I was getting but to no avail. Instead I ended up with the following code.

=iif(
Parameters!RegionId.Count = Count(Fields!CountryId.Value, "Countries"),
"All",
Join(Parameters!RegionId.Label,", ")
)

Only works for ALL items, select one less at you’ll still get a huge list.
Good luck!

Posted in Technical | No Comments »

SQL Report Server wrong images

3 June 2009

If you’re having problems with external images not working correctly in SQL Report Server 2005 it’s probably because you haven’t installed SP2. As of writing just grab Service Pack 3.

My problem was that I had two linked images in the footer of the document. It didn’t matter what I did but both images always turned up the same. 3 hours of debugging and trying work arounds because google wasn’t helping eventually turned up a post saying to do what I’m saying here, upgrade! If you’re not sure what version your SQL is at run “select @@version” in any query window. If it’s under 9.0.4 then you don’t have a new enough version…

Posted in Technical | No Comments »