-
March 21st, 2012, 08:31 AM
#1
Reporting on first row of data on table
Alright, so here's the problem and for the life of me I can't figure it out:
Task: Creating a report that lists all of our medically disabled employees. Must be a single line report (i.e. can not group and then list underneath).
Problem: Some employees have more than one disability. This causes them to appear multiple times on the single-line report.
This is the table inside of my program that I am pulling from. This table is for a single employee. Notice how more than one disability is listed: (See bardistable.jpg below)
This is the results of my report when I run it in Crystal: (See reportresults.jpg below)
Somehow, I need to figure out a way to only show the first disability an employee has listed on their table. Like in employee 0077's case, I only want to see disability D02... not D04 and D05 too.
I DID find a solution to this by way of Section Expert > Suppress (No Drill-Down) > previous({hrpersnl.p_empno})={hrpersnl.p_empno}. But I can not use this formula because it causes my first employee to be suppressed for some reason.
Help please?
-
March 28th, 2012, 10:16 AM
#2
Re: Reporting on first row of data on table
try placing the following on the first line of your formula
-
April 2nd, 2012, 10:10 PM
#3
Re: Reporting on first row of data on table
hi
I am thinking, what you are looking for, you'd have to redesign your query so it can retrieve data properly.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|