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

Multiple instances of same table

Status
Not open for further replies.

FireGeek21

Technical User
Dec 12, 2007
218
US
In Crystal Reports XI, can you pull in multiple instances of the same table? If so, I understand you would probably have to give each an alias. How would you go about linking? Selection Formulas? Can anyone give an example of how to do this? THANKS!

RSGeek
 
Just add the table again and Crystal will prompt with an Are you sure you want to add this table again? Just click yes and it will be added with tablename_1.

In Database expert you can rename to make it more meaningful.

Ian
 
Thanks Ian for your response.

I already did this and renamed each table. My record count is inflated and was troubleshooting why this could be. I am familiar with pulling in the same table multiple times with Report Smith but wasn't sure if it could "legally" be done in Crystal.
 
Have you joined table in on the linking screen in database expert.

If not you will have a cartesian join and gets a huge dataset returned.

Ian
 
Ian, yes I did link them. FSReport, we are unable to create a view on the database (long story as to why).

I think the issue is in OLE, there is a Command with PAEMPLOYEE, EMDEPEND and EMPLOYEE already linked. BENEFITS is then brought in twiced (renamed each time - HL and DN) and HRDEPBEN is also brought in twice (renamed each time HL_DEP and DN_DEP).

In rebuilding this in ODBC, I am attempting to recreate the same setup. So, in replicating what was build with Command, I am bringing in PAEMPLOYEE, EMDEPEND and BENEFITS each separately and linking 1:1 between PAEMPLOYEE and EMPLOYEE and 1:many between PAEMPLOYEE and EMDEPEND.

The next join is 1:many PAEMPLOYEE to HL and 1:many PAEMPLOYEE to DN. Finally a 1:many HL to HL_DEP and 1:many DN to DN_DEP.

The record count is seriously inflated and I need to bring it down. Anyone experienced in converting Lawson OLE reports to ODBC???

RSGeek
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top