So yeah your in a workgroup environment with no AD, so you will need to write a custom authentication methods which impersonate accounts which exist on your SSRS server.

Sorry I didnt add in my code for that

You will need to add in a ROW_NUMBER() clause to generate a number then use the rownumber output as the series.

create table...

The only way I can think off is to do series break downs, but that wont be pretty as if multiple dates have multiple values you will get multiple lines.

You...

Yep, thats also another good solution Vinu. We just need to wait and see now what the actual requirements are from the OP as we might be heading in...

could it be that its using parallelism and using more than 1 thread. try putting OPTION (MAXDOP 1) at the end of your query to force single-threading

you can use xp_readerrorlog / sp_readerrorlog and specify the parameters needed to only view the last month.

you can configure the amount of logs that SQL stores in the archive but...

have you granted the user the access to the sql server to run the t-sql/procs that your reports use?

what errors do you get?

Bumping this. I still haven't found the calculation, unsure if someone else may know.

based on what I think you are asking for its a pivot/cross tab query, I have knocked up some sample data which does what I think your asking for below,...

I would say that the only other way would be to select the different parts into a number of temporary tables and then use logic around that to bring back...

reidres (5/15/2012)

---

I want to do a select in a proc and if @@ROWCOUNT = 0, I would like to kill that rowless resultset so that it is not returned to...

Hi could you please follow the second link in the signature block below on posting code and post the DDL of the tables along with sample data. Also please...

Hi, Welcome to SSC, please take a moment to read through the second link in my signature block on how to post code on the forum. It will help...

unsure if this is one option.

Create subscriptions which run the report to a shared drive and export in excel format, then use something like an excel file merger http://ask.metafilter.com/106144/Combining-a-ton-of-Excel-files-into-one-Excel-file (just...

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 SSRS...