Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Problem with Columns SSRS

Answered Problem with Columns SSRS

  • Tuesday, April 24, 2012 9:59 AM
     
      Has Code
    Sign In to Vote
    0

    Hi Friends,

    This is my Code It is working fine in the SSMS

    I was getting 4 Columns,

    Cust,Year,HalfYear(includes Halfyear,Quater,Months),Net

    but when I run this code in the SSRS it was splitting into 6 columns.

    Cust,Year,Half,Quater,Month,Net if it splits like I can not get my Template view.

    WITH MEMBER [Measures].[Net Amount]
as [Measures].[Net Amount GBP - Sales] 
SELECT NON EMPTY 
[Measures].[Net Amount]
ON 0
,NON EMPTY (
[Customer].[Name].[Name] 
* 
{[Time].[Fiscal Year].&[2012].lag(1):
[Time].[Fiscal Year].&[2012]}
*
descendants([Time].[Fiscal Hierarchy].[Fiscal Half Year]
,[Time].[Fiscal Hierarchy].[Fiscal Month],self_and_before
)
)
ON 1
FROM [Retail]

    This is my template view

    Where is the Problem could anyone tell me

    Thanks,

    Rama

     

All Replies

  • Tuesday, April 24, 2012 12:30 PM
     
     
    Sign In to Vote
    0

    SSRS flattens the dataset, so the behavior is a little bit different than what you get in SSMS.  It seems though that you do have 6 different data elements in your template which need to be displayed.  Where it the issue?  In how to map that into a table in SSRS?

    mark

     
  • Tuesday, May 01, 2012 5:30 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi bandlamudi123,

    In your case, I think that you can try to use a matrix to design the report. The matrix grows horizontally and vertically on the page. So, you need to add two column groups such as “Quarter”, “HalfYear”.

    Regards,
    Bin Long

    Bin Long

    TechNet Community Support