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...
Hi...yes, under the "Security" tab, all my "Group or user names" are able to: Read & Execute List Folder Content Read Thanks!
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...
Thanks Yulika! http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=4095629&SiteID=1
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...
All, this did the trick ...and thanks for you help! Declare @Temp Table(ColumnA VarChar(40), ColumnB VarChar(400)) insert into @Temp...
I'm trying to use this example: --***************** --***************** USE [ReportingDB] GO /****** Object: UserDefinedFunction [dbo].[fSplit]...
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...
This did the trick: CREATE FUNCTION dbo.ConcatOwners4(@ActID CHAR(50)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @Output VARCHAR(8000) SELECT @Output...
...tried isNull(), and just gives me blank. Almost 100% of the activities have one or more owners.
dineshasanka, This is for the report parameters right?
SELECT@Output= @Output+ CASE WHEN LEN(@Output) = 0 THEN '' ELSE ',' END+ SAN.Authority ...still gives me NULL in the last column, when I know...
I'm trying to use a UDF (we're on SQL Server 2005), and not getting it 100%. The structure is Activities to Owners to SAN. Activities can have 1 to...
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...
got it...just click on the little green triangle on the top right corner of the sub-total text box, and change the bg property.
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...
Separate names with a comma.
