Displaying different rows by using a formula.

[mondi]

How can I make a formula that displays different rows and to specify where to put these rows in report.
In my formula, I have to use an <If Then Else> statement.
If ...... Then display only one row
Else display 4 rows and the distance between rows must not be like the standard, but I have to specify it myself.
I know that a choice might be to make a formula for each row using the 'if then else' but I need to do something like this in an other part of my report, and there I can't use different formulas to display the rows.
Thanks for any help.

 

[hencyt]

Mondi,

Is this to fill out a pre-printed form? Is that the reason for the spacing?

Have you tried using counters? You can place formulas in the report that will count the number of records and perform actions based on the count #.

We might need more info to be able to help you.


Sunny

 

[mondi]

Hello everybody!

I'm not sure how to use Counters.
In my report, as Data Source, is a data set. In my computer I have installed Crystal Reports for .NET 2002. The data base is created using SQL 2000.

Now the problem is like this:
I have different tables in my data set, but the two tables that I need, are <SENDERS> and <CUSTOMERS>. If the data fields <SENDERS.SENDER_ID> and <CUSTOMERS.CUSTOMER_ID> have the same value, then I have to display a text in the report. Else if they have different values then I have to display in my report different data fields from the table <SENDERS> like the <NAME1>, <NAME2>, <STREET1>, <STREET2>, and perhaps some other field. These must be displayed in the place specified by me. I mean the two fields might be displayed in one row, the other in second row and so on. I must also specify the distance between two rows so that the two rows must be near to each other.
If somebody helps me in this, would put off me a big problem. Thanks