Crystal Reports subreport causing report to shut down

[kims212]

Crystal Reports XI

I am trying to run a report in "native" Crystal Reports. This report runs fine under the iAppraise database application for which it was developed.

The problem seems to lie with the subreport which I have extracted and tried to run on its own.

The sub report uses two tables the fields for which are extracted by two commands at the front of the db.

command 1: AnswerData

SELECT dbo.Answers.SessID, dbo.Answers.QGName, dbo.Answers.QG2Name, dbo.Answers.QText, dbo.Answers.QSSeq, dbo.Answers.QSName, dbo.Answers.QQNo, dbo.Answers.QMand, dbo.Answers.ThresholdScore, dbo.Answers.Score, dbo.Answers.Evidence, dbo.Answers.AnsID
FROM dbo.Answers
WHERE (dbo.Answers.QG2Name = N'GMP') AND (dbo.Answers.SessID={?prSessID})
ORDER BY dbo.Answers.QSSeq

commnad 2: NotApplicableAnswers

SELECT dbo.Answers.ThresholdScore AS NAThreshold, dbo.AnswerObject.QIText, dbo.AnswerObject.QIAnswer, dbo.Answers.AnsID
FROM dbo.Answers INNER JOIN
dbo.AnswerObject ON dbo.Answers.AnsID = dbo.AnswerObject.AnsID
WHERE (dbo.AnswerObject.QIText = N'Not Applicable') AND (dbo.AnswerObject.QIAnswer = N'#s#')

The problem seems to be with fields from the second command, NotApplicableAnswers. if I run the report using fields from only AnswerData, the report runs fine but as soon as I add a field from the NotApplicableAnswer table, the report shuts down Crystal Reports.

Any help would be appreciated; I'm quite puzzled - but still very much new to Crystal Reports.