Help - suppressing details section

[abc567]

Hi,
I am designing a report which has 'account number', 'branch', etc...
I want to design it as

ACC Br

101 A
101 B
-----------------
102 A
-----------------
103 C
103 B
------------------

i.e., line should appear if the records are different so i created 2 details section det a and det b. And inserted line in det b section. And in section expert on suppress formula i wrote
{table.ACCOUNTNUMBER}=Next({table.AccountNumber})

But the problem here with this formula is it is appearing for few records only like

Acc Br

101
101
--------
102
103
103
--------


Please reply me with conditionally suppressing of detail section solution..

 

[lbass]

Insert a group on account, and place the line in the group footer. Suppress the group header.

-LB

 

[CoSpringsGuy]

have you considered grouping by account number and add a line in the group footer?

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CoSpringsGuy]

whups ... sorry LB

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[abc567]

Thanks
i did exactly as you said but when same account number (102) spread over multiple pages then lines are getting displayed as

101
101
---------------
102

(As this is page ending it should display a line so i inserted line in page header but this is not working either as this line is creating blank rows at the end of the page like
----------
----------
)

And on Next page

102
-------------------


so i checked "keep group together" but data is getting spread on multiple pages with the formatting i need but i want to display this data on same page with appropriate lines..


Thanks

 

[CoSpringsGuy]

i see your pain.... I just duplicated your issue and here was my solution

keep your groups but hide bothe header and footer.

insert another detail section ... add your line in b
create a running total that that counts account number and resets on change of group
add this formula to suppress b
//
{#RTotal0} <> Count ({AcctNUM}, {AcctNUM})

in section expert select details, not a or b but the main section and check keep section together

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Instead of "keep group together" (remove that), you could try using keep together on the higher order group footer (not a or b). Same premise as CoSpringsGuy. I didn't test this, but it seems that it should work, too.

-LB

 

[abc567]

Thank you very much bro...
Appreciate your help ..

Thanks CospringsGuy and lbass..