Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

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

Posted on 2006-06-19
Medium Priority
374 Views
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
Question by:djehmli
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 4

Accepted Solution

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

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

Author Comment

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
###### Suggested Courses
Course of the Month5 days, left to enroll