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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how Efficient to Print Crystal report with parameter

Status
Not open for further replies.

123ASP

MIS
Nov 2, 2002
239
US
hi, I have a report that have 3 parameters (partnership,project, and investor)
I would like to print a hard copy of the report, can is the following doable.
lets say for each investor parameter in some kind of collection, print me a hard copy report.
The question, if this is doable, where I can save the parameter collection and how can I call the function to print a hardcopy of crystal report.

I really do not know if I can do what I have just explained.
if anyone has feedback, please do not hesitate to fill me. thanks again
 
Not sure what you want here.

You can use parameters(Insert->Field Object->Right click parameters and select New, and default values will allow you to prefill them), and you can add them to the record selection formula to filter data (Report->Edit Selection Formula->Record and use something like:

{mytable.myfield} = {?ParmName}

And you can display/print out the parameters chosen by the user by using:

join({?ParmName},", ")

To print a report, click the Printer icon in the viewer, if you're looking to automate this, either use Crystal Enterprise, write code or use a third party product, such as listed here:


-k
 
hi, I am using the prameters as you indicated, the issue I am facing is that I have over 50 investor that I need to provide the report with as a parameters, I manually insert the parameters then print the report. This is a time consuming task and what I am looking for is provide a list of investors then loop through the list and send a print command along with the investor name to crystal report to print the report. So if I have 200 investors, I create a list once, then run the code which will print the report automatically.
If you are familiar with something like this, I appreciate your assistance.
thanks,
Ali
 
Why not make your parameter for investor a rang parameter that accepts multiple values.

Group your report on investor then when you run the report you can specify your range of investors, print the report and have it grouped by investor.

You could also set the options to make sure each new group starts on its own page. This way you woudl only need to collate the printout(s)

just a thought

Cheers,

SurfingGecko
Home of Crystal Ease
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top