Multipage report using Graphs

  • I don't know how to do this and I apologize if I don't explain it well.

    I have a report that shows data and a graph by month, but right now it is only for one job at a time.

    Create table #MyTempTable2 (Job varchar(6), Mth date, profit numeric(6,2));

    Insert Into #MyTempTable2 (Job, Mth, profit) Values (1,'1/1/2025',500);
    Insert Into #MyTempTable2 (Job, Mth, profit) Values (1,'2/1/2025',600);
    Insert Into #MyTempTable2 (Job, Mth, profit) Values (1,'3/1/2025',700);

    Insert Into #MyTempTable2 (Job, Mth, profit) Values (2,'1/1/2025',300);
    Insert Into #MyTempTable2 (Job, Mth, profit) Values (2,'2/1/2025',400);
    Insert Into #MyTempTable2 (Job, Mth, profit) Values (2,'3/1/2025',500);

    Select Mth, profit From #MyTempTable2 Where Job = 1 -- This is a parameter, not fixed

    This works great.

    I can create a query that shows the jobs I want and add page break between each group/job. But the graph is combining both jobs and showing at the end. I'd like the graph to reflect each job next to the table for that job.

    Thank you,

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • I believe I solved it by going to a subreport.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply