GilaMonster (10/1/2011)

---

giontech (10/1/2011)

---

By the way, the database files are still in the MSSQL Data Folder, it was like 30 minutes past already since I clicked to take offline, obviously there...

Actually I found out the databases were only invisible in object explorer, but visible in "New Query".

I went to new query, and did the following command on the db I...

thanks man!

I managed to do it with a domain user, using IReportServerCredentials.

Still interested in knowing how to do it with an sql server user thou.

Thanks! It worked!

Now one more question: Is it possible to put a timer after a process is executed (for example running a bat file), to make sure it finishes execution...

I'm using SSRS, and I'm putting this in a matrix. I can do this too:

_SELECT

DATE,

STATUS,

COUNT(1) [TOTAL]

FROM

TABLE

GROUP BY

DATE,STATUS

But then I don't get the control of each of the status...

Yes I have tables like 'WRT_%', and I think I solved the left length problem by storing it in a variable.

I'm getting "Invalid length parameter passed to the SUBSTRING function.", also how would this be put into a stored procedure?

Thanks

It worked! Thanks Alot!

Now I wonder if there is a way that reporting services can sum or average time.

Thanks