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

Create Alias Table 1

Status
Not open for further replies.

kristal9

Programmer
Feb 15, 2007
95
US
Oracle Database and CR9.

I need to add a table to my report twice. For example I have an "ACCOUNT" table. My accounts have a parent child relationship to other accounts.

Previously in CR8.5 when i added a second table, crystal would force me to rename the second table. So, normally I would simply change it's name from "ACCOUNT" to "PARENT".

CR9 will bring the second table in and autmatically rename it "ACCOUNT_1". I can still build the report in the same ways and everything works fine. I'm just sort of particular about the logic in my reports and would really prefer to name the table myself.

I can't find anything in the settings or options that allow me to do this.

It's not anything mission critical ... just a matter of preference. Has anyone seen a way to do this in version 9?

 
On your database expert highlight the table you want to rename in the selected tables window and hit F2 to rename it...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top