Using Dynamic Formula Parameters in Report Manager Subscriptions

Posted on 2008-11-06
Medium Priority
Last Modified: 2012-05-05
I have a situation where a user wants to subscribe to a report that takes a date range, with a start and an end date. They want to be able to have the report be able to run against a specific time frame for every subscription. So for example, the report would run every Monday, and show the data from the previous week. Another user would want the same report to run every Month, and show the previous Month. so if i have a paramater of Start Date and End Date, how could they put in a value to indicate this constantly moving date range.

Something like Start Date = Beginning of previous Month and End Date = End of previous Month, and every time the subscription fires, it recalculates the dates.

Any guidance appreciated.
Question by:Patrick_Schouten
1 Comment

Accepted Solution

Ernariash earned 2000 total points
ID: 22899006
Set the defauld values like this:
Start Date
=CDate(FormatDateTime(DateAdd("m",-1, DateSerial( Year(Today), Month(Today), 1 ) ),1))
End Date  =CDate(FormatDateTime(DateAdd("d",-1, DateSerial( Year(Today), Month(Today), 1 ) ),1))

=CDate(FormatDateTime(DateAdd("m",-1, DateSerial( Year(Today), Month(Today), 1 ) ),1))
=CDate(FormatDateTime(DateAdd("d",-1, DateSerial( Year(Today), Month(Today), 1 ) ),1)) 

Open in new window


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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 …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

830 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