Hi Mate

Thanks for the reply

I have added a few groups now tried it on detail and on group rows and group columns and on the header line and i cant...

Hey

adding &rs:Format=PDF to the end of my url isnt openning the reort directly as a pdf, in fact its having no change

I have tried &rs:Command=Render&rs:Format=PDF also

can anyone help please

thanks in...

no it doesnt have to be

a tablix would be fine

thanks a lot

Elliott Whitlow (5/26/2011)

---

Hold up..

You have to do this with an account that has sufficient rights, you can't just add yourself as an administrator if you don't have another account. ...

Elliott Whitlow (5/26/2011)

---

If I read your question right. You have a local SQL server but your normal domain login does not have sysadmin rights?

Just add a login in SQL...

it was the permissions mate thanks

in oracle i had to assign permissions to the user that was accessing the linked server for each of the tables that i needed

that is what i thought but the tables available in the sql server linked server are only a selection of the tables from the oracle schema

maybe it is permissions

great that mate thanks a lot

the parameter is populated from a sharepoint document share

i can have as many parameters as i need but they need to change depending on the day

so unfortunately there will have...

thanks

the issue was in the properties, the cells were set to no decimal places

thanks again

i can export a one off to text using the export wizard

i cant save it as an ssis because it isnt installed

i need to export it daily

i dont know which...

🙂 I didnt know that

I need to do it automatically daily

is there a simple way?

or is there another way of doing it?

i cant use ssis

I have worked it out

you can group on the details section of the list so i grouped it by department which gave me a destinct list of the departments in...