Solved

Display Parameter in Crystal Reports Graph?

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Patch Management is administrated by page 129 of  the following document:     http://support.dell.com/support/edocs/software/smdmc/11/en/ug/ug.pdf However, there are issues with Patch Management with FTP (for instance, a slow Internet connectio…
The 6120xp switches seem to have a bug when you create a fiber port channel when you have a UCS fabric interconnects talking to them.  If you follow the Cisco guide for the UCS, the FC Port channel will never come up and it will say that there are n…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 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

12 Experts available now in Live!

Get 1:1 Help Now