And now it becomes a design issue, do you store the DW data in a denormalised structure (this is standard practice for a DW) do you then write 2 distinct reports targeting each system. How often do you transfer data to the DW? How often do you purge data from the production system? Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP