Creating a prompt

[kupz]

How do you create a prompt for users to enter specific criteria? I am not sure how to do this but know that parameters can be used. For example, the user will be prompted to enter a cutomer number and so would return information based on the inputed customer number. Please help.

 

[siri]

myniguez,
u just create a parameter variable by going to "Insert" menu, "Parameterfields".
After creating parameter variable, go to "Report" menu, "Edit Selection Formula", "Record"
In "Record", u map the field i.e. ur parameter variable(customerid) with database field({tablename.fieldname})
eg:
customerid=({customers.customerid})

hope this will help to u
siri

 

[kanau]

myniguez,

Insert a parameter, giva a name to it.
From the "Report" Menu, select "Select Export" then choose the "CustomerID" field, value "is equal to" "yourParameterName"

That is!

Hope this can help
Kan

 

[kupz]

Thanks guys! It worked! That was pretty easy. I did have a question though about setting parameters if your data source is an OLAP database like Essbase. Tech support told me that this was not possible. Can they be wrong? If you have any information about setting parameters with OLAP databases I would really appreciate.

 

[kenhamady]

Did you try it?
What happened? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kupz]

kenhamady,

I did try this method and basically would not work. What happened was it would let me choose the underlying data, you would be able to choose the data, for example, dimension is Period and you have under that Level 2, this would contain the months. So if I pick Oct then it would give me October without refreshing the data. I know you can probably manipulate this in code but don't have a clue how to go about this. Thanks for any feedback.

 

[kenhamady]

If CD told you it couldn't be done, and you have tried it and found them correct, it probably can't be done. I haven't tried it, but it would surprise me if you couldn't use a parameter in an OLAP report.

So, if you want to describe your last post in more detail, I will see if there are any problems with your approach. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kupz]

I'll play with it some more and see what kind of solution I can come up with.