Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing A Parameter multiple times

Status
Not open for further replies.

mgkSHA

Programmer
Jul 12, 2002
126
US
I have a working date range parameter that prompts the user to give a start and end date. After the user selects their date range and hits the command button, the Crystal Report opens with the found data. My question is, how do I get the parameter prompt to pop up EVERY time the report is initated. Right now, if the user sets a parameter, views the report, and then closes the report, the parameter value becomes default(it does not appear again unless you restart the application). How can I get the parameter to change everytime the report is viewed. Thank You

Martin
 
Using what application?

Crystal Reports will always show the parameter prompt if you hit the lightning bolt, perhaps you're using some external code or another application which uses Crystal.

I'd suggest posting specifics about the environment (versions of software used), and if it's regarding changing external code which uses Crystal, there are other Crystal forums that should yield better results (Crystal Reports 3 Integrate).

-k kai@informeddatadecisions.com
 
I am using Crystal Reports, version 8.5 and Visual Basic 6.0 in this project. I am using the autoform provided when you create a new Crystal Report..(if you create the report, the software asks you if you want to create a form to display the report...I am using that form to show the report). I do not have any external code.

I do not see this lightning bolt..can anyone please tell me how to continueously pass this parameter...am I missing something? I am stumped here. Thanks

Martin
 
Martin,

SV is right - the best place for this question is CR 3 - Integration forum, however lets give it a go.

Is the parameter from the VB form or is it from Crystal Reports? I suspect it is from the VB form, which is why you are not getting prompted every time.

Make your VB form have only one object, a button that views the crystal report. Then place your parameter fields on the Crystal report itself. You will not have to pass any parameters in this case, it will simply ask you for them every time you view the reports.

Let me know if this helps. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
I will try that way. How do I get the Crystal Report to open by itself with no form? In the command button I have form1.Show (Form one being the form which has the report). Let's just say the reports name is CrystalReport1, how do I get the command button to only open the report. Sorry, I am very new to Crystal Reports and I trying to work through things.

Also, I am trying to get the download for making .exe's out of my Crystal reports so all users can access them. Again, I am using version 8.5, where can I find this. I went to the Crystal Enterprise site and I couldn't find it. What do you recommend, thanks for all your help.

Martin
 
Ok, since you are integrated with VB do you want to make a VB executable or a crystal report executable?

What are you integrating your report into VB for? Just to make an executable? If that is the case it is much easier just to make a crystal executable.

The doewnload is here, you must have Developer version of crystal to use this:


Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top