Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

need help on creating a custom report

I am using the embedded version of Crystal Reports for VS 2005 .NET Pro. I have created a report that displays data over the entire year. It looks like this:

                                                 Year Over Year Store Summary Report                                          Page: nnn
                                                                Date()
 
Store          Jan      Feb      Mar      Apr      May      Jun      Jul      Aug      Sep      Oct      Nov      Dec      Total
 Store  1 Name
      Year 1   xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
      Year 2   xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
              ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______
    Change     xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
 
 
 Store  2 Name
      Year 1   xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
      Year 2   xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
              ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______
    Change     xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
 .  
 .
 
  Store  n Name 
       Year 1   xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
       Year 2   xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x
               ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______   ______
     Change     xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x    xxx.x

I have been able to create the report and display the totals for each year and month. What I am not sure how to do is subtract each monthly total and display it in the "Change" line. I have created this report using the crosstab wizard and one that I created from scratch. So, can anyone help me find a way to subtract each monthly total from each year and display it on the "Change" line (or difference if you will).

Example

Year Jan Feb ... Dec

2009 123 400 567

2008 43 230 321

-


Change 80 170 246 <--- How do I create this line in the report?

Thanks!

Ed Cohen

Former Member
Former Member replied

No, that would make 3 threads here on the same question. We'll deal.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question