And change your server properties to always log cube builds -> right click on the server, select properties and then set the log file to be somewhere you'll remember it.

Two things: 1. Test your server with a new subscription with NO attachment or embeded reports, just links, this should work.  2. Check your log files, in particular look for...

If you're running enterprise edition you can use Data Driven Subscriptions, which will let you pass value/s to the parms for the report.

If you're not running Ent Edn, then you're...

(In Object explorer pane) try right clicking on the DB in question, then from the context menu select Tasks|Generate Scripts.  This then fires a wizard (yeehaw) that will do what...

Guys, grab a hold of SQL2K5, using Management Studio, set your options for the Query Results to Grid and Text options to be 'include column headings when copying from query results'...

Hey kitkat,

Moving back to a simpler approach, have you tried the following:

1. Create a new stored proc.  In this proc, create a global temp table with two fields, the first...

You may also want to take a look at the suggestions in this post -> http://www.aspfaq.com/sql2005/show.asp?id=3  although they focus on Express Manager connections, the last suggestion re: moving TCPIP...

Hey Matthew,

Take a look at thi previous post re: snaking cols...  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=159422

cheers,

Load up visual studio & RS developer on a development machine (or your own) and create a new Reporting services project.  You can definitely make a start without any *coding*...

Can't you use the mod (ie modulo) function to achieve this? 

ie (in pseudo code) = SUM(somefield) / 60 & ":" SUM(somefield)%60

I'm not sure what modulo is in VB.net but...

The reports won't pick up the datasource local to them (ie in the same folder) unless you published the DS to that folder from te same project that contained the...

Hey kitkat,

I'm not sure if the following will work for you but in general it does what you're looking to achieve. 

The table control (and possibly the matrix?) allows for...

I got mine through the beta site but I thought a friend of mine (technet subscriber) said that the downloads site for technet had them in there also??

for reference, the...

You could try creating a new procedure based on your existing one, and instead of the print statements change them to inserts (into a temp table) and then at th...

A couple of questions:

you've mentioned that for performance reasons you drop and recreate the tables (and indexes) each day, and that insert into (as per wildh) is not an option. ...