Sue Taylor
asked on
Display Parameter in Crystal Reports Graph?
I have a CR that uses a date parameter. The report also has a chart in it. When the user runs the report he enters a date range.
Is there a way for me to display the date range as a sub-title on the chart?
In the past I was able to display the date range parameter values in the report name field by using a formula like:
if HasLowerBound({?DateParam} ) and HasUpperBound ({?DateParam}) then "Date Range:" +
Totext(Minimum ({?DateParam}), "MMM-dd-yyyy") + " thru " + Totext(Maximum ({?DateParam}), "MMM-dd-yyyy") else
if HasLowerBound ({?DateParam}) then "Date Range: After " + ToText (Minimum({?DateParam}), "MMM-dd-yyyy")
else "Date Range: Before " + Totext(Maximum({?DateParam }), "MMM-dd-yyyy")
But if I enter in the chart subtitle something like @DisplayDateParam all it does is displays exactly what I typed.
Is there any way to do this in a chart?
Is there a way for me to display the date range as a sub-title on the chart?
In the past I was able to display the date range parameter values in the report name field by using a formula like:
if HasLowerBound({?DateParam}
Totext(Minimum ({?DateParam}), "MMM-dd-yyyy") + " thru " + Totext(Maximum ({?DateParam}), "MMM-dd-yyyy") else
if HasLowerBound ({?DateParam}) then "Date Range: After " + ToText (Minimum({?DateParam}), "MMM-dd-yyyy")
else "Date Range: Before " + Totext(Maximum({?DateParam
But if I enter in the chart subtitle something like @DisplayDateParam all it does is displays exactly what I typed.
Is there any way to do this in a chart?
ASKER
2008
So in the meantime, I tried to create a subreport and I'm not getting the results I want.
My data is a list of non-conformances. Each non-conformance (NC) has a type, which is like a category. I may have hundreds of NC's but there are only 20 different types.
I want the user to select which types he wants to report on. That I have accomplished through a parameter.
But I also somewhere on the page with the chart to show which Types were chosen.
There is only one table used in this report.
I created a dynamic parameter called "type"
My sub-report displays only the field called "type". I have Suppressed all blank sections.
I added the sub-report to my main report and have the Field(s) to link set to ?Type, The Subreport parameter field to use is set to ?Pm-?Type and the Select data in subreport based on field is checked and set to NC.type
When I run the report it is displaying a list of types, one for each NC I have.
NC-Issues.rpt
Selected-NC-Types.rpt
So in the meantime, I tried to create a subreport and I'm not getting the results I want.
My data is a list of non-conformances. Each non-conformance (NC) has a type, which is like a category. I may have hundreds of NC's but there are only 20 different types.
I want the user to select which types he wants to report on. That I have accomplished through a parameter.
But I also somewhere on the page with the chart to show which Types were chosen.
There is only one table used in this report.
I created a dynamic parameter called "type"
My sub-report displays only the field called "type". I have Suppressed all blank sections.
I added the sub-report to my main report and have the Field(s) to link set to ?Type, The Subreport parameter field to use is set to ?Pm-?Type and the Select data in subreport based on field is checked and set to NC.type
When I run the report it is displaying a list of types, one for each NC I have.
NC-Issues.rpt
Selected-NC-Types.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. Thanks!
I don't think that is possible.
mlmcc