?
Solved

Display Parameter in Crystal Reports Graph?

Posted on 2014-11-06
4
Medium Priority
?
420 Views
Last Modified: 2014-11-07
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?
0
Comment
Question by:ITworks
[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
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 40426511
What version of Crystal?

I don't think that is possible.

mlmcc
0
 
LVL 4

Author Comment

by:ITworks
ID: 40426991
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
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 40427302
Try this for your Display Type formula

Join({?Type},chr(13))

mlmcc
0
 
LVL 4

Author Closing Comment

by:ITworks
ID: 40428797
Perfect.   Thanks!
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

777 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