August 4, 2025 at 2:34 pm
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,
August 5, 2025 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
August 5, 2025 at 5:10 pm
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