Solved

Displaying a Date Range from Parameter Fields

Posted on 2011-03-03
4
304 Views
Last Modified: 2012-05-11
I know how to display a string value from a Parameter Field.  I have learned how to display a list of items if the parameter field is "Allow Multiple Values".  However, I cannot seem to be able to display the range (start date and end date) in the parameter field.

How do I do this?

TIA
0
Comment
Question by:Clif
  • 3
4 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 35029086
If you're referring to a simple ranged date parameter, you can create formulas for the minimum and maximum values.

Minimum({?Date})

Maximum({?Date})

If you're referring to a ranged date parameter with multiple ranges, it gets a lot more complicated...

~Kurt
0
 
LVL 10

Author Comment

by:Clif
ID: 35029535
Error: "The formula result must be a string."

Tried changing it to read:

ToText(Minimum({?Date}))

Result is empty.
0
 
LVL 10

Author Comment

by:Clif
ID: 35029544
It is not multiple ranges.  Just a range.  I enter values for "Start of Range" and "End of Range"
0
 
LVL 10

Author Closing Comment

by:Clif
ID: 35029739
Not sure what the problem was.  I tried adding the code to the Parameter Field's "Display String" code behind, like I had done for other Parameter Fields and it didn't work.

However, just for grins and giggles I tried just creating a formula with your code and that did work.

Thanks for the help.  :)
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

20 Experts available now in Live!

Get 1:1 Help Now