thanka mate, i realised just after i started the thread which is why i added the second post

it had been a long day 🙂

sorry for the daft post

fixed

thanks for the reply

i shouldnt have really started this thread

the groupings on the report were kind of clashing with the groupings on the query and it was bringing some weird...

hi

thanks for the reply

the total is greater on the report than it should be, i have run a query using the ssrs query designer just returning the total with exactly...

thanks a lot for the replies, ill try some of what you said and hopefully get it resolved today

thanks again

thanks again for the reply

the home page of the site that the reports can be accessed from is

https://<server>/ReportServer/Pages/ReportViewer.aspx?%2fOCSReports%2fOCS+Reports+Home+Page&rs:Command=Render

from what you are saying it doesnt look like the reports...

do i need BIDS installed on the server /machine that i will be editting the reports on?

ahh so how do i find them?

another basic question

on the server where the report are kept you would expect some .rdlc files wouldnt you?

i cant find any of the existing reports on the server

by report manager do you mean the site or location where the reports are to be viewed?

and for instance if i had the permissions i should have a report builder...

its a sharepoint application

any idea how i could work out what this url is?

thanks for the reply

the only way i have at the minute of opening the report is through the report builder

is this the right place?

if not how should i be accessing...

ok thanks, ill give it a try

i seem to be able to add a table or an existing view but i want to add queried data

but im never given the option