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

Globally replace one field for another

Status
Not open for further replies.

allyson1

Technical User
Apr 5, 2009
27
AU
I have a parameter field that is used MANY times in my report and now I would like to replace that field with a database field. Is there any way to replace all instances of the existing field with the new field, other than manually of course. The report is written in version 10, but I also have access to version XI.
Thankyou.
 
Hi,
What is the parameter field used for? It is unusual to have a parameter field appear multiple times in a report..Can you explain further?



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
I have a report that has two parameter fields, project number and template name. This report then has 30 subreports, and one of the linking fields is the {?template name}. Then within the subreports, this {?template name} is used for conditional suppression, conditional text displays, formulas etc etc etc. Basically the main report has just a few database fields, then based on the value entered into the {?template name} field then you will see a report with just one of the subreports.
This report is now to be used within a Lab system, and it cannot pass parameter values, so now instead of using a parameter field, I can use a database field. Now the challenge is to work out how to replace all the instances of where the parameter field has been used with this new database field.
Many thanks for viewing this.
 
If you're directly showing the parameter field, then no. Except possibly you could fiddle the parameter to pick up the database value. I've never used database values in parameters so I can't advise in detail.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
If you change the datatype of the parameter, it will cause errors wherever the parameter is used (except if it were placed directly on the report to display the value), and then you can replace the parameter with the field value in each case. I would then check to see if the parameter still had a tick mark next to it in the field list. If so, you are looking for the parameter placed directly on the report, probably in the report or page header.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top