Repeating multiple times

building reports crystal reports
1

Hi All,
I had created a report and it has two drill down in Crystal report.
I had added two Groups on my report.
One Group by Country and another is Group by State
Country text heading is in GH1a and it’s value is in GH1b and Details. I am getting Country heading Text on GH1a is repeating for each country value. What I need to do here so that Header (all text on GH1a) can display only one time? I had disable suppress when duplicate option too. But it is not working. Any idea?

Philip (BOB member since 2006-03-02)

2

Hi Philip,

Please follow these steps:

  1. Create a formula named “test”.
  2. Write the following code:
    “Country”
  3. Place the formula in GH1a.
  4. Select the formula and right click>>Format Field.
  5. Click Common tab.
  6. Click the X^2 button opposite to Suppress.
  7. Write the following code:
    {@test}=next({@test}) and not OnFirstRecord
  8. Click Save & Close button.
  9. Click OK.
  10. Preview the report

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)

3

Hi Manish,
I tried. It is working, text is not repating now it is displaying only one row now. But group header (GH1a) is repeating. I do not want group header is repeating. any suggestions?

Philip (BOB member since 2006-03-02)

4

Hi,

Can you send me a screen shot showing the issue?

Regards
Manish

cr_manish :india: (BOB member since 2009-07-30)