Solved

Missing Field for Parameter

Posted on 2011-09-13
4
234 Views
Last Modified: 2012-05-12
Hi there,

It could be just  a very long day but I have created a formula to group records together.  This works out perfectly - all of the data is in the correct areas. But now I would like to use the same formula to as a Parameter but I can't select it from the list of available fields.

I create a new parameter but in the value field I drop down the menu but can't see the field I created to group by.

Sounds so simple but I can't figure our why - any help would be greatly appreciated,

thank you -
cms
0
Comment
Question by:rporter45
4 Comments
 
LVL 14

Expert Comment

by:Brook Braswell
ID: 36535976
Have you tried to refresh your data source ?

Database->Verify Database
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 60 total points
ID: 36536229
I believe parmeters can only get their data from database fields.

I this a regular Crystal parameter or a Command parameter?
Is it static or dynamic?

mlmcc
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 65 total points
ID: 36536237
You can't use formulas as the basis for parameters. If you want to use the result of a formula as a parameter value then you need to add the result into the pick list manually (in a static parameter).

If you're going to use a dynamic parameter, then you'd have to build a business view with an LoV or create a SQL Command object that has the  code for the formula inside of it.
0
 

Author Closing Comment

by:rporter45
ID: 36536362
Hi there,

Mlmcc - you are correct!  rhinok your additional information prompted me to create a parameter that allowed the user to select the group names.  I then went into select expert, chose the formula that I used for the grouping and then added the parameter to the criteria.

All works perfectly now,

Thank you -
cms
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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

932 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

13 Experts available now in Live!

Get 1:1 Help Now