Hi Friends, I am Ali, i have a small design problem in reports. 1. My Report Server configured in SharePoint integrated mode. In Report Builder 3.0 i Am able to create Matrix, interactive ...etc reports. But here small report design i am not able to create. 2. I need report as bellow table. and i want gave the colors for ODD and EVEN rows. In this table first column is title column. and 2nd column is Field column. Please dont mind help me for below design. Fields Name | [Name] -------------------------------------------------------- Number | [Number] ------------------------------------------------------- Designation | [Designation] --------------------------------------------------------- Email ID | [Email ID] ------------------------------------------------------ Qualification | [Qualification] --------------------------------------------------- D-Of-B [D-Of-B] ----------------------------------------------------- i do not want like this Name | Number | Qualification | D-Of-B | Email-ID -------------------------------------------------------------------------------------------------------------------------- [Name] | [Number] | [Qualification] | [D-OF-B] | [Email-ID] Thanks Ali. MD.Liakath ali

Hi Friends, I am Ali, i have a small design problem in reports. 1. My Report Server configured in SharePoint integrated mode. In Report Builder 3.0 i Am able to create Matrix, interactive ...etc reports. But here small report design i am not able to create. 2. I need report as bellow table. and i want gave the colors for ODD and EVEN rows. In this table first column is title column. and 2nd column is Field column. Please dont mind help me for below design. Fields Name | [Name] -------------------------------------------------------- Number | [Number] ------------------------------------------------------- Designation | [Designation] --------------------------------------------------------- Email ID | [Email ID] ------------------------------------------------------ Qualification | [Qualification] --------------------------------------------------- D-Of-B [D-Of-B] ----------------------------------------------------- i do not want like this Name | Number | Qualification | D-Of-B | Email-ID -------------------------------------------------------------------------------------------------------------------------- [Name] | [Number] | [Qualification] | [D-OF-B] | [Email-ID] Thanks Ali. MD.Liakath ali You can try this: The following expression, when used in the BackgroundColor property of a report item in a data region, alternates the background color of each row between pale green and white: Copy =Iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White") If you are using an expression for a specified scope, you may have to indicate the dataset for the aggregate function: Copy =Iif(RowNumber("Employees") Mod 2, "PaleGreen", "White") This is as per: http://msdn.microsoft.com/en-us/library/ms157328.aspx Hope this helps..Chaitanya

Hi Ali, If you are getting the values in columns then you can use Chaitanya's above suggeted method. But if your if your data is in row fomat, you first need to perform corss-tab to transfer data into columns. Kindly have a look at below example, for how to do it. declare @tab table ( recordId int, FieldName nvarchar(max), FieldValue nvarchar(max) ) insert into @tab values (1,'Name', 'James Swan'), (1,'Number', '1'), (1,'Designation', 'Manager'), (1,'Email ID', 'James.Swan@123test.com'), (1,'Qualification', 'BS'), (1,'D-Of-B', '1990-1-1'), (2,'Name', 'Ricy Warne'), (2,'Number', '2'), (2,'Designation', 'Clerk'), (2,'Email ID', 'Ricy.Warne@223test.com'), (2,'Qualification', 'MS'), (2,'D-Of-B', '1990-10-2') --select recordId,FieldName,FieldValue from @tab select pvt.* from (select recordId,FieldName,FieldValue from @tab) as src pivot (max(fieldvalue) for fieldname in ([Name],[Number],[Designation],[Email ID],[Qualification],[D-Of-B])) as pvt But, if you have more columns and you can not perform static pivot then you can create a Matrix report and to produce alternate colours of rows in matrix, kindly follow the steps given at.. http://blogs.msdn.com/b/chrishays/archive/2004/08/30/greenbarmatrix.aspx -Chintak

Hi Ali, A simple way to achieve this is using multiple detail rows in the table. Suppose there are 6 data fields (Name, Number, Designation, Email-ID, Qualification and) in the dataset, please refer to the steps below: 1. Insert a table to the report. 2. Right the handle of the detail row in the table, select Insert Row -> Inside Group – Below. 3. Repeat Step 2 to insert 4 more detail rows. 4. In the first cell of the first detail row, type in the text Name. In the first cell of the first detail row, specify the data field Name by the expression like =Fields!Name.Value. 5. Repeat Step 4 to add other title text and data fields to the other detail rows. 6. Select the first, third and fifth detail rows, then specify the background color to them. After that, the table would look like the following picture Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.