Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Numbering columns in matrix Tablix Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 9:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:24 PM
Points: 1,805, Visits: 5,867
mahler9 (6/18/2013)
I received an error when building the report. However, I am not certain whether or not I executed your suggestion the way you intended. Please see the attached PDF.

Also, I'm wondering if\how the following report components factor into things.

Order number expression:
=replace(Fields!SOPNUMBE.Value,"DTCI","") --strips "DTCI" from SOPNUMBE


This shouldn't affect things, as long as you are not creating duplicates by stripping the prefix.



Row groups:
matrix1_BinNumber (group/sort on BinNumber),
matrix1_ItemNumber (group/sort on ItemNumber),
matrix1_ItemDescription (group/sort on ItemDescription)

Column groups:
matrix1_SITE (groups on SOPNUMBE, sorts by Location)


Thanks again!


The reason you only get Insert Row ...Above or Below is because you already have another row inside the group above the cell you are right clicking on, so it can only insert inside the group from there.

Can you post the expression you used for the column numbering?

edit: I meant to say, I just tried this on BIDS 2008 and it worked just fine...


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1464754
    Posted Tuesday, June 18, 2013 11:02 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Monday, November 10, 2014 8:33 AM
    Points: 15, Visits: 58
    Thanks for your response!

    I pasted the following expression into the cell above expression for order number,

    =RunningValue(CountDistinct(Fields!SalesOrder.Value),SUM,"DataSet1")

    then edited, replacing "SalesOrder" with "SOPNUMBE".

    I am also using BIDS 2008.
    Post #1464792
    Posted Tuesday, June 18, 2013 1:08 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Yesterday @ 5:24 PM
    Points: 1,805, Visits: 5,867
    Is your dataset called Dataset1? If not, you need to change that.

    Can you paste here the exact expression you are using?


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1464847
    Posted Tuesday, June 18, 2013 3:14 PM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Monday, November 10, 2014 8:33 AM
    Points: 15, Visits: 58
    Dataset1 is indeed the name of the dataset.

    Exact expression: =RunningValue(CountDistinct(Fields!SOPNUMBE.Value),SUM,"DataSet1")
    Post #1464886
    Posted Tuesday, June 18, 2013 4:11 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Yesterday @ 5:24 PM
    Points: 1,805, Visits: 5,867
    Let's try something, attached is a working report with column numbering.

    It uses inline XML data, so no need to connect to SQL to run it, just open the project and preview the report.

    Once you confirm whether it is working, you can examine the report - it is simply a matrix with two row groups and one column group with two rows in the column group and our friendly expression on the top cell.



    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw



  •   Post Attachments 
    Column Numbering.zip (0 views, 4.27 KB)
    Post #1464900
    « Prev Topic | Next Topic »

    Add to briefcase ««12

    Permissions Expand / Collapse