I am creating a letter in a report format and I have 5 queries that I need to join to the main query so that when the letter runs it puts in the proper information from each query for the specific student. Is this even possible to join datasets on a specific field?
Yes.
I can't seem to get it to work. 
I thought maybe I needed to add something to the expression but that is not working.
You do.
I keep getting "A FilterValue for the dataset 'StateScholGrant' includes and aggregate function.... but I removed the aggregates and I don't know what is wrong.
Oh..