are you sending the stored procedure "User!UserID" as a parameter? i ran into this issue when i started trying to include that to audit the use of...
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:...
i found it in the config file, sorry for the inconvenience Joe Janka
i am doing what you recommend for the recipients, but when it shows up in receipients' in-box, it shows as if it came to them from...
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...
my recommendation takes a couple steps, but its the best way to work it, at least in my opiniong A) keeping the SQL for SQL Reporting Services in a...
put an =iif(Parameters!OptionOne.Value = "FieldName1", Fields!Field1.Value, Fields!Field2.Value) in the textbox's value (and accompanying header too...
allow a Null option, then in the SQL, put FieldName like isNull(@Parameter, '%') if its null, it will pull them all Joe Janka
in the Color property for that bubble, put: =Parameters!ThisBubbleColor.Value make the appropriate options in the parameter dialog box Joe Janka
what would you like in terms of dynamic? something like if a parameter = option one, then it pulls column1 and if parameter = option two, it pulls...
yes, if you get the CD or if you can get MS to send you the installation stuff, go to the server and install "Server" options, then when you open the...
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,...
is you datasource shared? Joe Janka
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...
Separate names with a comma.
