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!

Record numbers not changing in report

Status
Not open for further replies.

Crystalamateur

Technical User
Jul 27, 2005
19
GB
Hi,
I created a report that pre-populates a form from our database using our unique reference numbers. In the parameter field I set the value type as 'number' and 'allow multiple values'. When you refreshed the form and entered more than one reference number you used to get different forms for the different supporters relating to their unique reference number - this would show their name and address as well as their unique refernce number.
We have just moved our database to a new server and I have updated the ODBC and database connection for Crystal. Now when we enter multiple reference numbers the forms show the correct names and addresses, however, the reference number remains the same for all the records- being the first number entered. Is there anything I can do to recitify this.
I am using Crystal Ver 10
many thanks
 
How are your records linked? And what are you displaying? Is it the detail-line value?

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP [yinyang]
 
Hi, our records are not linked.
I am displaying our supports name & address, current date and unique reference number.
Sorry, don't quite understand detail-line value.
All the information is shown in the details section of the report.
Thanks
 
Do a test report showing the raw data. That may give a clue.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top