Any Crystal Reports Wizards Here?
-
So you need to show two records, if the second record matches a particular field in the first record correct?
Why not create a sub-report that will list all records that match anything in the first record?
-
@DustinB3403 said in Any Crystal Reports Wizards Here?:
So you need to show two records, if the second record matches a particular field in the first record correct?
Why not create a sub-report that will list all records that match anything in the first record?
Because this is already a sub-report.
The desired output is to show the newest record. If the second newest record has the same "name" as the newest record, I need to display both (as this is a flag for the users of said report that they need to fix something in the system).
-
I THINK I KNOW WHATS HAPPENING!
The first record is getting suppressed because it doesn't have a "previous" record to match to!
So I just need to implement logic to say "if this is record 1 don't do anything".
-
Without seeing the report / database it's difficult.
But I understand a bit better.
What is your filtering parameter setup for?
-
BOOM. Adding not(OnFirstRecord) to my logic makes it work beautifully.
-
Glad you got it sorted, wasn't to bad was it?
-
This post is deleted! -
@aaron said in Any Crystal Reports Wizards Here?:
I'm not a wizard, but have used it before and you have my sympathy for even touching it.
I don't think Crystal is that bad at all really.
It's just a matter of correlating the database records and aligning them to the tables that you need the data on. Everything else is often as simple as just doing the math.
-
This post is deleted! -
@DustinB3403 said in Any Crystal Reports Wizards Here?:
@aaron said in Any Crystal Reports Wizards Here?:
I'm not a wizard, but have used it before and you have my sympathy for even touching it.
I don't think Crystal is that bad at all really.
It's just a matter of correlating the database records and aligning them to the tables that you need the data on. Everything else is often as simple as just doing the math.
Database management is my least favorite part of my job
-
@DustinB3403 lol, no it wasn't.