Only One ID per Report

[Yustrn]

Hello,

I'm using crystal version 7.0 and I'm taking an existing report that pulls one row of data for each transaction that the person does. I just need address info ect, not transaction info. So I'm trying to fiqure out a way to tell that to Crystal Reports.

I have a column for ID, so maybe there is away to tell it that if the ID is a duplicate then surpress that line? Please help! Either respond here or you can get me on Yahoo IM at User ID of YUSTRN thanks

 

[IdoMillet]

One option is to Group by ID, suppress the Detail section, and place the fields you want to see in the Group footer.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Yustrn]

I have one field that is YTD tax paid, so I don't want it to group that and duplicate those values, which is what I'm afraid group would do.

 

[IdoMillet]

Need some clarifications.

Are you summing that field? If not, there's no issue.

If you do, creat a "Running Total" and set the Evaluation option (in the Running Total dialog) to accumulate the value of that field only once per each ID group.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Yustrn]

It's giving me one line per each transaction that they have completed. So I'm getting something like

Black, William, 123your street, Your town, Ca, Fica Tax,$25
Black, William, 123your street, Your town, Ca, Fica Tax,$25
Black, William, 123your street, Your town, Ca, Fica Tax,$25

as an example, I also have a field for ID, so I want to tell it if I have duplicates of the same ID then to surpress the whole line. I am a basic Crystal User, so please explain as if I'm your boss. =)

thanks

 

[Yustrn]

Here is what I used, and I'm still getting duplicates

Previous ({ROTPersonnelStatus.ID})={ROTPersonnelStatus.ID}

everything is on the details line, I right clicked went into "Surpress (no drill down) X2 box and typed that in, saved it, ran my report and I still get it. Did I do something wrong?

 

[Yustrn]

Still can't get it to work, any other suggestions?

 

[IdoMillet]

Just to clarify, you entered the above formula in the detail section Suppress attribute and you are still seeing duplicates?

Are the records sorted by {ROTPersonnelStatus.ID}?

Did you try my original suggestion?

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Yustrn]

O.K,

I got a new problem and I realize that I should have explained this sooner, but didn't relize it till I got the other part to work just now.

I have been playing with it some more and got the PreviousID=ID to work, but once I run this report through my database and get the info I need, I then have to export it out as a CHR file into Excel, from there it cuts off all my formatting and I'm back to square one with everyone showing multiple times.