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

parameter with autonumber?

Status
Not open for further replies.

juliofazendeiro

Programmer
Jun 3, 2002
5
PT
hi!

Can you please tell me if it is possible to have a parameter of the type autonumber?

thanks.
 
Autonumber generates numbers in the database (as Primary Keys).

If you want a parameter that searches such a database field, just design it as a numeric data type within Crystal.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
thanks for your response.

but that doesn't resolve my problem. I will explain to you:
I have to make a report that is a Bank Transfer List, but the program that i'm working is a 3rd party and i can't add or remove fields from the database.
This Transfer List is to be numbered every mounth and at the same day i can have several transfer lists.
Have you any idea how to make this? the only way that i remember is to ask the operator the number in a parameter. What do you think?

Thanks in advance.
 
I do not understand your use of the term "autonumber" as oppossed to "number". Perhaps you can explain more.

You can make a parameter with a data type of number, then tie the parameter into the record selection formula so that the user sees only those bank transfers that match that number will be n the report.

Is this what you want to do? Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
What i want to do is this:

I want to number the report
ex: nº 1
nº 2
in a way sequential, without changing the database.
this numerator is going to be reset mounthly.

sorry for my bad english and thanks for your help.
 
Insert, field object, special field, record number. No formula required.

Please be advised that if you have consitionally suppressed records, they too will be numbered and you will get funny results such as 1,2,11,15, etc instead of 1,2,3,4. If this is the case post back and we can solve that one. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Thanks for all your help i resolved to ask the operator the ref. required to the "transfer List".

Once more, Thanks.

Regards

Julio
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top