Crystal Report – two detail sections each showing their own subset of data

crystal-reports

Is it possible to have a Crystal Report with two detail sections with each showing a subset of the results returned from the SP that the report is linked to?

For example in DetailA I want the records where FieldA in (a,b,c) and in DetailB I want records where FieldA in (d,e,f)

I know there is the Select Expert that can be used but that seems to work across the whole report rather than each individual detail section

It would be nice if I didn't need to create formulas as there are about 20 fields in the detail sections. Is there some kind of master formula that can be applied to the detail section as a whole?

Best Answer

You can do this pretty simply by just setting up your two Details sections the way that you want and placing all of the records' fields you want to display in each. Then, add a suppression formula to each of the Details sections. You can access the suppression formulas of each section by right-clicking that section, choosing 'Section Expert', and then clicking the formula button next to 'Suppress (No Drill-Down)'

Detail Section A: not({table.fieldA} in ['a','b','c'])

Detail Section B: not({table.fieldA} in ['d','e','f'])

Now, your Details A section will only display when the record is of type a, b, or c and your Details B section will only display when the record is of type d, e, or f.

Related Solutions

R – Flatten data inside a crystal report

Ok, someone here in the office showed me the way, so I'll put this out there.

Given data with cols A,B,C all common and D,E different across multiple rows, this is how I 'flattened' the dataset in crystal:

Create a group based on col A, and put A,B,C inside that group header - get rid of the details section entirely
Create a subreport in the group header for each row of data, in my case 2 subreports
Inside each subreport, put fields D,E. Important: There are NO links for these subreports!
For each subreport go into the Select Expert and create a condition that shows only 1 particular row of data. This conditional will have the same field for each subreport, but different values. In my case it was AddressType='A', and AddressType='B'

This will produce 1 report, with A,B,C listed once, and D,E listed once for each subreport(once for each row of data)

This was confusing, time consuming, and I hate crystal reports now more than ever.

How to set MAXIMUM number of record in DETAIL SECTION in crystal report

This is possible to do but it is a bit of hack. I'm pretty sure there is nothing built in to Crystal that will do this for you.

First you need to add a new formula field to your report in the Detail Section, with the following formula:

(RecordNumber Mod 6)

I have called this formula mod_record.

You then need to add 5 new sections below your main Detail section. Add a single line to each of the new sections you have just added.

In the first detail section (Details b) go to Section Expert and click the formula button next to Suppress (No Drill-Down). In the formula you need to put the following:

If OnLastRecord = true Then
  If {@Mod_Record} <= 1 Then 
      false 
  Else 
      true
Else
  true

The formula is the same for each detail section apart from one change. You need to replace the <= 1 with the following for each section:

Details c should be <=3
Details d should be <=4
Details e should be <=5
Details f should be <=6

This will give the impression that the details section is a fixed width of 6 lines.

Hope this helps.

Best Answer

Related Solutions

R – Flatten data inside a crystal report

How to set MAXIMUM number of record in DETAIL SECTION in crystal report

Related Topic