I'm currently trying to find a good way to create reports. I have a C# app. that's using a MS Access DB. I need to be able to print a single report on 1 item the user has selected. My DB is structured:
MainInfo
->InfoID
->InfoName
->TypeIDLink
->InfoDescription
InfoType
->TypeID
->TypeName
InfoSteps
->InfoIDLink
->StepNumber
->StepName
InfoExp
->InfoIDLink
->ExpNumber
->ExpName
InfoRev
->InfoIDLink
->RevNumber
->RevName
The user will pic an item from the MainInfo table and the report should print all the items that link back to that 1 item. It needs to print the MainInfo items, then the InfoSteps, then the InfoExp then the InfoRev. There can be multiple Steps, Exp and Rev corresponding to the one MainInfo item:
MainInfo
->InfoSteps
->InfoExp
->InfoRev
When I try to use Crystal Reports it won't let me have 3 different items all linked to the MainInfo table. It thinks each set is related to the one before it. Is there a way to do this in the .Net Crystal Reports or should I be looking for a different way to do this?