Cross tabulation for Date

(2 posts) (2 voices)

Tags:

No tags yet.

  1. bushraj, Member

    Hi,

    I'm using Cross tabulation for daily report where Date is the cross tabulation field.It is showing the dates where only the data exists. i also want to show the dates where no data exist having value as 0. Like i want to show complete dates for a month. The query em using is :

    SELECT 'dbr.hdr', 'Products';
    select 'dbr.summary.text','Products','Total';
    select 'dbr.crosstab', 'Date';
    SELECT products as Products,week as Date ,mon as Status,sum(open) as Open,sum(close)as Close FROM fruits_tmp
    where orgs=orgss
    group by orgs,products,mon,week
    order by week ;

    Pls help urgently.

    Thanks.

  2. myDBR Team, Key Master

    You can use 'dbr.crosstab.col'-commnd to define the columns and the order used if you wish to display also crosstab columns other than your data provides.

    --
    myDBR Team


Reply

You must log in to post.