how to check if duplicate or not

[santosh1]

Issue 1
---------

Also, I have a a/c No. field for each line item in the detail section.
For example:

T Shirt
a/c: 6587-36580-9873-0000-0000

Poster
a/c: 6587-36580-9873-0000-0000

Brochure
a/c: 6587-36580-9873-0000-0000

Pens
a/c: 6587-36580-9873-0000-0000

If the a/c number is the same for all the items, then I want to display it at the top in the
page header section and suppress a/c in the detail section. If a/c number is not the same for
all line items, then display at the detail section and suppress the a/c number in the page header.
To do this, how can I check the a/c no. if it is a duplicate or not for all line items? Thanks a lot.

Issue 2
---------
I am using Crystal ver. 8.5.
I have page footer section a & b.
The sub-report has to repeat on every page, so it's on page footer section.


The sub-report displays Purchase Order comments line by line. I checked the sub-report grow property
since the sub-report can have many comments as below.

eg. All PO should have item number
All PO should have quantities
PO should have amount
...
...

I thought the page footer section would auto expand to accomodate as many comments if the comments
list (sub-report) continue to grow, but it doesn't. Currently I just see line 1:

All PO should have item number


When I increase the height of the page footer section, then it displays all comments.


All PO should have item number
All PO should have quantities
PO should have amount
...
...

Is there a way to make the page footer section grow as well? And how can I concatenate these lines
if there's space available in the previous line?

 

[Madawc]

Issue 1
---------
You can do summary counts (right-click on a field, [Insert] and [Summary]. Group by account number and also count something for each detail line. Have a suppressable field for account number in the group header and also the detail line. Suppress the header account when the count is one and the detail when it is more than one. You can also suppress the whole section, if that suits you.

Issue 2
---------
Seems an odd way of writing a report. Why not a detail section with the 'print at the bottom of the page' option (obtained by right-click and Format Section).

Madawc Williams
East Anglia, Great Britain