i would like to sum up a field as a subtotal on a table, but i want it to only be if another field is equal to a certain value, an example would be...
I want to send the stored procedure on the back-end of a report the NT UserName, is there functionality in this version and/or 2005 to do this? I was...
I want to be able to type a user/group's name in and be able to see what rights they have to anything on my report server, is this possible?...
Does anyone have a basic troubleshooting guide for ODBC errors between an application and a SQL Server Database? The Eror reads somewhat like this:...
we want to change the email address that the subscriptions come from, is there a way to do this without uninstalling and reinstalling the whole darn...
is there a way to see what users are running which reports on the reportserver? RS2000 Joe Janka
i have a server with a t-log that acts as if the drive the database resides on is full when it has 50 Gigs left, the drive is 546 Gigs big, is there...
I want to have a report e mail me the results in excel format every night only if it returns rows, can data-driven subscriptions do this, and if so,...
Has anyone run into a problem where the stored procedure used by a report runs quickly in query analyzer and very slow from both the .Net dev...
I want the rows in a report to have a number, rowcount(table1) doesnt work, is there something like that which would put row numbers as the first...
When we take backups, we xcopy them from a folder (on a remote server) containing all of the backups for the databases on that server accross a...
If I have default values for all of my parameters in a report, the report runs upon being opened, how may I turn this option off? Joe Janka
Is there a way to see which users are running reports at a certain time, and if there is, what reports they are running? Thanks in advance!!! Joe...
I am in the process of looking for audit software. My SQL Servers are on an intranet, and contain all types of databases. Is there a package that...
I have a report that I want to do an iif for the day, so that on monday, the background is green, but the rest of the days are red, can i do that?...
We just moved our SQL Server from one server to another, however, when we try to run our DTS packages that we moved over, we get an error stating...
I tried to truncate a table using the execute sql task object and it would not allow me, the error message i got said: Invalid SQL statement;...
As I am makingchanging databases I have, I started thinking about who should be the owners of what database. Should they all be owned by sa or...
How could I create an allocation or consistency error (or otherwise corrupt a db) in a database to test a backup and restore system? Joe Janka
i need a sentence in a textbox to contain one bold word, how do i do this? i want it to look like this is the bold word Joe Janka
Separate names with a comma.