Thanks!

Many thanks brunm, that worked perfectly!

Thanks for you reply brunm.

I'm not 100% with you, mostly because I'm still new to this...

At the moment, my parameter dataset query looks like this:

SELECT DISTINCT TERM_TYPE, TERM_TYPE as Terminal

FROM...

brunm (12/2/2008)

---

This is what i was suggesting, i do this with all my parameters that i use in SSRS report as it allows me ignore criteria/parameters if i want to...

Thanks for your reply

The role is set up at the very top level - home. Nothing has changed there.

I have 2000 and only get the 3 options you describe.

I've tried to upload a spreadsheet with an example of what I mean. I can match the call records 'manually' with the application of common sense. I'm just not sure...

Hi Matt,

Sorry, I just made those times up. There is frequency no rule for dialing in. The calls times are random. The mail users are at sea using a satellite...

Thanks for the suggestion - can you expand on that  - I'm not sure what you mean?

Managed to make it work!

Did what I suggested above and used this expression to create the...

Hi Michael - not really sure what that does or how to use it - beginner status I'm afraid

I had a vague plan...

Hi Jon,

No idea how to use stored procedures - as I've said before, I'm a beginner!

 

Am revisiting this issue.

Can anyone enlighten me as to how to get the Globals into the SQL function?

E.g., if I use a convention where...

Maybe you're right, I'll give it a go.

Is there anything else that can held or referenced at project / global level?

 

Thanks for your help. I think I'm going to give up on this line of enquiry. My brain hurts now, and as far as I can tell there doesn't seem...