code

code

  • NA
  • 1
  • 0

Creating reports

Feb 1 2007 5:04 PM
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?