• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Missing Field for Parameter

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
rporter45
Asked:
rporter45
2 Solutions
 
Brook BraswellApplication Development ManagerCommented:
Have you tried to refresh your data source ?

Database->Verify Database
0
 
mlmccCommented:
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
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
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
 
rporter45Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now