<div>
mlmcc has a possible solution:<br />
<a href="https://www.experts-exchange.com/questions/28983961/Crystal-11-Suppress-main-report-section-if-subreport-is-blank.html" rel="ugc">https://www.experts-exchange.com/questions/28983961/Crystal-11-Suppress-main-report-section-if-subreport-is-blank.html</a><br />
With a couple of tweaks this could work.<br />
<br />
Another possible solution is to build an SQL query using the With statement. &nbsp;Then you wouldn't need the sub reports at all. &nbsp;And can do an equal join to eliminate customers with no data in the 2 year record set.<br />
<br />
I believe there is both a SQL Server with statement and an Oracle. &nbsp;I'm familiar with the Oracle statement. &nbsp;If it's designed well data can be returned in under a couple minutes.
</div>


<div>
This probably isn't your first choice, but the best solution would probably be creating a custom db query that gathered the information for the report. &nbsp;The query could select the customers that had orders in the desired time period (2 years ago, or 2 years ago and the years since then), and calculate the month, 3 month, and YTD totals for this year and last year. &nbsp;Then the report would only have to output that data.<br />
<br />
&nbsp;I'm not sure how to change your current report. &nbsp;In a simpler report, you could use group selection, which actually suppresses/hides the groups that you don't want to see. &nbsp;For example, if you simply had an order total field and an order date field, you could create a formula similar to the following that would only include the orders that were over 2 years before the parameter date:<br />
<br />
if {Order Date field} &lt;&nbsp;DateAdd (&quot;yyyy&quot;, -2, {?par_Run_Date}) then<br />
&nbsp; {Order Total field}<br />
<br />
&nbsp;Then the group selection formula would be:<br />
<br />
Sum ({@formula created above}, {Customer group field}) &gt;&nbsp;0<br />
<br />
&nbsp;That would select the groups (customers) that had orders that were more than 2 years before the parameter date. &nbsp;Any customers that did not have orders prior to 2 years ago would not be shown. &nbsp;FYI, the report would still be reading customers that did not have orders that old. &nbsp;It just wouldn't be showing them. &nbsp;So any report totals using CR summary functions would include those other customers. &nbsp;If you needed totals, you'd have to use formulas to calculate those yourself.<br />
<br />
&nbsp;That's the basic idea, but I'm not sure exactly what you're doing in the main and subreports, so I don't know if you can use something like that. &nbsp;I suspect not, but I'm really not sure.<br />
<br />
&nbsp;If you can't do that, there may be something of a &quot;brute force&quot; alternative. &nbsp;You could create a new subreport and put it in the report header of the main report. &nbsp;The new subreport would just look for customers that had orders over 2 years old (ignoring anything newer), and save those customer numbers in a shared variable array. &nbsp;Then the main and subreports could, theoretically, check that array and suppress sections if a customer was not in there. &nbsp;I _think_ that would work. &nbsp;I called it &quot;brute force&quot; because it requires a new subreport (which means reading the orders yet again), and adding suppression formulas to all of the appropriate sections in the main and original subreports.<br />
<br />
&nbsp;One basic limitation to that approach is that arrays are limited to 1000 elements in CR, so if a single report could include more than 1000 customers with orders that are over 2 years old, that would be a problem. &nbsp;If necessary, you could handle that by using multiple arrays.<br />
<br />
&nbsp;James
</div>


<div>
James.<br />
Regarding arrays limitation of 1000 elements in CR I have 50 Customers and 40 suppliers, so that limitation will not be problem.<br />
In main report I have shared variable that collects those customers from pull of 50 which have orders with suppliers than 2 years from selected parameter date.<br />
When I check detail line of main report I am getting only Customers and that have orders older than 2 Years from parameter date.<br />
&nbsp;Then I am passing this shared variable value to rpt_SubMainA &nbsp;and parameter date, in that sub report &nbsp;I am grouping by customer then by supplier and &nbsp;I have new condition that &nbsp;I select only those customers that have orders from suppliers in range of past YTD to Current YTD.<br />
<br />
However I do not need customers - suppliers which do not have orders &nbsp;In Past YTD range to show not to calculate even if that particular customer - supplier &nbsp;have order in Current YTD.<br />
All issue is around haw to restrict this particular Customer - supplier combination not to show or calculate in past YTD.
</div>


<div>
Just to see if I understand the situation:<br />
<br />
&nbsp;Are you using the record selection in the main report to find the customers with orders over 2 years old, and then running the subreport(s) for each of those customers? &nbsp;But then you only want to actually see one of those customers if they also had orders more recently?<br />
<br />
&nbsp;If so, then maybe you can use group selection, although I'm not sure what you mean by &quot;in range of past YTD to Current YTD&quot; (I wouldn't normally think of two YTD values as a range). &nbsp;Do you mean this year, or last year, or both?<br />
<br />
&nbsp;IAC, you could potentially use formulas like the ones that I posted before, to see if a customer had any orders in the desired secondary date range (eg. last year), and then select those customers (groups), hiding/suppressing the rest.<br />
<br />
&nbsp;James
</div>


