Non relational Database Report Creating

[babyblu]

I am trying to populate reports within C.R. 8.5

I have 2 files
a= id, name, abbrev
b= id, id_0, id_1, id_2, id_3, id_4

On the report I am grouping, filtering etc... and basically I am printing out individual records from b

HOWEVER
All fields in each record of b are linked to the id field in a.


WHEN DISPLAYING RECORD DETAILS FROM B
For id in b I need name from a to appear(linked via id field in a). - which works -
For id_0 in b I need abbrev from a to appear(linked via id field in a).
For id_1 in b I need abbrev from a to appear(linked via id field in a).
For id_2 in b I need abbrev from a to appear(linked via id field in a).
For id_3 in b I need abbrev from a to appear(linked via id field in a).
For id_4 in b I need abbrev from a to appear(linked via id field in a).

I cannot mess with any file/field/link structures as the database I am accessing thru Crystal Reports is an ODBC which is being populated via a Timesheet Enteries program

If u have used Crystal Reports do you know a way around outputting the related fields on the reports OR can u think of a quick stored procedure where 5 temp tables can be created & populated correctly, then accessed for report info.

Thanks
Conor.

 

[kenhamady]

If I understand correctly, you need multiple copies of the A table, and you link each copy to a different ID. CR will alias the extra copies. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)