Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Display Parameter in Crystal Reports Graph?

Posted on 2014-11-06
4
Medium Priority
?
431 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
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
New style of hardware planning for Microsoft Exchange server.
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

578 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