Taras

<div>
James.<br />
<br />
Hi James I have 6 columns, am doing comparison between:<br />
Three columns values for this year and columns values for past Year.<br />
<br />
Column 1. This year Month – parameter date full month. <br />
Column 3.This Year rolling three months back from current date- current month. <br />
Column 5. And this year YTD - included parameter month.<br />
Compering those amounts with:<br />
Column 2. Last year month (the same as current month)<br />
Column 4. &nbsp;Last year rolling three months <br />
Column 6. Last year YTD.<br />
I assume it is your two YTD values range.
</div>


<div>
Current Month &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rolling Current 3 Months &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rolling Current YTD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Past Year Month &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Past Year Rolling 3 months &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Past Year YTD <br />
Customer A: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Supplier1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$10.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$65.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$380.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$25.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$120.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$490.00 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Supplier2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$10.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $235.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Supplier3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$10.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$65.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$120.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$45.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$270.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$850.00 <br />
Customer A: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total:$30.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$175.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $735.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$70.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$390.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$1,340.00 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Customer B: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Supplier 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$120.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$350.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$805.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$90.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$330.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$1,250.00 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Supplier 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$40.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$350.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$1,100.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$45.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$450.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$1,350.00 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Supplier 5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$15.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$45.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$205.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 <br />
Customer B: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total:$175.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$745.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2,110.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$135.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$780.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$2,600.00 <br />
<br />
Final Total:....<br />
Problem here is Customer A - Supplier 2 and Customer B Supplier 5 they should not be include(not seen) &nbsp;and not summarized in Current Year data.
</div>


<div>
I mixed order of columns a bit &nbsp;but I hope that this will give an &nbsp;idea what I want to achieve.
</div>


<div>
mlmcc, you said:<br />
&quot;You could add a subreport that uses that list and checks who had orders last year&quot;<br />
<br />
<br />
If I put selection criteria in report records : &nbsp;that customers are included in list &quot;Customer with order older than 2 years&quot; and add additional criteria that I want to select only order that are in past ytd range how I will get orders from the same customers that are in this current ytd range to compare them in this sub report?
</div>


<div>
<blockquote>
Then I am passing this shared variable value to rpt_SubMainA &nbsp;and parameter date, in that sub report &nbsp;I am grouping by customer then by supplier and &nbsp;I have new condition that &nbsp;I select only those customers that have orders from suppliers in range of past YTD to Current YTD.
</blockquote>
 What do you mean by &quot;and &nbsp;I have new condition that &nbsp;I select only those customers that have orders from suppliers in range of past YTD to Current YTD&quot;?<br />
<br />
&nbsp;I got the impression that the new condition was a second date criterion. &nbsp;Something along the lines of: You want to see the customers with orders before 2 years ago, but (this is the new condition) only if they also had orders last year. &nbsp;But I'm not sure what to make of &quot;in range of past YTD to Current YTD&quot;.<br />
<br />
&nbsp;You've mentioned comparing some columns (eg. this month this year and last year). &nbsp;I assumed that you were just showing those figures on the report, so that people could look at the columns and compare them. &nbsp;But after one of your latest posts, I'm wondering if maybe you're actually trying to use those columns to somehow control which customers are on the report (eg. only show a customer if this year &gt;&nbsp;last year (ie. the YTD orders increased)).<br />
<br />
&nbsp;James
</div>


<div>
James; <br />
This condition <br />
What do you mean by &quot;and &nbsp;I have new condition that &nbsp;I select only those customers that have orders from suppliers in range of past YTD to Current YTD&quot;?<br />
<br />
Is present as you need to do comparison between this and last year records.<br />
How you will do comparison if you do not restrict - provide pull of orders that are seating in this time range?<br />
<br />
Next condition is new one that client asked me: He said I do not want to see in Customers group those suppliers that do not have order in previous year that have amounts of $0.00.<br />
I can suppress easily them but how to do with amounts that are still calculated for current year even those suppliers group are suppressed.
</div>


<div>
So not only does the customer have to have orders but the customer/supplier pair has to have orders.<br />
<br />
LEt me try to build a sample report<br />
<br />
mlmcc
</div>


<div>
James I do not to put this conditions on report level I can put them in formulas for calculating particular amounts .
</div>


<div>
yes mlmcc, &nbsp;that actually a point in all this new requirements .
</div>


<div>
<blockquote>
Is present as you need to do comparison between this and last year records.<br />
How you will do comparison if you do not restrict - provide pull of orders that are seating in this time range?
</blockquote>
 I think maybe the use of &quot;range&quot; (singular) was confusing me. &nbsp;You seemed to be saying that you wanted a single range from &quot;past YTD&quot; to &quot;Current YTD&quot;, and I didn't understand what that meant. &nbsp;But now I think that you're talking about 2 ranges, one for this year and one for last year (eg. 01/01/2018 to 09/26/2018, and 01/01/2017 to 09/26/2017).<br />
