I have a line chart series that is for accounting. A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns...
I'm trying to call a report viewer from a page prompting for three parameters: 1. Dropdown list value 2. Start Date 3. End Date The request failed...
We are trying to see if it's possible to see which users are running what reports. When users hit a report, they have to enter their WIN credentials....
I have a main report, which jumps to a child report. When that jump to / child report loads, the parameters are hidden. Customer would like the...
I'm trying to work on an Integration Services project, and want to have a table copied into another table, but this destination table needs a...
Hello! We are on SqlServer 2005. Let me point out at the beginning that I don't have anyway to normalize this structure or get the admins to change...
I have a field called "Owners", and it's a child to an "Activities" table. An Activity can have on or more owners, and what I'd like to do is some...
So, the main objective for this database/web application is reporting. The issue/situation is: 1. The customer has 10 goals 2. Each goal has at...
I'm dealing w/ SSRS 2005. I have my main matrix report which has five row groups. What I'd like to do is have the subtotal at the 4th level have a...
I'm dealing w/ SSRS 2005. I have my main matrix report which has two textboxes that act as expansion/collapse "objects" for the fourth and fifth row...
What I need to do is check three tables and make sure and ActivityID doesn't already exist when the user tries and update or insert. I can test for...
We have multiline text box of datatype ntext, and users will use tabs to format the data for better readability in our application. How can we keep...
We are using SSRS 2000.<br /><br />I can make the .csv file format correctly with blank lines when I put in the URL a suffix of:<br /><br...
I have the following in my WHERE clause for my Sql Server Reporting Services 2000 report (the user can use the parameter @MaxRevs to view all numbers...
Has anyone had any luck with exporting to .xls or .pdf w/ Netscape v8.1? I have some MAC users, and they need to export some reports. The reports...
We have a table and I'm trying to regulate the duplication of one column, since the business rules have now changed. I want to add a composite...
Hello! I have about 15 databases on our instance of SQL Server, a and it's only growing. I'm trying to figure out how to run a stored procedure for...
Anyone know how to force a print on the back of a page? On the last page of the report, I have to print on the back of this page. I'm doing MSDN...
I'm trying to run the following SQL against my column, Testtbl.Task I want to replace where the ampersand sign got HTML encoded to "&", and I...
I have the follwoing SPROC (it's not working yet): CREATE PROCEDURE [dbo].[usp_UpdateBudgetUpdate] @Budget decimal (18,3), @WPID nvarchar(100), @FY...
Separate names with a comma.