Help with formula

[Mipana]

I want to make a report with two column one of revenues and another of expenditure for some steering wheels of payments.but when it prints me in the detail prints this way

Credit Debit
18 TAX 1,152.27
31 AFP 250.00
43 OTHER 250.00
01 SALARY 12,500.00
02 TRANSPORT 137.50

I want that the column of debits this in the same line that the credit are and they don't find spaces in white

 

[lbass]

Since these look like detail level entries, I think you would have to use two subreports. You probably have a group in the main report on {table.account}. Then insert a subreport that has a select statement that limits records to credit amounts, link it to the main report on {table.account}, and place it in the group footer. Repeat for the second subreport, this time limiting records to those with debit amounts. Now you can place this next to the credit subreport in the group footer.

-LB

 

[Mipana]

In that way it doesn't work me. Because these they are the steering wheels of the employees' of the company payments. There is not another form that I can make this report. I want it is primed this way.

Credit Debit
01 SALARY 12,500.00 18 TAX 1,152.27
02 TRANSPORT 137.50 31 AFP 250.00
43 OTHER 250.00
------------ -------------
12,637.50 2,652.27

 

[synapsevampire]

Given the language barrier, don't describe the environment with text, give actual examples:

Crystal version
Database used
Tables involved
Example data
Expected output

-k

 

[Mipana]

Crystal version: 8.5
Database used: informix
Tables involved: EMP, TRANS, DEPTO
Example dates
Expected output: steering wheel of the employees' of the payments the company.

Me simplente wants him to can when they are revenues or expenditures come out the the same files and each one in its corresponding column.

 

[lbass]

I'm not sure why you think you cannot use the subreport method. Using two subreports WOULD give you this layout:

Credit Debit
01 SALARY 12,500.00 18 TAX 1,152.27
02 TRANSPORT 137.50 31 AFP 250.00
43 OTHER 250.00
------------ -------------
12,637.50 2,652.27

-LB

 

[synapsevampire]

LB's suggestion sounds plausible given the limited information.

Show examples of real data, we have an example of the expected output, but we don't have the luxury of knowing the way your data is stored, such as how you differentiate a credit from a debit.

-k

 

[Mipana]

Ok. I have three charts in informix. Employee's chart, departments and transations. In that of transations it is where the data of the payments and the employee's deduction are. These fields are in transations

Codigo Emp 154
Dates transations 15/02/2004
Type transations I (I - Credit, E - Debit) Code transations 01 (01 - Salary, 02 Transport are Credit)
(18 - tax, 31 - AFP, 43 Other are Credit)
Monto 15,000.00

This is the structure of it dates it. And the exit form is as previously I have specified it or as this specified by IBASS