with as many columns as the states, you can simplify things a lot. In this
case, you don't need the custom assembly at all. Instead, you could just
"Teo Lachev [MVP]" <teo.lachev@nospam.prologika.com> wrote in message
news:%23EDhioP9FHA.636@TK2MSFTNGP10.phx.gbl...
>I think it is possible although not trivial. Here are two approaches you
>can consider:
>
> 1. Add the US map as an image to your report. Create and add overlapping
> green and red images for each state. Use an expression-based Hidden
> property for each image. Now, because the RDL object model doesn't
> currently give you access to the properties fo the report items on the
> report or/and positional access to the dataset records, you would need to
> set the Hidden expression to call a method in a custom assembly. That
> assembly would retrieve and cache the dataset, locate the state record,
> and return True or False accordingly.
>
> 2. With RS 2005, consider a custom report item. It is more work but the
> final result may be worth it. Hey, you may package and sell that image
> control one day... You never know :-)
>
> Have fun!
> --
> HTH,
> ----------------------------------------------
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog:
http://www.prologika.com/ > ----------------------------------------------
> "eichewy" <eichewy@hotmail.com> wrote in message
> news:1133222146.044713.218810@f14g2000cwb.googlegroups.com...
>> Has anyone used Reporting Services with a map of USA with the States
>> outlined?
>> Here's what I am trying to do ... I have data that counts inventory at
>> each Store across the USA. I want to sum the Store data by State. And
>> then display that information in a USA States map .... changing the
>> color of each State so that those States that have too little inventory
>> are RED and those with too much inventory as GREEN....(for example) ...
>> Can anyone help please?
>>
>
>
