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!

Problem with parameter field

Status
Not open for further replies.

dvknn

IS-IT--Management
Mar 11, 2003
94
US
In crystal reports how can I add a create a parameter field that would take a value say 100 and keep incrementing each time a report is printed. Can any one help me please


 
Would you be happy with a solution that increments a value each time a report is PREVIEWED (not each time it is printed)?

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
No I want to show it in the report when it gets printed
can you help me
 
It can be shown on the report when the gets printed.

The question is: can you live with a solution that increments the number each time the report gets previewed?

I don't know of a way to achieve what you want if you must increment the number when the report gets printed.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
If you have CR 9 and a SQL database, or are able to use a Stored Procedure, you can accomplish this.

In CR 9 you would write SQL to include incrementing a number each time the report is run, writing it to a table, and then selecting it as part of the result set afterwards, the same theory applies with a SP.

This would not allow for failed executions, depending upon where the failure was.

Otherewise you might use some front end code in VB or whatever to do this.

Adding technical information to your posts will help people identify solutions.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top