Hello all. I have a main report based upon a survey that is grouped on SurveyLine/StatementNumber for a particular SurveyNumber in our database that produces weighted scores for the statements. Lets say this survey has statements 1.0 thru 45.0 in it. I am trying to add a subreport in the Report Header that is a subset of the statements in the main report based upon a bit field.
So if this bit field is set I need to show just those statements and scores from the main report in the subreport. I have linked the two reports based on the SurveyNumber parameter and the subreport is printing the SurveyLine and StatementText for just the questions that I need. My problem is coming from trying to get the scores for those statements in the main report with the same statements in the subreport. I am using a shared variable but I keep getting 0.0
for that shared variable in my subreport.
Any help is appreciated.