Solved

Reporting Services 2005 - Navigation from Summary to Detail with Dynamic Parameters

Posted on 2006-06-19
2
365 Views
Last Modified: 2011-10-03
I have a summary report with one group.  The group is by month. There are five dynamic columns based on year. There are two parameters that come in from the stored procedure for the Report begin date and the reports end date. The layout is as follows:

[code]

     2006   2005   2004   2003   2002
Jan   $$     $$     $$     $$     $$

[/code]

I get the years dynamically using variations of =Year(now())
I get the months using =MonthName(Month(fields!PostedDateTime.value))

The detail come from calculated fields similar to the following: =iif(Year(fields!PostedDateTime.value) = Year(Now())-1,cint(Fields!Amount.Value),0)
Which I then sum at the group level.

The report looks great, now comes the good part.  What my boss wants is if someone clicks each dollar amount that it passes the right begin date and end date parameters to bring back all the detail.  So if my reports original paramenters were from 1/1/2003 - 4/30/2006 and they click on the amount under column 2006, row April I need to pass as a parameter to my detail report a begin date of 4/1/2006 and an end date 4/30/2006.

If the columns were hardcoded no biggie, but since they are dynamic, my coding expertise is lacking.  I am not sure how to rebuild my parameters.

Something like begin date being= ((Month(fields!PostedDateTime.value))+ 1 + Year(Now())
0
Comment
Question by:djehmli
2 Comments
 
LVL 4

Accepted Solution

by:
dnsvh earned 500 total points
ID: 16937311
You should be able to pass something like:

MONTH(Fields!PostedDateTime.Value) & "/" & "1" & "/" & YEAR(Fields!PostedDateTime.Value).
0
 

Author Comment

by:djehmli
ID: 16943067
Thank you for the response.  That helps clarify the syntax for the first day of the month, though I would use Year(Now()) for the second half.

But what would the approach be for the end date?  The months are dynamic.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now