Joined: 24 Jan 2011
Location: United States
Online Status: Offline
Posts: 3
Topic: Require duplicate records Posted: 24 Jan 2011 at 9:48am
Hi i want report for month of december 2010 and for the year 2010 also. i write a query in formula which i use in cross tab saying if month= 12 and year=2010 then "Dec 2010" else "2010"
since the records in dec month satisfy 1st condition they dont appear in whole year 2010 report..
Joined: 24 Jan 2011
Location: United States
Online Status: Offline
Posts: 3
Posted: 25 Jan 2011 at 1:20pm
its in report header...wot i want is i have data in the dates jan 1 2010 to dec 31st 2010...now m using cross tab and want a column for month of dec 2010 and the other column for the entire year...but when i use if in dec 2010 then ... else ... so what happens is i get 2 columns 1 for dec and in other column i get entire year but excluding month of dec...i want to include dec month also...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
