Hi Lech, I have attached the report template I am working on. The datasource in question is 'WeeklyPct'. I wish to display the results of this SQL query in GroupFooterBand1 in my CrossFooterBand but am unsure of the best way to do this with dynamically set columns. Obviously I can't use the retrieve...

I have a datasource with the following SQL code. (Test data included) CREATE TABLE #yt ( [PupilID] int, [WeekNo] int, [IsInAttendance] int ); INSERT INTO #yt ( [PupilID], [WeekNo], [IsInAttendance] ) VALUES (102, 1, 1), (102, 1, 1), (102, 1, 1), (102, 1, 1), (102, 1, 0), (102, 1, 1), (102, 1, 0), (1...

This can be ignored now.

I was using LookUpBox.SelectedValue instead of SelectedItem. It is working now.

Hi Edward, Thanks for the help. I have attached the report in question. In Form1 the first LookUpBox is populating correctly with from my table 'SchoolTerms'. I want the second LookUpBox to populate upon the first LookupBox having an option selected. I am currently getting the error 'Object referenc...

I have a parameter '@YearDropDown' that takes it's value from a LookUpBox.SelectedValue I then use @YearDropDown in the following SQL statement in a DataSource. SELECT LD.Description, ST.StartDate, ST.EndDate FROM SchoolTerms ST LEFT JOIN LookupDetails LD ON ST.Name = LD.LookupDetailsID AND LD.Looku...