Anyone with any ideas.

I guess you aren't coming back. I did notice something else when going into SSRS Report Manager as Administrator I have the abililty to set up 'Site-Wide Security' or system...

Did you know the answers to these questions:

OK so I'm assuming I'm creating them in computer management on the server the report is on, right?

So I also assume I would...

OK so I'm assuming I'm creating them in computer management on the server the report is on, right?

So I also assume I would need their password since I'm impersonating? Sorry...

OK when you say create accounts on the SSRS box, do you mean login to my reports site as Admin and create the accounts or is this done through SQL...

anthony.green (5/15/2012)

---

if its all SQL authentication and your not in a domain environment then you will need to go down forms/custom authentication and create a number of accounts on the...

I was actually able to figure this out. Since I am using a matrix report I need to use the Sum(Fields!... instead of what I had been trying to use...

It is SQL authentication for the sql servers. So how would that be set up?

That's interesting about the impersonation. Didn't know you could do that.

My question how would I set up AD is that set up on the server the report is running on or somewhere else?

Also if i set up my own login...

I'm actually doing it in the textbox. I right click on the text box where I want to show the value and put and go to Expression and put...

Hi All,

I tried both Daniel and burninator's code and it seems to be better but not calculating correctly for the totals. This is probably something I'm doing wrong but for...

There really isn't a datatype. I'm dividing the results of two fields which are...

Anyone with any ideas on this?

michael vessey (5/8/2012)

---

mldardy (5/8/2012)

---

Get an 'incorrect syntax ner ')' error. I'm trying to see what the problem is because this is usually matching '()' but not for sure.

SELECT CouncilName,...

Get an 'incorrect syntax ner ')' error. I'm trying to see what the problem is because this is usually matching '()' but not for sure.

SELECT CouncilName, LastYearQtyActualContainers as [Containers...