I don't have any particular format for naming the folders. It is usually just the customer's name, so I don't think this will work.

I’m probably not explaining myself very well, sorry. I’ll try and elaborate…

I start with a ‘base’ project. It has a shared data source so...

My SQL knowledge is rather 'basic'; I don't know where to start with this.

All I want to do (if it's possible) it create some custom code that says what...

It does look like this is the case (although I've only been working iwth the data for a couple of days, so I can't be certain).

So more questions:

1. What expression do I...

All sorted now, thanks Steve.

Steve,

Thanks again for your help - you are a star!

Couple of questions, forgive me, I'm still learning.

If I copy and paste all of the above into the SQL pane to...

Si,

I'm sorry to say I never found a solution to this. As far as I can tell RS for SQL 2000 can't do this. Maybe it's available in SQL2005?

Paul.

Steve,

Many thanks for your help with this. I'm getting an error message I don't undertsand though: "Invalid length parameter passed to the substring function". Can that be solved?

Also, the 'CC'...

Thanks for the input. All I can see in this field is "<long text>". I don't know anything about xml or regex, so I don't know how to get started...

I've used that view - it's really helpful, thanks.

However, it looks like the subscriptions.descriptions field only appears to give a description including the first...

Thanks for yor help!

Simon, many thanks, that worked a treat. 3 days of messing aroud trying to get RS to work and the simple solution was just to get SQL to do the work...

New...

Thanks for the reply David. I've tried that, it doesn't work. My

group filter is there to prevent groups with a sub-total (i.e. balance)

of >0 appearing; however, groups/sub-totals can...

Sorted! For anyone bothered...

Report parameter, default value, non-queried, called @START:

=IIF(DATEPART("d",today()) >= "10",DateSerial(Year(today()), Month(today()), 1) ,DateSerial(Year(today()), Month(now)-1, 1))

And query parameter of Date <= @START.

Works a treat.

"brain fart"

'Cos I'm from a Crystal background (and an accountant - not a programmer) habit would have me want to put the logic...