• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2293
  • Last Modified:

Supress Duplicate Sub-Reports in Crystal Reports 2008

Is it possible to suppress a sub-report if it itself is duplicated, I know you can do this with the individual line items for the reports. But I am unsure if this can be applied to the entire sub-report.

My sub-report is linked to two fields on my main report
1: Part Number
2: QuoteItemID

the yellow box is my actual sub-report and the red are the sections that I do not want to display if the data from the main reports is the same (i.e.: Part Number)
duplicateQuoteItems.png
0
Wytech_Wire
Asked:
Wytech_Wire
  • 4
  • 3
1 Solution
 
mlmccCommented:
What section is the subreport in?

Is the main report reporting on data or using information from the subreport.

mlmcc
0
 
Wytech_WireAuthor Commented:
The sub-report is in the Details section, what I am attempting here is to show the quantities with their respective part number. If the part number is the same I am suppressing all duplications, which is why I don't want the sub-report to display multiple times.
0
 
mlmccCommented:
How are you suppressing the duplicates?
Are you suppressing the fields or the section?

mlmcc
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Wytech_WireAuthor Commented:
I am suppressing the Fields, I am also suppressing Blank Sections as well. But since the sub-report is duplicating that criteria is not being met.
0
 
mlmccCommented:
You should be able to suppress the subreport or the section based on the same criteria you are using for the fields.

mlmcc
0
 
Wytech_WireAuthor Commented:
That is my problem, I do not see an option anywhere on the sub-report to suppress if duplicate. Also, as you can see in my image the suppress blank sections is not working due to the fact that the sub-report contains data for those sections that I am attempting to hide.
0
 
mlmccCommented:
You can't suppress if duplicate for a subreport.  However on the first tab you can suppress based on a formula which would be something like

{Field} = Previous({Field})

mlmcc
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now