Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  GROUPING ISSUE WITH REPORT AND SUBREPORT!!! NEED

Author  Topic  v_kash Starting Member 45 Posts Posted - 2011-11-29 : 13:03:41 I would appreciate any help on this! So basically here's the issue: 1) I have a report that shows sales by person and by day (so for example, page 1 would be sales for Steve on 11/1/11 (25 dollars). page 2 would be sales for Steve on 11/2/11 (30 dollars). This is in a list by the way) 2) I have a subreport that basically is a 'weekly snapshot' of what i have in step 1. So on page 1, you'll see the COMBINED sales for Steve from 11/1/11 - 11/2/11 (which would be 55 dollars). When I run the main report, it shows each person's weekly snapshot, and then shows the detailed report (step 1). What I'd like, is to show Steves WTD report first (Step 2), and then show the Steve's daily report (Step1). I hope this makes sense and I hope someone has a good idea for me to accomplish this? Thanks!!