Hello, I have the following dataset that is used in a bar chart. SELECT * FROM (SELECT ed.Eventdate,ed.Location + ', ' + s.Code AS DetailID ,tmp.ID ,Ave_of_3questions ,PH.LegalName + ' ' + PH.LastName + CASE ISNULL(PH.Degree,'Other') WHEN 'Other' THEN '' ELSE ', ' + PH.Degree END AS [Speaker] FROM tmp_2804_Databyprogram tmp JOIN Eventd ed ON tmp.DetailID = ed.DetailID AND ed.EventID = 3110 JOIN stater S ON ed.StateID = S.ID JOIN FacultyEventx FEX ON ed.EventID = FEX.EventID AND ed.DetailID = FEX.DetailID AND fex.status = 8 JOIN Facultyh FH ON FEX.FacultyID = FH.ID JOIN Participanth PH ON tmp.ID = PH.ID WHERE ID = @ParticipantID UNION ALL SELECT '' ,'Individual Average' ,tmp.ID ,Ave_of_3questions ,PH.LegalName + ' ' + PH.LastName + CASE ISNULL(PH.Degree,'Other') WHEN 'Other' THEN '' ELSE ', ' + PH.Degree END AS [Speaker] FROM tmp_2804_Databyspeaker tmp JOIN Participanth PH ON tmp.ID = PH.ID WHERE tmp.ID = @ParticipantID) AS X ORDER BY CASE WHEN DetailID = 'Individual Average' THEN 1 ELSE EventDate END DESC I'm using two results from the dataset in my chart, the DetailID and the ave_of_3questions. Its is a straight forward report. However, notice that is has a parameter that they need to supply to generate this report. What I'm trying to do is remove the parameter completely, and basically generate all the reports at once. I can't do any grouping in charts. How can I accomplish this? Thank you

Use a default parameter value and then make the parameter hidden.

If you are planning to generate all the repots at once and storing it somewhere, you can use data driven subscriptions and then use a query in that to generate all the reports through the parameter. If you want all the charts to be in one report, instead of the filter for the parameter, you need to being it to the columns (so that you will have a column for ID - I can see that you already have it). Now use a list (you can find it in the toolbox) to generate all the charts for each ID or you can even put the ID in a matrix and in the data cell , you can put the chart that you want to display Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Hi teesql, Also, you can insert a List and put the chart into the List, then set the list grouping on the ID which is parameter orignially. So, the report will be generated at once and these charts will be listed in the List control based on the ID. thanks, Jerry