Access all records at once

[sirpelon]

Hi everyone

How can i do this?

i have 10 records in a table and i need to read it all, i mean each record is a value for a formula field and i want to display the 10 formula fields on one page, but crystal is displaying 10 pages each one with the value of the formula field

on the table:
formula_1 10
formula_2 20
.
formula_N 56

on the report:

@f1 @f2 ... @fN

Crystal is showing this

Page 1
10 0 0
Page 2
0 20 0

Page 10
0 0 56

And i want this
Page 1
10 20 56

 

[Turkbear]

Hi,
Some questions:
Version of Crystal?
Database type and connection?

Where are you placing the formulas?
If all are placed in the Details section then you should get 10 rows each one showing the 10 formulas' output.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sirpelon]

Hi

The version number is 9, the DB is SQL and the connection is ODBC, the formulas first were placed on the details section, later on the report footer but was the same behavior.

In fact i better did this:
Create a sumarized field of each formula and place this instead of the formula field, so now i have the result i was looking for, maybe not the best way but it's ok.

Thanks anyway Turkbear !