Table linking problem in Crystal

[Former Member]

Ok first i want to say that im not using a standard SQL connection. I have to use something call TTX although this problem may be addressed similarly.

Basically ive made connections to two TTX tables similar to having two seperate SQL table connection.

Now i have a forumla in this subreport...the formula has a field which requires these tables (for ex Contracts and ContractInvoices to be interjoined on ContractID)

Thats not that hard to do in "links" from database expert. Just tie Contracts and ContractInvoices together problem solve right? no =(

The problem exist is that one of the other fields that make up the formula requires it to NOT be interjoined..so basically im clueless as to what to do here.

Crystal only allows linking in one area as far as i know and i dont know how to disable the linking of tables through formula or something

any help would be greatly greatly appreciated!

thanks

Carl

[Former Member · Accepted solution]

Also i would like to mention that there is no way to use Stored Procedures or Views with the TTX connection..i know that solution is possible with SQL but here it cannot be done to my knowledge.

[former_member183750 · Accepted solution]

Post moved to the SAP Crystal Reports - Legacy SDK

You're using a technology that was retired over a year ago. TTX files were essentially a schema that you'd build the report off of, then pass a recordset to the report. Using two TTX files, while workable, was never a good idea - partly due to the reason you have run into.What you may want to do, is consider creating one TTX file that would fulfill the requirement, then pass a recorset that matches the TTX to the report.

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces