Data Report Object vs Crystal Reports 1

[INeedSomeSeriousHelp]

I hope I explain this correctly so you can help me. I have a database (Access) with multiple Tables. For the Exam Table, I have many child commands from this Exam Table. When I went to use the Data Report Object, I believe it only let me place fields from one child command into the details section. The problem is my report (an eye exam report) needs to have fields from many different child commands from the Exam Table. Does this make sense? Am I describing this correctly? Does the Data Report Ojbect allow you to only enter into the details section from one child command from a Table like I am finding? If this is true, does Crystal Reports allow me to get around this problem? Thanks for your help and don't forget to have your eyes checked every 1-2 years!

Thanks
Doc

 

[johnwm]

I notice that you have asked 8 questions, and as yet seem to have no answers that you consider helpful. It may be worth reading faq222-2244 to find how to get the best from the forum. It gives guidance on asking better questions and acknowledging helpful answers.

For this question, it's not clear to me whether the data is truly hierarchical (in which case use the MS DataShape provider for your query) or whether you simply need a multitable query:

strSQL = "SELECT tblReps.RepName, tblClients.ClientName, tblClients.Add1, tblAppts.Status, tblAppts.ApptType
FROM (tblClients INNER JOIN tblAppts ON tblClients.ClientID = tblAppts.ClientID) INNER JOIN tblReps ON tblAppts.RepID = tblReps.RepID
WHERE (tblAppts.ApptType)= " & strCriterion & "

There are some good examples of both usages in JetSQL help. This is found normally on W2K and XP packages at "C:\Program Files\Common Files\Microsoft Shared\Office10\1033\jetsql40.chm"

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'