forcing record to display multiple times

[johnuk1]

when i run a report my record is displayed once per item. Can i force it to display multiple times depending upon the value of a field. I have 3 revenue fields and want the record displayed once per field if there is a value in it

I am using crystal 9

 

[vidru]

Can you supply some more information, like sample data and expected output?

-dave

 

[synapsevampire]

Right click the section that you're displaying the data in, presumably the Details, and select insert section below two times to create additional sections for display.

Repeat the required fields in each section.

Now you can conditionally display each section by right clicking each section and selecting Section Expert.

Place something like the following in the X 2 next to Suppress for each section:

isnull({table.field1})
or
{table.field1} = 0

section B would have:

isnull({table.field2})
or
{table.field2} = 0

Replace with the appropriate field names to check for not having a value. I assumed that this field is numeric, adjust accordingly if a string)

As Dave pointed out, your post lacks technical information, so if this doesn't help you, please post technical information.

-k

 

[johnuk1]

thanks this anwsers the question. Finally a place to hang out and talk crystal

thanks guys