<br />
&nbsp;It sounds like mlmcc has a better handle on what you want than I do, so I'll wait and see what he can come up with.<br />
<br />
&nbsp;James
</div>


<div>
Thank you mlmcc and James, I created Main report as mlmcc suggested (just container) and two sub reports based on &nbsp;command, I did all filtering in command based on passed parameters from main report. I am not done as &nbsp;I have issue with passing multi valued number parameter to command in CR 2008 I will &nbsp;post it as next question.<br />
Thank you a lot.
</div>


<div>
As far as I know you can't pass a multivalue parameter to a command<br />
<br />
mlmcc
</div>


<div>
mlmcc,<br />
<br />
&nbsp;FWIW (and it may not be much :-) ...<br />
<br />
&nbsp;You may very well be right. &nbsp;I thought I'd seen someone post here on ExEx that it worked (at least in their specific case), with CR replacing the parameter in the Command with a comma-separated list of values. &nbsp;I also have the feeling that that was something that was added in later versions of CR. &nbsp;But I could be wrong about all of that.<br />
<br />
&nbsp;James
</div>


<div>
I'll check CR2008 in the morning. &nbsp;All I have installed here is CR XI R2
</div>


<div>
<div class="content wysiwyg-content">
In Crystal Report 2008 .<br />
I am working on one my old report that calculating rolling amounts from customer that have orders from different suppliers. <br />
Columns that I need to compare are: Month, Three Months and Year (6 columns) <br />
- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Full selected month this year to the same month previous year;<br />
- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Three months back from selected month this year to the same three months in previous year<br />
- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Current YTD up to full selected month to previous year to date.<br />
Condition is that only Customers should be included that have orders from suppliers which are older than two years from selected date.<br />
One customer can have several suppliers and one supplier can have several customers.<br />
It means those customers have to have order older that two years from parameter date but they can have beside those &nbsp;at the same time orders that are not older that two years too.<br />
I need grouping on Suppliers and then their Customers and calculating those values for each customer with total for supplier.<br />
<br />
Customer which do not have any orders (amounts) in previous year column should not be included in calculation and should not be shown in report.<br />
I have problem how to restrict and not showing customers which do not have orders in previous year(even they could have in this year).<br />
<br />
I created one Main report and two subreports (rpt_Main; rpt_SubMainA; rpt_SubMainB).<br />
In rpt_SubMainA I presented every Supplier with their customer and do those calculation in columns.<br />
In rpt_SumMainB I show only final summaries rows from sub reports rpt_SubMainA.<br />
<br />
In rpt_Main I have shared variable “OldCusomers” where I collected all &nbsp;customers that have orders older than two years from parameter(par_Run_Date) which I use as date for calculation.<br />
Then I passed that shared variable value to be used as criteria in &nbsp;rpt_SubMainA &nbsp;plus added condition that orders in this sub report have to be in range previous YTD and Current YTD. <br />
<br />
In subreport rep_SubMainA &nbsp;I have grouping on Suppliers then Customers.<br />
<br />
<br />
&nbsp;Everything looks ok up to user asked me not to show those Customers that do not have any orders during previous year (even they could have orders during this year but if they do not have in previous year they should not be include and calculated.<br />
Not sure how to solve this any idea?
</div>
</div>


In Crystal Report 2008 .
I am working on one my old report that calculating rolling amounts from customer that have orders from different suppliers. 
Columns that I need to compare are: Month, Three Months and Year (6 columns) 
-	Full selected month this year to the same month previous year;
-	 Three months back from selected month this year to the same three months in previous year
-	Current YTD up to full selected month to previous year to date.
Condition is that only Customers should be included that have orders from suppliers which are older than two years from selected date.
One customer can have several suppliers and one supplier can have several customers.
It means those customers have to have order older that two years from parameter date but they can have beside those  at the same time orders that are not older that two years too.
I need grouping on Suppliers and then their Customers and calculating those values for each customer with total for supplier.

Customer which do not have any orders (amounts) in previous year column should not be included in calculation and should not be shown in report.
I have problem how to restrict and not showing customers which do not have orders in previous year(even they could have in this year).

I created one Main report and two subreports (rpt_Main; rpt_SubMainA; rpt_SubMainB).
In rpt_SubMainA I presented every Supplier with their customer and do those calculation in columns.
In rpt_SumMainB I show only final summaries rows from sub reports rpt_SubMainA.

In rpt_Main I have shared variable “OldCusomers” where I collected all  customers that have orders older than two years from parameter(par_Run_Date) which I use as date for calculation.
Then I passed that shared variable value to be used as criteria in  rpt_SubMainA  plus added condition that orders in this sub report have to be in range previous YTD and Current YTD. 

In subreport rep_SubMainA  I have grouping on Suppliers then Customers.


 Everything looks ok up to user asked me not to show those Customers that do not have any orders during previous year (even they could have orders during this year but if they do not have in previous year they should not be include and calculated.
Not sure how to solve this any idea?

Crystal Report Rolling month- three months -YTD with previous year comparison

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.