how to......

[cm1234]

Hello out there

Im running CR 9,0 and the data in this question comes from oracle 9,0
Here comes my question:
i need to get more then one data output from a table/field
TABLE: type-Fields: CY,FH,AD,LD.....
and Table Publication- that relate to the fields in the Table Type
i need to could get hold off thies data so that i can
make a report that schould look like this
Pageheader: CY-FH-AD-LD
Detailsec: different dataoutput under each type from Publication
I hope this makes sense and that someone can help me
thanks in advance

 

[synapsevampire]

Doesn't make sense to me.

Does this "TABLE: type-Fields: CY,FH,AD,LD....." mean that you are desdcribing a table called type, with fields called CY, FH etc.?

Try posting example data and expected output, as in:

table1
field1 field2 field3
12345 duck butter

output:
duckbutter 12345

Perhaps you mean that you have a field which contains those values, and at the start of each page you want all of them listed, and then within the report, grouped by each type with some sort of summary values.

Group by the field

Create a formula for the group header akin to:

whilereadingrecords;
stringvar MyTypes;
if instr(MyTypes,trim({table.field})) = 0 then
MyUps := MyTypes+" "+trim({table.field});

Now in the page header use something like:

whileprintingrecords;
stringvar MyTypes

This will list all of the types.

You might also use a SQL Expression, and there are other ways.

-k

 

[Ngolem]

I agree with SV....doesn't make sense to me either.

Show us an example of hoped for output...read my tagline

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!