HI SQL gurus - new to the forum.
I recently started teaching myself SSRS and tackling business reports at my office. I have fairly basic SQL query skills, so you may need to bear with me if things get complex.
I have an existing report I inherited from a prior employee that I am trying to enhance.
It displays $$ data based on a weekly parameter set by the user. (@ startdate, @end date)
In my enhancement, I'd like to add a second table that lists historical week by week information but I am not quite sure how to approach this ? I did copy the report and in the duplicate copy (thinking I could link them together) made a hidden parameter with static date range for q1 but that of course didn't quite give me what I wanted, it was 1 large figure instead of a week by week basis. Ideally, a table on the original report would be great, but a linked separate report would also work. I guess this may also pose issues of how many weeks to display in total, etc. But any guidance on how to approach in general would be great.
user sets date range - parameter defaults to last sun-sat
User A: Target earnings | Total Earnings | %
User B: "
User C: "