Hi,

I have a main report with subreports and need to suppress some of the data in the main report.

The main report is setup as follows.
RH = text
PH = text
GH1 = field labels and subreports with shared variables
Da = field data
Db = field data
GF1 = text, summary data, formula's based on shared variables
RF = suppressed
PF = page footer stuff

I've read a lot of google material and in forums but still can't get this to work. I've had to redesign some reports a few times because element placement was wrong.

So the report design above does what it's supposed to do. I've used the section expert and created in the 'Suppress (No Drill-Down)' formula something like @formula 1 + @formula 2 >= @formula 3

This report prints about 20 pages but I only want to see the important information which is about 2-3 pages. Essentially removing all groups meeting the suppress formula.

I've placed the above suppress formula in the group header, footer, detail header and detail lines and a combination thereof but I'm having mixed results. No matter how I try it doesn't give me the results I'm expecting.

I hope I've worded this correct and hope it's just something simple that I've overlooked.

Thanks,
Steve.

Thanks for the reply.

I tested this as you've suggested and it does what is expected.
The values being passed from the subreport shared variables appear correctly in all of the detail lines so I can safely say they are working.

The formula is testing if the shared variables' total is greater than or equal to a Sum in the footer area. When applying this to suppress the Detail sections and Group Footer section, they suppress as expected. However if I apply this to the Group Header, that's where the problem is. I know it won't do what I want because as you've mentioned, the information is passed in a downward direction.

If I do what I've written here and leave the Header alone, the report isn't as long but it prints a lot of Group Header information which I'd like to hide.



Edited by SteveDLC - 26 Apr 2016 at 7:51pm

I think I'm missing something here.

I'm not sure what you mean by Group Sum.

I've achieved a 'Sum of field data' in the Group Footer using 'Insert Summary'.

I moved the 'Sum of field data' in the Group Footer to the Group Header and it shows the correct value.

However whenever I do some kind of calculation using a formula the result changes.

The result is grabbing the values from the shared variables from the previous Group.

Sorry if this is confusing. I'm trying to explain it clearly.

Based on the layout in my first post.....

GH contains a product code plus subreports. Two of the subreports collect values which are quantity available plus quantity on purchase order.
Details a+b simply show field data for customers and what stock is outstanding (no formula's or subreports).
GF has the summary value of how many are outstanding, plus the formulas for the shared variables.
The calculation I want to use to suppress the group is when the quantity available plus the quantity on purchase order is greater than how many I have on back order for customers. I only want to see on the report when the total of customer order quantities exceeds how many I have in stock + on purchase order.

Hope this helps.

Please forgive me as I think perhaps I have the subreports setup incorrectly.

The subreport is setup with a shared variable declaration as follows:-
Shared NumberVar abc := {field.name};
abc

This is then placed into the detail line of the subreport with all other sections in the subreport suppressed.

The subreport is then placed in the GH1 of the main report.


Edited by SteveDLC - 29 Apr 2016 at 6:13pm