Post reply

Matrix Help

  • March 20, 2006 at 7:38 am

    #167643

    sql server 2005

    Hi all,

    I have a finacial report that I need to show all periods 1-12 (columns) regardless if there is data or not. what i am getting is

    account-----1-----5-----6

    a#1235-----#----" "----#

    a#2346----" "----#-----#

    what i want is

    account--1--2--3--4--5--6--7--8--9--10--11--12

    even if the accounts 1235 and 2346 only have data for a couple of periods i want all periods to show on the report.

    is this possible? can someone help me please, tell me what to do or point me to an article?

    Thanks in advanced,

    Kerrie

  • March 20, 2006 at 11:46 am

    #627688

    if you are using sql then just implement a union with all months.

  • March 20, 2006 at 11:56 am

    #627689

    Thanks for replying. I got it finally.

    Thanks again, Kerrie

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply