Hi,
This is an accounting report being created in Crystal 8.5.
The user enters the date range (begin and end date within the same year - I then use only the month and year parts for my report)
This is the format of the report
Grouping Fields:
Currency Id
Item Class
Customer Class
Details:
Customer No.,Customer Name,
Curr.Yr. Date Range Sales, Prev.Yr. Same Date Range Sales, Curr. Year To Date Sales, Prev. Year To Date Sales,
Sum(MonthlyValue)
I started a cross-tab, it worked fine for the curr. yr date range sales and prev. yr. same date range sales because I could set the report criteria based on the same begin and end month and use the report year for the cross-tab column. If the begin month is Feb - 2 and the end month is Jun - 6, it would look something like:
Cust No. Cust Name 2001 2002
AFIT0001 Aaron Fitz Electrical $ 519.25 $419.40
But how do I add a year-to-date sum if I have to retain the same cust no. and cust name displayed and all grouping details but use a diff. month range (in this example, Jan - 1 to Jun - 6). It is like plugging a bunch of unrelated values in an Excel spreadsheet and copying them over. I can have only one set of report criteria. Can this be done at all?
Eventually, it should look like:
Cust No. Cust Name 2001 2002
AFIT0001 Aaron Fitz Electrical $ 519.25 $419.40
2001 YTD Sales 2002 YTD Sales
$599.25 $468.90
and this should all be in one line. As you can see, this is a report to look at trends.
I appreciate any input on this. I have examined using a stored procedure with Crystal 8.5 but a stored procedure still returns a rowset with only one set of criteria, here, with multiple date ranges, I have 2 sets of criteria with only the end month common. I couldn't figure out how to get subreports to work either. Please help.
Chad Sriram
This is an accounting report being created in Crystal 8.5.
The user enters the date range (begin and end date within the same year - I then use only the month and year parts for my report)
This is the format of the report
Grouping Fields:
Currency Id
Item Class
Customer Class
Details:
Customer No.,Customer Name,
Curr.Yr. Date Range Sales, Prev.Yr. Same Date Range Sales, Curr. Year To Date Sales, Prev. Year To Date Sales,
Sum(MonthlyValue)
I started a cross-tab, it worked fine for the curr. yr date range sales and prev. yr. same date range sales because I could set the report criteria based on the same begin and end month and use the report year for the cross-tab column. If the begin month is Feb - 2 and the end month is Jun - 6, it would look something like:
Cust No. Cust Name 2001 2002
AFIT0001 Aaron Fitz Electrical $ 519.25 $419.40
But how do I add a year-to-date sum if I have to retain the same cust no. and cust name displayed and all grouping details but use a diff. month range (in this example, Jan - 1 to Jun - 6). It is like plugging a bunch of unrelated values in an Excel spreadsheet and copying them over. I can have only one set of report criteria. Can this be done at all?
Eventually, it should look like:
Cust No. Cust Name 2001 2002
AFIT0001 Aaron Fitz Electrical $ 519.25 $419.40
2001 YTD Sales 2002 YTD Sales
$599.25 $468.90
and this should all be in one line. As you can see, this is a report to look at trends.
I appreciate any input on this. I have examined using a stored procedure with Crystal 8.5 but a stored procedure still returns a rowset with only one set of criteria, here, with multiple date ranges, I have 2 sets of criteria with only the end month common. I couldn't figure out how to get subreports to work either. Please help.
Chad Sriram