Pls help me with my below issue. Hi, I developed SSRS 2005 Matrix Report. In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row. How can i Referencethat Row Values / Matrix suntotal Values Like that ? Below is formate of my Matrix SSRS 2005 Report. Jan Feb March Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal Bangalore 135 192 197 Delhi 149 185 278 Total 284 377 485 How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2005 Matrix ? Let me know if need information. Thanks.

Hi, You can use Custom Code to achieve this. To add embedded code to a report, use the Code page of the Report Properties dialog box. The code block you create can contain multiple methods. Methods in embedded code must be written in Microsoft Visual Basic and must be instance-based. The report processor automatically adds references for the System.Convert and System.Math namespaces. Use the References page of the Report Properties dialog box to add additional assembly references. In this case, please follow the steps below 1. Open the report and find Code page in Report Properties. 2. In the codes, you may use codes like below Public Shared x as Single=0 Public Function Get(value as Single) as Single x=value return value End Function Public Function Return as Single return x<br/> x=0 End Function 3. In the subtotal cell, use the expression like =Code.Get(your_subtotal_expression_here) 4. In the another row, use the expression like =Code.Return Hopefully this helps. TonyYao Jie Tang -Microsoft Online Community

Hi Firends, Is there any ways to export Multiple RDL files into One PDF File ? How can we automate and schedule this Process ? pls let me know any thoughts / suggesions. Thanks.

Should be a new question, but.... I cannot speak to SSRS 2008 forward, but for SQL 2005 we use a product called SQL-RD from Christian Stevens

Hi buddy, Have you solved this issue? I also have this problem with the percentage calculation on the specified row, with Yao-Jie's custom code, I still cannot access the cells in the matrix... Can you or someone else help? As shown below, for instance, how can I access the cell value of (GROSS REVENUE - Actual - Jan) and use it in Yield cell for percentage calculation? Thanks in advanced. Jan Feb Mar GROSS REVENUE Actual 10,653 9,203 11,883 NET REVENUE Actual 270 170 249 YIELD Actual 2.54% 1.85% 2.10%