Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109

    Unanswered: ORACLE REPORTS Matrix Report

    Sir,
    my problem is given blew.

    table Name :student_fees
    Fees updated are 01 May 2010 to 20 May 2010
    colmun Name : Fees Date 01 May 2010 to 20 May 2010

    Requierd Date is
    colmun Name : Fees Date 01 May 2010 to 31 May 2010

    Report Formate is

    Fees Date : 01May 02May 03May 04May 05May 06May
    CLASS_id: AMT AMT AMT AMT AMT AMT
    C1 25400 24005 26000 27000 28000 29000
    C2 == == == == === ==
    C3 == == == == == ==
    C4
    C5 == == == == == ==

    HOW IS POSIBALE?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Did you try to use Report Wizard? It will guide you to a (more or less) complete solution.

  3. #3
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109
    He is my friend who ask the question in proper way his question is

    he has a table in which there is dates and date is from 1 till 20
    his problem is that he want to show a month all dates not 1 to 20
    suppose
    1 2 3 4 5 6 7 8 9 .............................................30 or (whatever 29 etc)
    and show records of them if it has 1 to 20 date but show 1 to all and if it doesn't have any data in 21 to 30 show empty column but show 1 to last day of month

  4. #4
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109
    no one have answer ?

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    When questions are asked poorly, answers can't be wise either. I, for example, didn't understand what you are talking about. The first message contains a "so-called" example, but - as it is not formatted - I don't feel like deciphering what you meant to say. The same goes for your last message.

    I *think* that some kind of a row generator is what you are looking for, but - can't tell for sure. If you want, check "missing data" discussions.

    Or, rephrase your question, learn how to properly format it, explain what your input and output are/should be, and hope that someone will be able to answer.

  6. #6
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109

    Well format quesion of mine

    Now i am writing my question in well format you didn't understand what i am saying.....

    PHP Code:
    Fees Date :  01May     02May     03May      04May     .till.....       end of month
    CLASS_id
    :    AMT        AMT        AMT        AMT        .till.....       AMT
    Class1         25400      24005      26000     27000      
    .till.....       29000
    Class2         
    ==           ==          ==           ==        .till.....        ==
    Class3         ==           ==          ==           ==        .till.....        ==
    class4         ==           ==          ==           ==        .till.....        ==
    Class5         ==           ==          ==           ==        .till.....        == 
    i have dates record till 20 in my table but when i am making report i want to do that it shows me till end of months

    like

    1may 2 may 3may ........so on til ................end of month may

    when i am making report using wizard it shows me records how much i have in my table suppose 20 but i want till the end of month

    how to do that now i hope you will understood my question ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •