I have googled and googled this question and i am constantly reading that it is not posible

does anyone know of a work around? or another alternative.

Hi

I have this same problem

the above solution doesnt work, it is what I have tried and where i get the error (unless im not understanding)

I have built the report without...

Thanks for the reply

I dont want to do a query to get the distinct values, i have the values in a dataset linked to my report already. I want to...

Thanks for the answers

So the conclusion is, if i use this method in a query it could return different results when run in the morning to when run in the...

and im on 2008

i get 14782 for the first and 14783 for the second

there was just a long delay between me making the changes and the changes showing in the live environment.

thanks

Hi

Does the server take some time to update or something?

if I access the report via our intranet site on the webserver the same way as I would on my local...

where do i go into report definition?

thanks

Hi

I have opened BIDs and then gone to file > open > file and when i paste the url in the open filed it just opens a page that looks...

Hi

Sorry maybe there is another way to do what i need to do.

I just need to be able to edit the reports, i have the path for them all...

Hi

Thanks i was looking in the wrong database.

The path gives me the URL, what i really need is the windows path

is this posible?

thanks again

hi

yes it looks like you understood the question

the code gives the error - invalid object name catalogue

Thanks again

sorry, i couldnt find that post and i thought you had deleted it because i had put it in the wrong section

thanks