yes I need to store it seperate for now.

I have never done an update with a calculation. just simple

update table

set columnx=y

where columnz = null

type of stuff

thanks

Paresh Prajapati (4/14/2010)

---

bobby.creech (3/26/2010)

---

ok, I've got a report on the report server that gets clients by state, either individual or all. very simple report, client name and state.

they would...

that sounds interesting, i'll have to look into that

just wanted to post a thanks for the suggestion of liked reports. worked like a charm.

ok, I setup the linked reports and emails.. sent a test one, and confirmed that they really wanted one report for each state. got a thumbs up, I'm thinking they...

hmm.. never tired linking a report. that sounds like a good option I will look into that. Thanks 😎