We help IT Professionals succeed at work.

How to get an ASP.Net Crystal report to prompt for parameter? VS 2005

Rog D
Rog D asked
on
1,148 Views
Last Modified: 2008-05-29
I have not figured out how to get the ASP.Net Crystal report to prompt for a parameter.

I have the report working fine, but now want it prompt for a parameter.  I have added the parameter to the paramater list in the tool box, but now how do I actually use it?  

Does it need to be added to a selection Formula?  If so how?

Thanks,
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
I assume by tool box you are referingot the field explorer in Crystal.

Unless the parameter is on the report somewhere, Crystal doesn't require a prompt.

Parameters are used for many things but generally in the selection formula through the REPORT --> SELECT EXPERT

mlmcc
Rog DSQL Developer / Web Development / Business Analysis
CERTIFIED EXPERT

Author

Commented:
I put the parameter on the report, but when the report came up it didn't prompt me?

I don't understand the select expert.  I don't see the parameter in the list at all.

I know it's probably easy, but not very intuitive.

Rog
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
The select expert isn't overly intuitive.

You first select the field to filter on.
Then choose the comparison.
FInally you get to choose the value or parameter.  If you are dealing with dates then the database field might be a datetime which in the select expert cannot be compared to a date.

Do you have the report saved with data?
Check FILE menu.  Uncheck save data with report.
If the report has saved data then that data is displayed and no prompting until you refresh. Save  Data with report is on by default.

mlmcc
Rog DSQL Developer / Web Development / Business Analysis
CERTIFIED EXPERT

Author

Commented:
I have upped the points to 500 as I need more pointers...

I have a select from a view.  

Select * from ViewOne.

This view has a date field  CreationDate

I want to be able to prompt the user for this date.  But the date field returned has some time on it like 12:00:00, so I want to convert this to a string and prompt for another date string from the user no time involved.

Can this be done, via select expert and parameter?

Thanks,

Rog
Rog DSQL Developer / Web Development / Business Analysis
CERTIFIED EXPERT

Author

Commented:
Also in the selection expert the "parameter" does not show up, so I don't understand how to use it.

thanks,

Rog
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Rog DSQL Developer / Web Development / Business Analysis
CERTIFIED EXPERT

Author

Commented:

Mimcc....

Ok, so now I get the prompt in Design mode on Refresh.  This is great.

I put it into Production and it kinda works.  Parameter page looks terrible and I am getting an error in the javascritpt behind the scene.

Any suggestions.....  You did answer the question, so I will give you the points.

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
I agree the Crystal default parameter page is not great.

What javascript error?  Is it code you wrote or from Crystal?

mlmcc
Rog DSQL Developer / Web Development / Business Analysis
CERTIFIED EXPERT

Author

Commented:
No code I wrote.  I will look into it.  I have a Master Page and this report is a content page, so maybe the parameter page doesn't know how to operate in this fashion.


Roger

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.