| Groups | Blog | Home |
sql server reporting services : Programmatically chosing an image in table
So we've got a report, and some external images (i.e. sitting on the
server's HD). I don't really want to put them in the SQL 2000 database if I don't have to (mainly because I don't know how), but I want one column of the report to be one of 5 images, depending on the value a column in the table. If I embed the images, I can't see a way to chose one of the images in the table; I can just make all the column the same. Or can I just code the HTML line manually... Have to try that, I guess. Any other ideas? If it helps, the report is a table of calls our customers have submitted, and the image displays a bug, dollar sign, plus sign, script page or question mark depending on whether the call is a bug, customization, feature request, script request, or 2nd level support question. Clint
We have created some "dashboard" like reports that have different icons
(for data audits). Obviously this might not be the best method for everyone, but it works for us. We have folder structure like below: Production Images Audit Reports User Reports Manager Reports We implement our images through relative URLs. We put the images we need inside the Images folder (this allows for reuse). In the report, I insert an image from a URL (When using the wizard, I use a random image url). Once the wizard is finished, I change the Value property to be the URL like the following =iif(condition, ""../../Images/StoplightSingleRed.gif", "../../Images/StoplightSingleGreen.gif") You could also just use an absolute path (we used the relative in case we changed server names). Hopefully this solution will work for you. Regards, Dan
Maybe I wasn't as clear as I could've been. The folder structure above
is what we have implemented in the Report Manager. We then uploaded the files to the report manager inside the image folder.
Dan,
Worked like a hot darn! Thanks. FYI, the solution was to drop in an image, link it to one of my existing images, just for giggles. Then I modified the Value section on the Properties of that object to: =Switch(Fields!PDPType.Value="Bug", "http://localhost/images/bug.gif", Fields!PDPType.Value="Customization Request", "http://localhost/images/customization.gif", Fields!PDPType.Value="New Feature/Enhancement", "http://localhost/images/enhancement.gif", Fields!PDPType.Value="Script Request", "http://localhost/images/script.gif", Fields!PDPType.Value="Support Request", http://localhost/images/support.GIF) I might have to tweak and tune my file locations, and I've got to re-size all my images so they're consistent (darn graphics people...). But I didn't know you could put a conditional value in the image Value section. That's the piece I was missing. The documentation on a lot of this stuff seems to be rather lacking. It seems to cover the very minimum amount. Clint [quoted text, click to view] "Dan" <daniel.lenz@qg.com> wrote in message news:1141321207.081912.144230@z34g2000cwc.googlegroups.com... > Maybe I wasn't as clear as I could've been. The folder structure above > is what we have implemented in the Report Manager. We then uploaded > the files to the report manager inside the image folder. >
Ok, so this started working. But now I've thrown sorting on the report, and
as soon as I sort, the images get lost. If I look at the source for the page, the image tag comes up like: <IMG class="r1" SRC=""/> , whereas the pre-sorted image tag looks like: <IMG class="r1" SRC="/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=cc3iww2i5xcx2jea3gi0ia45&ControlID=33d1f91a-7bc7-4876-a195-7210eae11061&Culture=1033&UICulture=9&ReportStack=1&OpType=ReportImage&StreamID=56"/> All this works fine in the Preview in VS2005 (the sorting, that is). Any ideas? I'm beginning to think I should have imported the images into SQL... Clint [quoted text, click to view] "Clint" <nobody@nowhere.non> wrote in message news:%23zeX2MjPGHA.3728@tk2msftngp13.phx.gbl... > Dan, > > Worked like a hot darn! Thanks. FYI, the solution was to drop in an > image, link it to one of my existing images, just for giggles. Then I > modified the Value section on the Properties of that object to: > > =Switch(Fields!PDPType.Value="Bug", "http://localhost/images/bug.gif", > Fields!PDPType.Value="Customization Request", > "http://localhost/images/customization.gif", Fields!PDPType.Value="New > Feature/Enhancement", "http://localhost/images/enhancement.gif", > Fields!PDPType.Value="Script Request", > "http://localhost/images/script.gif", Fields!PDPType.Value="Support > Request", http://localhost/images/support.GIF) > > I might have to tweak and tune my file locations, and I've got to re-size > all my images so they're consistent (darn graphics people...). But I > didn't know you could put a conditional value in the image Value section. > That's the piece I was missing. The documentation on a lot of this stuff > seems to be rather lacking. It seems to cover the very minimum amount. > > Clint > > "Dan" <daniel.lenz@qg.com> wrote in message > news:1141321207.081912.144230@z34g2000cwc.googlegroups.com... >> Maybe I wasn't as clear as I could've been. The folder structure above >> is what we have implemented in the Report Manager. We then uploaded >> the files to the report manager inside the image folder. >> > >
Ahhh, sweetness happens! We happened to have a MS rep here today who
specializes in ReportServer, and I mentioned my problem. He suggested embedding the images, changing the source to Embedded, and then changing the Value statement to: =Switch(Fields!PDPType.Value="Bug", "Bug", Fields!PDPType.Value="Customization Request", "Customization", Fields!PDPType.Value="New Feature/Enhancement", "Enhancement", Fields!PDPType.Value="Script Request", "Script", Fields!PDPType.Value="Support Request", "Support") Besides working properly with the sort, it has be added benefit of distributing the images with the report. Now if I could only get the RowNumber function to work! Clint [quoted text, click to view] "Clint" <nobody@nowhere.non> wrote in message news:exU7IhwPGHA.140@TK2MSFTNGP12.phx.gbl... > Ok, so this started working. But now I've thrown sorting on the report, > and as soon as I sort, the images get lost. If I look at the source for > the page, the image tag comes up like: > <IMG class="r1" SRC=""/> > > , whereas the pre-sorted image tag looks like: > <IMG class="r1" > SRC="/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=cc3iww2i5xcx2jea3gi0ia45&ControlID=33d1f91a-7bc7-4876-a195-7210eae11061&Culture=1033&UICulture=9&ReportStack=1&OpType=ReportImage&StreamID=56"/> > > All this works fine in the Preview in VS2005 (the sorting, that is). Any > ideas? I'm beginning to think I should have imported the images into > SQL... > > Clint > > "Clint" <nobody@nowhere.non> wrote in message > news:%23zeX2MjPGHA.3728@tk2msftngp13.phx.gbl... >> Dan, >> >> Worked like a hot darn! Thanks. FYI, the solution was to drop in an >> image, link it to one of my existing images, just for giggles. Then I >> modified the Value section on the Properties of that object to: >> >> =Switch(Fields!PDPType.Value="Bug", "http://localhost/images/bug.gif", >> Fields!PDPType.Value="Customization Request", >> "http://localhost/images/customization.gif", Fields!PDPType.Value="New >> Feature/Enhancement", "http://localhost/images/enhancement.gif", >> Fields!PDPType.Value="Script Request", >> "http://localhost/images/script.gif", Fields!PDPType.Value="Support >> Request", http://localhost/images/support.GIF) >> >> I might have to tweak and tune my file locations, and I've got to re-size >> all my images so they're consistent (darn graphics people...). But I >> didn't know you could put a conditional value in the image Value section. >> That's the piece I was missing. The documentation on a lot of this stuff >> seems to be rather lacking. It seems to cover the very minimum amount. >> >> Clint >> >> "Dan" <daniel.lenz@qg.com> wrote in message >> news:1141321207.081912.144230@z34g2000cwc.googlegroups.com... >>> Maybe I wasn't as clear as I could've been. The folder structure above >>> is what we have implemented in the Report Manager. We then uploaded >>> the files to the report manager inside the image folder. >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |