Hi, thanks for your reply do you have an example of another source control solution?

Thanks

Hi, I think you need to use the isnull function and return a value for the Sale_Unit when it is null

So if the null vlaue for the Sale_Unit is...

Thanks :-), I knew it was there somewhere it is a bit fiddly though, I suppose I just need to get used to the way it works.

There surely must be...

Hi,

Have you tried the query below in query analyser so you can determine whether the issue is with the report or the sql query?

Select customer_id, customer_name,country_name . . .etc...

Hi

Like Veeren4urs said you need to have a dataset which will provide a pick list for the parameters, something like :

select distinct country_name from customers

union all

select 'ALL'

Then you...

Top Stuff, really helpful

🙂

Thanks!

How do I fire the job off if the validdate is true?

Thanks, it is good to know that it still works in r2, we will continue using it.

🙂

Hi, you can use a matrix object which will allow you to flip the data so you have servderid as the first column followed by a number dynamic columns for...

We have been searching for a solution to this problem as well.

I have read somewhere that a custom delivery extension needs to be created to enable you to have a...

Hi,

If you are using a sql query your dataset should be like the script below:

select * from mytable

where myfield in (@parameter)

Then run your query in the data tab, it...

Glad to hear you resolved your query 🙂

Didn't realise you were using a cube, your different group fields will have to come from the dataset ie your cube so you will need to create new facts.

I understand the error message you are getting and I don't think we will be able to get round the aggregate issue.

I think it would be probably be easier to...

How do you want the data to be shown? are you using a table ?

the total fields should be shown in the table footer.