Hi there, I'm trying to create a subreport and I'm not getting the right data.
I have a table with the following fields:
date, numberA, $amount
I need to show the sum of numberA and the sum of $amount per quarter for the last 4 quarters, so I would end up with four lines. I tried creating a beginDate and endDate for each quarter, but I don't know how to tell my formula to only get the records in between those dates. I can do the SQL statement for it, but I don't know how to translate that to Crystal.
The output should look like this:
Jan-Mar 2005 10 1000
Oct-Dec 2004 25 6100
Jul-Sep 2004 3 550
Apr-Jun 2004 74 8900
Thanks for your help!
mm
I have a table with the following fields:
date, numberA, $amount
I need to show the sum of numberA and the sum of $amount per quarter for the last 4 quarters, so I would end up with four lines. I tried creating a beginDate and endDate for each quarter, but I don't know how to tell my formula to only get the records in between those dates. I can do the SQL statement for it, but I don't know how to translate that to Crystal.
The output should look like this:
Jan-Mar 2005 10 1000
Oct-Dec 2004 25 6100
Jul-Sep 2004 3 550
Apr-Jun 2004 74 8900
Thanks for your help!
mm