Solved

Display Parameter in Crystal Reports Graph?

Posted on 2014-11-06
4
408 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 100

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 100

Accepted Solution

by:
mlmcc earned 500 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

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

Suggested Solutions

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…
Learn about cloud computing and its benefits for small business owners.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 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