How do I handle multiple rows? 1

[Santos]

I'm creating a new report that pulls data from our ASP applicant tracking system. We can't pull directly from the database, so we have to download the data and then save it as an access file.

The problem is with how they generate the report. It looks like this in Access:

Job Title One Approver 1
Approver 2
Approver 3
Job Title Two Approver 1
Approver 2
Approver 3

I'm using Crystal to "pretty up" the report as well as exclude specfic rows based on the job title.

The problem is that I can't suppress the data because there is no job title associated with the "approver 2" and "approver 3" rows - rather the field is null.

Question is, how do I get the Job Title to show on ALL the rows?

Any help would be much appreciated!

 

[lbass]

How do you know for sure that approver 2 and 3 belong to each job title? Is there another field associated with the job titles that does repeat?

-LB

 

[Santos]

Hi LB, thanks for the quick response. I do know for sure the approver 2 and 3 belong to each of their respective job titles. I was able to verify it. Unfortunately, no other fields repeat....I wish at least one did.

 

[lbass]

You could try this (it tests out here). Create a formula {@runningjobtitle}:

whileprintingrecords;
stringvar x;
if not isnull({table.jobtitle}) then
x := {table.jobtitle} else
x := x;

Then using the section expert, you can conditionally format the details section to suppress by setting the formula equal to whatever value you want suppressed, as in:

{@runningjobtitle} = "Job Title Two"

-LB

 

[Santos]

LB....this works PERFECTLY. Thanks so much!

 

[radmad]

I have the same problem. I need all the fields prior to "BACKING" field to fill in. I'm not sure how the formula would work for this case. Can you help?

ORDER STYLE COLOR SIZE BACKING
AID ABT 0 ASSTD2 BK
AID N1545 4300 21034 LC
BK
AID N1718 9282 ELID BK
LC
BK
BK
AID N1718 9295 21024C BK
LC
LI
LI

 

[lbass]

You can use the earlier formula to replace each non-repeating field, changing the variable name each time. For example:

//{@Order}:
whileprintingrecords;
stringvar x;
if not isnull({table.order}) then
x := {table.order} else
x := x;

//{@Style}:
whileprintingrecords;
stringvar y;
if not isnull({table.style}) then
y := {table.style} else
y := y;

If any of your fields are numbers, use:

//{@Number}:
whileprintingrecords;
numbervar z;
if not isnull({table.number}) then
z := {table.number} else
z := z;

-LB