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.