Cross Tab Report Issue

2 posts, 0 answers
  1. Eric Klein
    Eric Klein avatar
    183 posts
    Member since:
    Aug 2009

    Posted 27 Apr 2012 Link to this post

    I have a report that I am trying to create a cross tab for.

    I can get it to creat the report fine but for some reasons the pages will repeat for the toalt number of records I have.
    So when I print a report for 65 records it formats and creats the record and the first page is correct, but it creates 65 pagas all of them exaclty the same.  What am I missing?

    my seltect is as follows
    SELECT  m.FGID, GroupName, CategoryDescription, GroupDescription, TickerAbv, SecurityMasterDescription, SUM(MarketValue) AS Total, e.FamilyMemberName , percentage, (SUM(MarketValue) * percentage) AS eTotal

    what I would like is to group on CategoryDescription and GroupDescription
    then display SecutirityMasterDescription and Total

    then pivot so the FamilyMemberName becomes the dynamic headers with the eTotal as the detail under the FamilyMemberName

    The report formats to this design, but it displays it 65 times.
    Also one other issue, there are time where there are no matching FamilyMembers so iti si getting a null value and printing an empty column, is their a way to suppres the blank column.
  2. Kapil
    Kapil avatar
    2 posts
    Member since:
    Jul 2012

    Posted 10 Aug 2012 Link to this post

    hi Eric Klein

    The duplicates usually appear when you bind the report to a data source and at the same time have another data item (such as Table/List/CrossTab) that is bound to the same data source as well.
    You can set data source directly to the report that you use as SubReport, or use the NeedDataSource event handler of the SubReport item to provide data.

    hope this helps u, 
Back to Top