jollyreaper
Technical User
Got a doozy of a problem on Crystal XI. Our construction people use a sequence number to indicate the proper order for construction tasks to appear on the schedule. They also have the option of assigning the task to a task group.
The table in the database thus looks something like this (using pipes to separate fields)
PrimaryKey | Task Description | Sequence | Taskgroup | lots of other stuff that's not important
When they see the sequence number in the application, it is printed like so -- Taskgroup+Sequence. The taskgroups are A, B, C etc., sequence numbers are 25, 100, 1000, 5000, in whatever ascending order that makes sense to them.
Now they were *TOLD* it would make our lives easier if they kept the sequence numbers unique. Naturally, they ignored us. So we've got duplicates as far as sequences go, even though they are unique when paired with a task group.
My problem now is that I've got to try and run reports based on these groups. There are three groups:
A50 to A2800
A2800 to B2300
B2300 to B5700
I know how I would do this in Excel. I would just concatenate the sequence and taskgroup into a third column and do my work based off of that. I assume I will be doing something similar in Crystal to work through this problem, grouping by the concatenation of these two data fields. The only question is ... how?! I know this has to be fairly rudimentary but I'm still now sure. Thanks!
The table in the database thus looks something like this (using pipes to separate fields)
PrimaryKey | Task Description | Sequence | Taskgroup | lots of other stuff that's not important
When they see the sequence number in the application, it is printed like so -- Taskgroup+Sequence. The taskgroups are A, B, C etc., sequence numbers are 25, 100, 1000, 5000, in whatever ascending order that makes sense to them.
Now they were *TOLD* it would make our lives easier if they kept the sequence numbers unique. Naturally, they ignored us. So we've got duplicates as far as sequences go, even though they are unique when paired with a task group.
My problem now is that I've got to try and run reports based on these groups. There are three groups:
A50 to A2800
A2800 to B2300
B2300 to B5700
I know how I would do this in Excel. I would just concatenate the sequence and taskgroup into a third column and do my work based off of that. I assume I will be doing something similar in Crystal to work through this problem, grouping by the concatenation of these two data fields. The only question is ... how?! I know this has to be fairly rudimentary but I'm still now sure. Thanks!