Solved

Display Parameter in Crystal Reports Graph?

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report Image from SQL field with file location 3 54
Crystal Reports last day of month 2 44
Business Object Server 2 28
Docker for Windows 2016 5 69
Requirements: root access via SSH, telnet, or other.. Alternately, access from the server administrator to run a counter-strike server, and the proper access rights to do so. Enough free disk space (and allowed to use this much, eg disk quota): 6…
Usually shares are where we want them for our users and we tend to take them for granted. There are times, however, when those shares may disappear causing difficulty for your users. One of the first things to try is searching for files that shou…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 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

21 Experts available now in Live!

Get 1:1 Help Now