i have figured out that the problem is in regards to the user groups and permissions set in reports manager. so this not a problem anymore.

i do now encounter blank...

that is some neat sql there.

seems to have worked after a bit of a fiddle here and there. thanks heaps!!