Reports

alternating column color in matrix
How do you alternate the column colors in a matrix... Sql Server 2008. thanks ... 22 Dec 2009 12:37

how to find last character is int
Dear Sir/Madam, How can I know that last character of string is integer of any field. If it is possible in one select command then it is better. For eg. in table register_tbl DelegateNo 'TK-INV-88-CC' 'TK-INV-89' Second delegate no has last character is integer, How can I find all row which last ch... 22 Dec 2009 01:42

occurence of charcter no of times
Dear sir/madam I have to find the no of occurence of character in a sting in sql server. What any function is like that. For eg 'my name is vinod kumar' here 'i' letter is two times. Can I know with any function. Thanks in Advance Vinod ... 21 Dec 2009 05:52

SSRS 2005 questions
Hi, We are trying to have SSRS2005 ready for production and I heard that SSRS2005 upgrade to SSRS2005 is very difficult and SSRS2005 securty is very poor. IS that True? Thanks, ... 18 Dec 2009 15:02

SUMming in RS2005
I'm an experienced C# dev but have never used RS before and am struggling a little with the paradigm... apologies if my question seems really retarded. I am trying to sum rows depending on certain values. Suppose I have a dataset with an "ID", a "Type" and a "Value" column, and the Value column will contain only... 20 Dec 2009 16:56

Adding Remarks in Reports
Dear Experts, I generate a simple report using SQL using ReportsServer but when my Management wants to view the reports - they would like to add few remarks at the end of the each row. How can this be achieved? Any answers or solutions to this will be helpful. -- Girish J Bhatia MOSS Certified, Share... 16 Dec 2009 01:31

Removing empty cells in column groups
Hi All, I'm creating a report with row and column groups. But the columns groups are displaying values in sperate rows instead on the same row leaving empty cells. I need to remove those cells and get the column gropu values in a same row. Please refer to this image http://img526.imageshack.us/img526/713... 18 Dec 2009 02:55

Cover page problem
Hi! My colleague Andy and I are trying to create a proper report cover page? (use as title) We're using Report Builder 2 and SQL Server 2008 with Advanced Services Express Version, and having real trouble creating a report cover page. We're not sure why. I can create a lovely looking cover page and adde... 17 Dec 2009 04:57

How do I exclude data using the IIF statement in report builder
I have data in my dataset that I want to exclude in the average calculation for the final report (those with a key.value of 999). Here is how my statement is written but it is not returning any value. What am I doing wrong? =iif((Fields!MeasureID.Value = 1 or Fields!MeasureID.Value = 16) and NOT Fields!Key... 15 Dec 2009 16:45

Using arrows as layout element
Hi everybody I would like to use arrows (instead of simple lines) on my report. Is there a possibility (I'm sure there is) to extend the items in the toolbox? I just need a component that offers lines with arrowheads. Thanks Dani ... 9 Dec 2009 06:39