Well thats the bit I am struggling with, as I thought of adding an extra chart area which is of a line chart type which does an average on the...

No, not to worry, I'm in the same boat at the moment where we are designing a internet facing SSRS solution for our new SaaS product which is in development...

Sure, there are plenty out there on Google, but this is the one I use, you may find a better one in the searches depending what you actually want to...

You will need to create a number of windows accounts in computer manager, then grant them the nessesary access they need in SQL, then grant them the nessesary access the...

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