[RBASE-L] - RE: Group By Problems

[Dan Goldberg]

You might try to create a (temp) table to store the values of the months.
You could fill it in based on the users parameters.
        
 
Sample Table(I use Repmonth to sort the months properly)
 
RepMonthName(Text)     RepMonth(Integer)  RepYear(Integer)
------------------     -----------------  ----------------
January                    1               2008
February                   2               2008
...
...
 
Then create the report based on the above table. Use RepYear and RepMonth
for breaks.
 
Then create a variable for each sum and place it on the break footer of
RepMonth. You can add RepMonthName to label the month as well.
 
Sample Variable
 
F1:    vSumDuesBill = (sum(InvAmt)) in tablename where (imon(InvDate)) =
RepMonth and (iyr(InvDate)) = RepYear
F1:    vSumDuesPaid = (sum(PAamt)) in tablename where (imon(PayDate)) =
RepMonth and (iyr(PayDate)) = RepYear
...
...
 
This might not be the best way but it works. 
 
Dan Goldberg
 


  _____  

From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Jan Barley
Sent: Thursday, October 09, 2008 10:44 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Group By Problems


Buddy,
Its actually more complicatd than that.  I am trying to generate a report to
show whats been billed, paid, and canceled by month.  My problem is the
billing amount uses one date (InvDate) and the paid and canceled uses
another (PayDate).  I want those figures to all go under the same month.  I
have set up 3 different views - DuesBill, DuesPaid, and DuesLost.  
DuesBill is (tmon(InvDate)) and (sum(InvAmt))
DuesPaid is (tmon(PayDate)) and (sum(PAamt))
DuesLost is (tmon(PayDate)) and (sum(InvAmt))
 
what I am trying to do is combine all three views into one so I can look at
these figures by month.  The new view would consist of:
 
 DuesMonth,BillAmt,PaidAmt,LostAmt
 
every time I try to combine these views I keep getting the illegal column
specification!
 
Any thoughts are appreciated!!!
 
Jan